Page Header Suppression

[oanion]

crystal Reports 10
SQL Server 2000

I have a report that is 3 pages for 1 record set. I only want the page header to show for the 1st page of each record. For example, I want a page headers for the following pages 1, 4, 7, 10, ....etc until the last record. How can I accomplish this. It seems that I would need some type of loop/counter. Any help will be greatly appreciated.


Thanks

 

[dgillz]

How can a single record take up more than a page? Isn't it just one line?

Or do you literally want pages 1, 4, 7, 10, 13, etc until the end of the report?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[oanion]

The report actually a 3 page legal letter and the fields from the records are filled into the report. For instance, if there are 100 records, there are 300 pages. I need the page header displayed for every 3 pages after page 1.

 

[kwalters110]

Using alittle bit of modulus arithmetic should do the job. You are going to have to go into the section expert and selec the Page Header section. Then click the x+2 button next to suppress. The following formula should do the trick

if (PageNumber - 1) mod 3 = 0 then false else true

That will show the Page Header every three pages starting with page 1. Adjusting the 3 to a value n will show the page header for every nth page. I hope that helps.

-Keith

 

[oanion]

Worked Perfectly. Thanks a Million