In case of a master report containing various subreports it is sometimes very useful to have a field containing the common information for all or some of the other reports.
I encountered this problem when making visible or invisible images in the report based on a specific group of products. The solution I have found might not be the simplest one.
First I querried the database to bring the common shared information into a dataset of the master report in order to be further checked by the contained subreports.
In the master report I then set a hidden textbox containing the field value from the query, then for each of the contained subreports, in their Properties tab of Parameter I added a parameter with the value "=First(Fields!txtBoxName.Value,"paramName")" .
Then , in each subreport , in the Report menu, Report Parameters menu item, add the parameter name, non-queried and with none default value.
The Visibility property of the images in discussion can then be set using the Expression : =IIF(Parameters!paramName.Value ="stringReturnedByQuery",False,True)
When the master report is run it sends the queried hidden textbox value as a parameter to all subreports configured to see it and these ones can use it to set the visibility of the images true or false depending on the value returned by the query in the master report.
Comments are closed.