Exporting reports to XLS

[keithm2008]

CR2008. I have several reports that the user wants to export to Excel and do some further manipulating and reporting. Presently, when the reports are exported some of the cells are merged and cause problems when they are being referenced in another worksheet within the workbook.
How do I get a *clean* export from CR without cells getting merged? Is this a formatting issue? I have tried Excel data-only many different ways and it is worse than exporting as regular Excel format.

For instance, the Sales Rep worksheet has a value I want to bring to the Summary worksheet --> 234020.31;
I see the following formula in the Summary worksheet cell: ='Sales Rep'!Y154:Z155 - resulting in a formula error.

Background: Reports have two groups and two subreports within them. The details are being suppressed. I am also using *underlay following section* for group footer #2a so that #2b prints in the same line. Group footer #1 is where I am having my trouble with the merged cells, but I believe this is not causing my issue.

Any ideas?

keith

 

[IanWaterman]

It will be because you have different cell sizes in the subreport.

By trial and error you must get the Main report and Sub Rep cells to line up in columns.

Best way to do this is use guides and anchor all cells to them vertically.

Ian

 

[chelseatech]

My Grid User Function Libary lets you have total control of where values appear in an exported CSV file. Works great across subreports as well

Download a trial version from my web site.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm