Hard Page Breaks missing when exporting to Excel Workbook using Crystal 2020

[dave_smith2]

When exporting to the Excel Workbook format from Crystal 2020, there are no hard page breaks inserted causing our application to be unable to properly read the workbook and split on page breaks.

To reproduce:

1. Set up a report in Crystal 2020 that contains a grouping section that creates a new page after the change in group value.

2. Export to Excel Workbook. Select the Create page breaks for each page setting in the Export Options.

3. Export. View the output in Excel using Page Break view.

The page breaks are all soft page breaks.

This works if exporting to Excel (.xls) format.

[DonWilliams · Accepted solution]

Hi Dave,

Support confirmed it's an issue so they are creating an internal case and will have DEV fix it.

Not sure when the patch will be released, shouldn't be too long though...

Thanks again for reporting it.

Don

[vitaly_izmaylov · Accepted solution]

The fix released in 4.3 SP05 and in 4.3 SP04 Patch7

[DonWilliams]

Hi Dave,

See this KBA for using the new format in code:

How to use the new CR 2020 export to Microsoft Excel(XLXS) in Visual Studio .NET code (new)

And be sure to use the latest SP from here:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

I pinged the Dev and CR guys to see if this is a known issue.

Don

[dave_smith2]

Thank you for the response and apologies for the delayed reply.

Our issue is with the CR Designer 2020. That is what we are using to export to the new Excel Workbook format. Once that works, we can then use the SDK to export.

The designer does not create hard page breaks, unlike when you export to Excel (.xls) format. This causes problems in that our application cannot read the page breaks appropriately. We are not using any code at this time. We need to get the Designer to generate the Excel Workbook output with hard page breaks using the procedure outlined above.

You can view the output using Excel Page Break view. The page breaks appear as dotted lines, which indicate they are soft breaks.

[DonWilliams]

Hi Dave,

Are you exporting from CR Designer?

What version of VS and CR .NET SDK are you using?

Seen this one:

How to use the new CR 2020 export to Microsoft Excel(XLXS) in Visual Studio .NET code (new)

Using the SDK what code are you using?

Does it work from the Viewer?

Don