Distribute Print ActiveX control to masses

How do you go about distributing the print activeX control to the masses? What is its name? I there an msi?Found a cab file named RSClientPrint.cab in folder C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin. Extract the contents of this cab file into a separate folder and manually register RSClientPrint.dll. Speak up if you know a better way to do it.

Displaying print statements of Stored Procedures in SSIS Logs

Hi

I have few print statements in a stored procedure that gets called from the SSIS package. How do I make sure that these are captured in the SSIS log meaning how do I get them to be displayed in the Package Explorer window when running from the Business Intelligence Studio IDE.

Not possible. Print statements are diagnostic in nature and are not part of the returned data set, which is what gets exposed to SSIS.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1229612&SiteID=1

Displaying Print Debugging from Stored Procedure immediately

I am attempting to debug a very long stored procedure, for this I inserted many print statements at key points on the procedure, but I find that once I do an exec sp_name I only get the print statements show in the message tab only after the full execution or cancellation of the stored procedure.

Is there any way to force the message tab to display the messages mid execution?

One way is to use the raiserror command with a severity of 10 and a "with nowait" option. This will not cause an actual error to be raised, as you can see by running this code:

begin try

raiserror('Progress message', 10, 1) with nowait

end try

begin catch

print 'here'

end catch

Ron Rice

Displaying “Print” and “Print Preview” icons in the toolbar

Hi,

I'm using the "ReportViewer" control to display a report. I can see the "Print" and "Print Preview" icons in the toolbar when I'm in the "Preview" environment. When I run the report and when I use the "ReportViewer" I cannot see these 2 icons.

Can some please advice me how to view these icons.

Any help will be greatly appreciated.Install MSRS SP2, your problem will be solved.

Display XML Hierarchies in Reporting Services

Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse | Find messages by this author
To all,
I have read several posts that say SQL 2005 Reporting Services does not
display hierarchical XML data very well. It must first be flattened.
Is this true?
In my scenario, I capture hierarchical data and store it in an XML
column in a SQL2005 table. Now I need to display it in a Server Side
Report using SQL 2005 Reporting Services. This data will have any
number of descendants that I need to ensure is intact and visible on
the report.
What are my options to get it done?
And if it really can't be done in Reporting Services what other
approach would be worth looking into?
Thanks in advance,
RobI think Asif Sayed has an example on Code Project that may help you. The
dataset is not based on xml data but demonstrates a parent/child
relationship.
http://www.codeproject.com/useritems/RecursiveData.asp
Steve MunLeeuw
"Rob" <rclassen@.IDSTechNet.com> wrote in message
news:1161266421.322891.145750@.i3g2000cwc.googlegroups.com...
> Reply | Reply to Author | Forward | Print | Individual Message | Show
> original | Remove | Report Abuse | Find messages by this author
>
> To all,
> I have read several posts that say SQL 2005 Reporting Services does not
>
> display hierarchical XML data very well. It must first be flattened.
> Is this true?
>
> In my scenario, I capture hierarchical data and store it in an XML
> column in a SQL2005 table. Now I need to display it in a Server Side
> Report using SQL 2005 Reporting Services. This data will have any
> number of descendants that I need to ensure is intact and visible on
> the report.
>
> What are my options to get it done?
>
> And if it really can't be done in Reporting Services what other
> approach would be worth looking into?
>
> Thanks in advance,
>
> Rob
>

display vocuher report twice with same data on CR 8.5

Hello ,
I need to display a voucher report twice in crystal reports 8.5 . I DONT want to print them on printer but display the same report twice with exactly the same data only with the 'COPY' printed in the 2nd voucher in crystal report.

Pls tell me how to write the formula n in which section.I am new to crystal reports n dont know how to write formulas in such a situation!
Pls help me

I get the following result set from my Stored Proc attached to report.
51 XML Markup Language Active 128 Copy
53 Team-Woodbury Audit Active 128 Copy
55 Team 4 Beebe's Team Active 128 Copy
56 Team 5 Bill's Team Active 128 Copy
51 XML Markup Language Active 128 Original
53 Team-Woodbury Audit Active 128 Original
55 Team 4 Beebe's Team Active 128 Original
56 Team 5 Bill's Team Active 128 Originali want to print twice in single page

Display Page Footer on first page only

Is there anyway to set-up the page footer of a report to print on the first page only?

I was going to try an IIF statement, but realized there is no visibility style property associated with the Page Footer section.

If you have any ideas, let me know.

Thank you,

T.J.

=iif(what you were doing [ie page =1 ], 'your text', '')

blank it out (the textbox or textboxes values) if it's not the first page... but i think if you're doing it on a textbox, you'll have Visibilitiy to work with.

|||

Thank you very much. I didn't even think of hiding the actual text boxes on the page footer.

Talk about not seeing the forest because of the trees.