Page Break Buggy-er then usual ! 1

[wendas]

I have been thru the search on Page Breaks with no help.

I normally have no problem with page breaks using my Crystal/ VB6 / Sql combination. To get around printing a page break at the top of the report where you don't want it until the first Group break occurs I put the following formula into the formula area of a newPageBefore on the Group Header.

numberVar breakflag := breakflag + 1 ;
breakflag > 1;

This has worked for countless reports some which run over 50 pages.

This time, I have a report only 16 pages long. I set up everything as usual, and it works great with a preview.. But if I ask to skip the preview & just print the report, it prints the Page header, then page breaks and actually does not display any records from the first group! they are just gone! Then starts acting normal for all the other pages.

Here's the strange part, (Besides as I said, the report is fine for a preview..) If I do not change any logic of VB or Crystal.. But only reduce the amount of records/ or groups coming in by filtering down on the SQL Query... The print Report prints just fine! (it works up to page 9.. goes crazy at page 10)

If no one has an idea of what is happening.. Do you have any other way that I can skip the VB/Crystal page break bug.. Like a formula that can be use on the page break after? (Left without a formula it prints an empty page at the end of the report).. I hoped at end of file the record fields would be empty, they weren't.. I see no way to say if End of file don't page break..??

Any help on what's wrong.. or a work around suggestion.. Anything welcomed!!

Wenda Stephens

 

[goranm]

Hi !

Try this formula in the "X+2" for "Page break after"

not OnLastRecord

/Goran

 

[wendas]

Thanks so much that worked like a charm..
It may even be the code we use in future since it does not require the counting mechanism..

Wenda Stephens