Setting Page Breaks

[junction123]

Hi

I need to correct the page breaks in the report. When the report is exported to PDF/XLS, the page break should happen after the report footer on each page. Currently it breaks before the report footer on the same page.

Can I set this while exporting or is there a feature/formula in Crystal that I can use?

Thanks in advance!
junction123

 

[synapsevampire]

First, there are no page breaks on each page of the report for the Report Footer, the report footer only prints at the end of the report, you might be thinking of the Page Footer.

And is this to say that you ONLY want the break during export?

Reports can't be conditionally formatted based on export alone from within Crystal, and the version of Crystal is very significant, as with most software packages when trying to resolve an issue.

One solution I've used is to supply a parameter asking if this is for export at runtime, and then conditionally format based on the response, In your case it might be in the New Page After/Before for whatever section that you're interested in:

If {?ExportParm} = "Yes" then
true
else
false

Also note that the service packs often address exporting concerns, so try applying it:

http://support.businessobjects.com/fix/hot/si75/?ref=default.asp_selectlist

In future posts, try to minimize the text descriptions and supply technical information, such as:

Crystal version
Database used
Example data
Expected output

-k

 

[junction123]

I will be more Techno-specific now.

Version: Crystal Reports 9.
Database Sybase 12.x

I have shown a couple of rows,Page Footer of Page 1 and Page Header of Page 2. Below is an example of both the required printable format with Page Breaks as well as the current report with the Page Breaks at the improper section of the report.

REQUIRED FORMAT

PAGE 1

CKC SV and SG Accounts in a Relationship

FWG SV 03723821 LYNNE CLAYMAN C/F
FWG SV 03723965 ROBERTA CLAYMAN IRA

S:\EQDEV\CrystalReports\WrongBooks.rpt Printed On : 3/19/2004 2:05:48 PM
------Page Break------------------------------------------- PAGE 2
CKC SV and SG Accounts in a Relationship
FWG SV 03803179 MORTON CLAYMAN TRUST
FWG SV 04103021 MORTON CLAYMAN IRA


S:\EQDEV\CrystalReports\WrongBooks.rpt Printed On : 3/19/2004 2:05:48 PM



CURRENT FORMAT

PAGE 1

CKC SV and SG Accounts in a Relationship

FWG SV 03723821 LYNNE CLAYMAN C/F

---------------Page Break-----------------------------------
FWG SV 03723965 ROBERTA CLAYMAN IRA

S:\EQDEV\CrystalReports\WrongBooks.rpt Printed On : 3/19/2004 2:05:48 PM


PAGE 2
CKC SV and SG Accounts in a Relationship
FWG SV 03803179 MORTON CLAYMAN TRUST
-----------------Page Break---------------------------------
Page 3

FWG SV 04103021 MORTON CLAYMAN IRA


S:\EQDEV\CrystalReports\WrongBooks.rpt Printed On : 3/19/2004 2:05:48 PM

I also installed the service pack 2 but that did not help. I will try using the parameter.

Thanks in advance!
junction123