Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subreport header suppression 1

Status
Not open for further replies.

hassellhorse

Technical User
Aug 16, 2006
11
US
I have a subreport automatically print a secondary form based on certain criteria, the problem is it uses the header from the original form. I want to be able to suppress the header on the subreport/secondary form without suppressing the header for secondary pages.
 
Try using real technical terms.

Crystal doesn't have forms, secondary or otherwise, or secondary pages, it has main reports and subreports, and various sections within, making up terms only confuses people.

It also has report headers and page headers, I assume that you difficulty is that you want to print the page headers within a subreport, which Crystal doesn't do.

The standard means to cheat this is to create a formula in the subreport for use as a fake page header, as in:

if {table.field} = "*$#@NFAMXBNV--" then
"Blah"
Else
"Blahblah"

Insert this as a group, go into the group footer formatting and turn on the new page after, and use the group header and group footer as the page headers and page footers.

If this doesn't resolve, please stick with real technical terms and explain what sections you need in which report.

-k
 
Okay, I've got a crystal report and I've entered a subreport in the report footer that has conditional formatting based on my details section to print the subreport which is a separate crystal report only if the specific criteria is met. The Page Header from the original report is also printing on my subreport. I want the page header suppressed on the subreport ONLY.
 
Ahhh, right click the section that the subreport is in and select insert section below and move the subreport into this new Report Footer B section.

Now create a formula for the Report Footer A (RFA) section of:

whileprintingrecords;
Booleanvar Suppressme:= True

Then right click this RFA section and select format section->and select the new page after.

Right click the page header section in the main report and select Format Section and in the X2 next to Suppress place:

whileprintingrecords;
Booleanvar Suppressme

-k
 
AWESOME!!!! thank you it worked except for I now have the blank page printing before the subreport page. Is there a way to suppress the blank page?
 
SYNAPSEVAMPIRE HELP!!!! I have done what you suggested and now everytime I print the crystal report it prints a second blank page PLUS a blank subreport regardless of the conditional formatting. I have gone through and "suppressed all blank sections". Do you have any suggestions????

 
I gather that "The Page Header from the original report is also printing on my subreport." means the main report. Again, please try to avoid making up technical terms.

I would suspect " a subreport in the report footer that has conditional formatting based on my details section to print the subreport which is a separate crystal report only if the specific criteria is met." as being part of the prblem.

Or you may have New Page After/Before set inappropriately.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top