• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3187
  • Last Modified:

Crystal Report Page Header Suppression

I have a report created in VS 2010 that is basically a letter containing information from a database.  The report contains multiple subreports.  Here is how the report is setup:

Report Header (suppressed)
Page Header 
    Company Logo
Details a
    Data from record
Details b
    Data from record
Details c
    Data from record
Details d
    Data from record (suppressed if blank)
Details e
    Data from record
Details f
    Data from record (suppressed if blank)
Details g
    Data from record
    Text
Details h
    Subreport (can contain multiple records with each record on a single line)
Details i
    Subreport (can contain multiple records with records displayed in 3 columns)
Details j
    Text
Details k
    Text
Details l
    Subreport (suppressed based on field in record; set to start on a new page;  can contain multiple records with each record starting on a new page)
Report Footer (suppressed)
Page Footer (suppressed)    

Open in new window


With the way the report is setup, the Company Logo only prints on the first page.  The "letter" portion of the report can be 1 or 2 pages.  If a field in the record contains a certain code, the subreport in Details l prints as separate pages for each record in the subreport.  My problem is now I am asked to make sure the Company Logo appears on the 2nd page of the letter if there is one but not on the pages generated by the Subreport in Details l.  

I have no idea how to accomplish this and would appreciate any help!
0
dyarosh
Asked:
dyarosh
1 Solution
 
mlmccCommented:
Insert a new section below details K

Add a formula to the report header
WhilePrintingRecords;
Global BooleanVar SuppressPageHeader := False;
""

In the NEW details l add a formula
WhilePrintingRecords;
Global BooleanVar SuppressPageHeader;
SuppressPageHeader := True;
""

In the SECTION EXPERT
Select the PAGE HEADER
Click the formula button to the right of SUPPRESS
WhilePrintingRecords;
Global BooleanVar SuppressPageHeader;
SuppressPageHeader

mlmcc
0
 
dyaroshAuthor Commented:
You are AWESOME!!! Thank you!!!
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now