Hello all.
I'm working on a problem I thought might be of interest to the group, so here it is. I'd like to be able to have the ReportParameters subreport display as collapsed when a report is run from the scheduler, and expanded when run by a user. I'm using GOOESOFT_REQUEST.[type] to determine this (values of f and b indicating a user running the report in the foreground or background; values of s and h indicating the report being a scheduled run).
In the ReportParameters report itself, I've set the InitialToggleState property of the ParameterHeader text box (which toggles the display of the ParameterValue text box) to the following expression:
=IIf(Parameters!request_type.Value="h" Or Parameters!request_type.Value="s",False,True)
This sets the little square to have a - instead of a +, but it doesn't affect the behavior - the rows are still expanded, and can be clicked to collapse.
The closest I've come to what I want is using the Row Visibility property in the Details row which contains the ParameterValues text box. The "Display can be toggled by this report item" is already checked, and the ParameterHeader item is selected; I clicked the "Show or hide based on an expression" radio-button, and entered the following expression:
When the report is run with request_type = 's', the subreport is collapsed. However, when I click to expand it, I get a bunch of white space. It looks like it adds enough room for the records from the subreport to display, but the values are hidden.
Any suggestions? It seems to me like this should be possible, what do you guys think?
Now that I've explained what I'm trying to do, here's why. The parameters appear at the top of our reports, and in some cases they take up a good chunk of real estate. On reports that are automatically e-mailed out, they often go to people who don't really need to see the parameters, so it would be helpful to have them hidden by default. But when a report is run manually, we assume the user will want to see the parameters (and if that's not the case, they can hide them before printing or exporting).
Thanks in advance for any suggestions!
Nathan
Just an update:
We decided to address this by adding a "Display Parameters?" parameter to all of our local SSRS reports. This way the user can decide on a case-by-case basis whether or not they want to show the parameters, including scheduled runs. It required anyone who had already scheduled an SSRS report to re-schedule because of the additional parameter, but it's a solution we can all live with.