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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppression cause multi page report to becom one page 1

Status
Not open for further replies.

dtrumbower

Programmer
Feb 16, 2001
53
SE
I have a report that as 13 detail lines. I want to suppress the top six on odd pages and the bottom seven on even pages.

When I put this formula in the suppression fomula: Remainder (PageNumber,2 )<> 0 , My mutli page report only prints one page.

For testing purposes I have put this formula in only the first detail line and it stills only prints one page. Comment out the fomula and I get multiple pages again. The report is bringing back over 2000 records and the style is a 4up label.

Thanks
Dwight
 
What do you mean by 13 detail lines, do you mean details A through details M, or do you mean room for 13 lines on each page.

I can see some circular reasoning problems in suppressing records (which effects the length of the report) based on a page number and then generating the pages based on which records are suppressed. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
I mean 13 lines A through M.

It seems if you suppress the the A line, the report stops with only one page. If I don't suppress the first A line everything is fine. My solution is to have a blank line A and do suppression formulas on the rest. I don't remembering crystal working like this but it could be just for labels.

Dwight
 
I just tried it with an A and B sections, and I can conditionally suppress A on odd pages with no problem. Not sure what you are running into. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Sorry, it IS a &quot;feature&quot; of labels reports. Just was able to duplicate your problem. Mine stopped no page 2, whenever the first suppress comes up. Glad you got a workaround. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
But only if it based on page number, other conditions don't have the same behavior. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top