Results 1 to 3 of 3

Thread: Suppress Group Header

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2006
    Location
    UK
    Posts
    96

    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!

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    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.

  3. #3
    New Member
    Join Date
    May 2008
    Posts
    1

    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
  •  



Click Here to Expand Forum to Full Width