Sage 100

Crystal Trick for using suppressing Sub-reports I had a report (Crystal Reports XI R2) that contained one subreport that passed values back to my main report. I wanted to suppress (not show) the subreport on my main report; however I wanted to use the values from the shared variables (4 total shared variables). When I suppressed or hid the section in the main report where my subreport is, then it clears (zeroes) out my shared variable values. So what do you do..... Well I found the answer!! What you need to do is on your subreport hide all of the fields. On the main report right click on the subreport and click on the last tab. Check the suppress blank subreport checkbox. This will allow your shared variables to still run without showing them. Their will still be a blank space on your main report. If you want to get rid of that go into the section export, and for the band which has the subreport in it, select underlay following section and suppress blank subreport. Now you will not have an empty space either.

Good tip Jim! If the blank subreport overlaps something in the next section, you can also format it to not grow (deselect the Can Grow checkbox on the Common tab) then make it as small as possible.

http://community.90minds.com/2012/10/25/suppressing-a-sub-report-in-crystal-but-still-use-variables-embedded-there-in-your-main-report/

Thanks Jim for this tip. Sub-reports with variables are always a challenge which is one of the reasons I like to use the ""MAS_Mirror"" method. I just find it much easier to do the necessary queries in Access.