|
-
Jun 15th, 2007, 04:43 AM
#1
Thread Starter
Lively Member
Suppress Group Header
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!
-
Jun 15th, 2007, 12:08 PM
#2
Re: Suppress Group Header
I don't think this is possible. The Group Header is printed before the sub-reports execute and Shared variables are only available during the "WhilePrintingRecords" stage. The Group Footer could be suppressed but not the Header.
-
May 15th, 2008, 04:50 AM
#3
New Member
Re: Suppress Group Header
ok, it's all right
you must insert the value in every section suppress of the subreport.
Regards
Pepe
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|