Problems to Export to Excel

[Andrea123]

Hi, I'm exporting a .rpt tp excel but when I export it, the column and rows mixed in excel. The information that i want that be in one row appers in two or three rows, and the same happened to the columms. What can i do?

 

[lmctech]

You can line up the objects inside of the report to the grid, and make them all the same size (one right under another).
That will help clean the majority of the output up.

 

[Andrea123]

When I insert the grid, it appers a default table. I do not want it. I just want my fields in its columns. but the problems it that are a lot of column and the labels are very large like "direccion correspondencia". and it mix the columns and when I make shorter the label, it downloaded incomplete like "direcc", when I allow the field multiline in excel looks very bad. I do not know what to do?

 

[CRCRCR]

Its called merge cells. Very annoying, but you can untick the merge cells, in the format cells options somewhere in Excel.
I realise that's not a solution, you want it correct to begin with.
Have you tried exported as Excel, data only?Failing that, playing with the widths of each column one at a time, exporting, and seeing the result. Then adding more columns. You'll soon see whats happening.

K.

 

[lbass]

There are rules about how to set up a report for export. You should attach each field and its corresponding label to the same vertical guidelines, with no spaces between the fields. Similarly, each field should be attached both top and bottom to horizontal guidelines, so that all four corners of each field are red. Then select all objects in the section->format->make same height->also align bottoms, and then move them the set of fields to the top of the section and bring up the bottom of the section to minimize height. Then export (I prefer the regular export, not data only)->select the section containing the fields to determine column width. If you do this correctly, there will be no columns between fields and no blank rows.

Note that you might need to have two versions of a report--one for export (because they don't necessarily display prettily in CR) and one for use in a CR display.

As far as labels being cut off, you have to play with the width in CR until the export includes all characters.

-LB

 

[dgillz]

The bigger question is:Why are you exporting to Excel at all? When I ask my customers about this, almost without fail the answer it so the user can further manipulate the data in Excel once it is there. Many users are very comfortable in Excel and have no trouble doing this.

My response is to then find out the exact end result the users are looking for, and to modify the crystal report to produce those results. This way there is no need to export at all, just run the report.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Andrea123]

Thank you