How do I display the parameter Frame when I don't have parameters?

We have some reports do not have parameters and we want the “View Report” button (which is in Parameter Frame) to be visible, so the report won’t run until the user click on the button.
newbie_girlAsked:
Who is Participating?
 
John_BonConnect With a Mentor Commented:
There is currently no setting or property to do this within SSRS.  This has been suggested to Microsoft in the past, but this functionality does not yet exist.
As a work-around, you could put add a dummy parameter without a default value that doesn't allow nulls to prevent the report from auto executing.  However, this may look cheesy.
0
 
DavidMorrisonCommented:
Unfortunately I don't think this is possible. can I ask why you want them to click view report before display?
0
 
newbie_girlAuthor Commented:
Thank for your reply John and David,

I had tried to look at the Reporting Services CSS file (i.e. HtmlViewer.css) in (Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\Styles) but it does not seem to be the right way.

John,
I had tried adding dummy parameter but it does look cheesy.

David,
It is one of the management requirements to add it (if possible).

Thanks again.
0
 
John_BonCommented:
If your report has a grouping that can be expanded or collapsed, you could put a parameter named IsExpanded: with a Yes / No radio button to make it auto expanded / auto collaspe, when the View Report button is clicked.  Alternatively, you could add another column or two to the report and put a parameter Show All Columns:  with a Yes / No toggle button.  However, these would just be work arounds to try to make it look like the parameter has a purpose besides just being there to display the View Report button.
0
 
newbie_girlAuthor Commented:
John,
We are not going to proceed with it as long as it is not possible.
Thank you.
0
All Courses

From novice to tech pro — start learning today.