Hi
I have a report with a few cascading parameters. In my code I pass the value of the parameter to the report and set the flag to hide the parameter to true (isAdministrator).
ReportParameter dataEntity = new ReportParameter("DataEntity", "1", !isAdministrator);
Report.SetParameters(new ReportParameter[] { dataEntity } );
This works fine but as soon as I change any of the parameters the control viewer refreshes and loses my default value of the hidden parameter and sets it to the default I have set on the report when I designed it.
If I do not hide the "DataEntity" parameter the refresh works fine.
I need to hide this parameter or disable it so that the user can not change the value if they do not have permistion.
I have a similar problem with cascading parameters in reporting services. If the user selects an option from from a cascading parameter dropdown, it seems like the postback/refresh clears the report, even if the user hasn't pressed the View Report button yet. They want to be able to view the current report while selecting new lookup values. All my param lookups are populated thru sql queries. Is there any way to disable the refresh of the report from the lookups? We don't want to have to access/display the params outside of the reports (we are accessing/displaying them thru the url), the whole reason for trying reporting services was to simplify the reporting process. Any suggestions? Thanx|||HI,
I am having the same problem. Have you found a resolution yet?
Thanks,
|||No, in the end I am not hiding the parameter.
No comments:
Post a Comment