SSRS Hidden parameters on drill through
Hello, I have a pair of SQL 2008R2 reports which work as follows: 1. The Summary Report contains various parameters and displays summary data. Each row is a link to the Detail Report. 2. The link passes the summary parameters to the detail report. 3. The parameters passed are hidden, but the detail report also contains several visible parameters. 4. In report manager, the detail report renders correctly the first time. 5. If the visible parameters are changed and the detail report re-rendered, the hidden parameters are lost. 6. Visual Studio Preview doesn't work this way (re-rendering the report mantains the hidden parameters). Making the parameters visible fixes the problem, but the hidden parameters are extremely visually unappealing, I hate to expose the user to them. Is there any way around this problem? Thanks!
June 28th, 2011 11:58am

Hi, Can you please show us an example and reproduce on skydirve? This is because we have such senario and it is working fine, here is my explanation based on your question:- - We have all in total as 3 reports ( 2 main reports and 1 sub-report (link report) ) - We kept only 1 sub-report and made the sub-report dynamic so it can handle two different main report appropirately, (this is to rid of maintainence problems and using less space on Report Server DB) - ReportA (goes to)--->> SubreportAB --->> (returns to only ReportA as it came from ReportA originally), same way - ReportB (goes to)--->> SubreportAB --->> (returns to only ReportB as it came from ReportB originally) for above step we have created hidden parameter which goes to and fro from Main Report to Sub Report and Sub Report to Main Report with the same value. You can definitaly separate down the parameters independent to Summary Report and Detail Report which will help you to save your values based on your report rendering/execution. Hope that makes sense. Please let us know if I misunderstood your req. or your statement. Thanks KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 4:48pm

I figured it out. Report Manager works as designed. There was an implicit dependency between the hidden parameters and the visible parameters which caused the hiddens to reset to their defaults. It was just a matter of changing the order of the parameters. I would argue it remains a problem that Visual Studio report preview does not behave the same way :) Thanks!
July 6th, 2011 3:36pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics