Wednesday, March 7, 2012

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, Shyam
There are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.


Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

No comments:

Post a Comment