Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2011-03-17 : 14:10:22
|
| I have five reports that each have the company logo at the bottom. I added a boolean parameter called HideImage to each report with a default value of False, then set the Visibility on each image to Show or hide based on an expression, the expression being Parameters!ShowImage.Value. The image shows as expected when I run the individual reports. I added each report as a subreport to a new master report, and set the default value of HideImage to True. When I run the master report all of the images show even though they should be hidden. The other parameters on the master report are flowing down to the subreports, so I don't understand what the problem is. |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-18 : 10:52:07
|
| Did you go into the parameter list and "link" the parameters together? I don't have SSRS in front of me right now, but there is a section for each dataset where the parameters are listed out. If you go into each subqueries parameter list, are they linked to the master report's ShowImage value?Hey, it compiles. |
 |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-18 : 12:11:26
|
| Yes, in particular Step 5 in the "To specify parameters to pass to a subreport" part. Your subreport parameters should be pointing back to the main report's ShowImage parameter.Hey, it compiles. |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-03-18 : 13:11:50
|
| I just tried creating a new report with only the ShowImage parameter (Report B). Then I created a new master report (Report A) to hold Report B, and followed the same steps to map the parameter, and with these reports it's working correctly. It seems like it must have something to do with there being other parameters. I will play around with the parameters of the original reports and see if I can get them working that way. |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-03-18 : 13:41:48
|
| Okay, wow, it was just me being stupid. Somehow I was forgetting to add ShowImage to the parameter list in the subreport settings.Thanks AJ. |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-18 : 15:04:23
|
| Oh trust me, the first time I had to add subreports I was pulling my hair out. It never regrew....Anyway, I wondered if you weren't dealing with the same thing. Glad you got it working!Hey, it compiles. |
|
|
|
|
|
|
|
|
bug in SSRS 2008 subreports parameter flow?