Hello!
I am trying to set up a report so that a group header can be suppressed if there is nothing in the details for that instance, but it doesn't seem to be working.
My report is set up like this:
Group1 - Faculty
Group2 - Person within Faculty
Details a - Contains Subreport showing Person's books
Details b - Contains Subreport showing Person's Chapters
Details c - Contains Subreport showing Person's Conference Contributions
Details d - Contains Subreport showing Person's other Conference contributions
Details e - Contains Subreport showing Person's Journal articles
Details f - Contains subreport showing persons other work
Details g - Contains subreport showing person's exhibitions
On each subreport, I've created a summary on the id of the records to be shown and have then created a formula field to assign the value of that summary to a shared variable e.g.:
shared numbervar bookCount = Sum ({reportview_AllPubsBookDetailsByFaculty.Publication});
Back in the main report, I put a formula onto the Suppress part of the Group2 section expert:
If shared numbervar bookCount = 0
and shared numbervar chapterCount = 0
and shared numbervar textCount = 0
and shared numbervar nonTextCount = 0
and shared numbervar JournalCount = 0
and shared numbervar OtherWrkCount = 0
and shared numbervar PubExCount = 0
Then True
Else
False;
Basically, if a person has no details coming back in any of the subreports, i want to suppress the group header so their name is not shown on the report. I only want to show names of people that have details coming back in one or more subreport. However what is happening is that the group2 header is always being suppressed whether the person has records coming back or not.
Can anyone suggest where I'm going wrong?
thanks!
