| Satish |
|
|
Reply with quote | #1 |
I'm exporting my report (Crystal Reports X1) to excel using Microsoft Excel 97-2000(XLS) format. The problem is in excel it occupies more than row per record. I've to use can grow option for the detail fields as the text cannot be accomodated in one line . Also I cannot use the data only option while exporting the report to excel as the requirement states so. Is there anyway I can ensure there is noly one row for one record in excel using the Microsoft Excel 97-2000(XLS) format? |
| |
| Aaron Chandler-Worth |
|
|
Reply with quote | #2 |
When it comes to Excel formatting, extra columns tends more to be the problem, but if you're having problems with extra rows here are two things you should try..
Turn off the 'Can Grow' formatting option. It doesn't matter in Crystal whether or not you can see the data in the field. When exported to Excel you should be able to, after the fact, resize the column and all the data will be there.
Select all section objects then right click on one of them and go to size, same height to make sure they are all the same height. You'll also want to do the same thing but choose align, align tops. You'll then want to make sure the bottom of the details sections is snugged up against the bottom of all those (newly aligned and same sized) fields.
this should eliminate all extra rows.
|
| |
| Satish |
|
|
Reply with quote | #3 |
If I turn Off the 'Can Grow' formatting option the truncated data does not appear in excel either. The text comes from a database and can span many lines |
| |
