I am trying to compare values in a column in main report with that of a subreport. I created a shared variable and the values are display properly in the subreport. Now When I create a shared variable in main report, it shows 0. I have made sure that subreport is in the section above shared variable in main report. Does suppressing the subreport might be creating that problem? I do not want to display the subreport. If I do not suppress the subreport, the report is too big to be displayed. Can anyone help?
Here's what you need to do:
1. Get inside the Subreport and suppress ALL sections of the subreport.
2. Go back to the Main Report > Right-click the Subreport > Format Subreport > Subreport tab > Check "Suppress Blank Subreport".
3. Go to the Section Expert > Highlight the Section that holds this Subreport > Check "Suppress Blank Section".
This should suppress the subreport and still show the shared variablue value on the Main Report.
Here's what I do in situations like this - sometimes one works and sometimes I have to use the other:
1. Do not suppress the subreport. Instead, put it in a section of its own and suppress the section.
2. If that doesn't work:
a. Make the font for all of the data in the subreport white on a white background.
b. Turn off "Can Grow" for the subreport and make it fairly small, in its own section.
Option 2 will not export to Excel cleanly, but it will look correct on the screen.