R – crystal report 9

crystal-reports

new page break is not working when exporting from Crystal report 9 using visual studio studio.net.
I have set the below options in crystal report 9 design

paper size is a3 and orientation is landscape.
I have created 2 report groups (date and org unit)
I want a page break after every new date and after every new org unit.
I have already set the new page after in group footer1 and group footer 2.

when i export to excel it doesn't break the page after each group is changed.
Can anybody help me to resolve this issue.

thanks
bby

Best Answer

I said this in another question regarding exporting to Excel:

If this was made with CR, I've found that if a report is going to consistently be exported to Excel, it's best to remove ALL formatting that CR has/does. Otherwise you'll get weird anomalies like what you're experiencing and will save you a lot of grief down the road.

What I've done for some of my users is create one report with no formatting, specifically for exporting, and one report with all the bells and whistles of CR.

Related Topic