Export to excel

[ridhirao22]

Using Crystal Reports 2008 with BEX query as data source

I am having trouble exporting the report to excel format and using Excel 2010

Issue 1:

When I export the report to excel and print the report one of the column is print in second page.

I am using the following page setting in crystal

Page: letter
orientation: landscape
left and right margins .20
top and bottom margins .25

Issue 2:
Page headers doesn't print on each page (export option checked) with page break doesn't print he report right through excel.

Issue 3:

Using keep group together so the group doesn’t split the data displayed into next page. This doesn't work right for me either.

It prints lot of empty pages and when the group is exceed the more than a page it still splits the data.


Any advice or suggest are much appreciated. Please help!

TIA,
RR

 

[Charliy]

When you export, specify constant column width and specify 100, this solves a lot of export problems - especially with merged cells.
If one of your fields is a subreport, then you're out of luck.
You can also try exporting as data only.

 

[ridhirao22]

Thank you Charily for your reply. I have a subreport with same format as main report. I tired specifying 100 with constant column width option in the export dialog box. but out of luck.