dollypatel
asked on
Extra Column issue while exporting crystal Report XI into excel
ok i have Crystal Report Xl on my pc....i am using recrystallize to conver the .rpt report for web. when i try to export the crystal report XI thru web into excel i have extra column included. can you please help me out how can i get right fomate export. if i export straight from crystal report XI is working fine just the web is not!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No. You'll need to tweak it as I described. It's unfortunate but Crystal has never been able to get the desktop viewer and the web viewer and the export dll's to produce identical results.
frodoman
frodoman
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
Hi,
For days I followed the recommendations on documentation, and still - after running and exporting it through a link the fields would go in the wrong columns, or wrap, or the rows would squish together or hide. I checked and double checked and re-traced my steps - still, the problem persisted.
Finally, I discovered that CHANGING the size of the fields would make it work.
The fields had been sized the same, however, the problem was that they were sized too small. My report has 27 fields to display in the detail, I had the fields sized at .400 width and 0.100 height. Changing the width to .450 corrected the report.
Here are the steps I took (most were adopted from articles and help) I hope these details help. I posted this on my own open question as a solution.
I removed the grouping and subtotals, they become obsolete in a new sort anyway.
How many fields do you have? What size are they?
Check these things:
In the Crystal Report::
File Options:
Check snap to Grid
Uncheck Free-format
Grid size .50
File Layout:
Check all for design and Preview,
show Rulers, Guidlines, grid, ect
In Design/preview
View at 200% to see the grid
Font size (in my case) Times New Roman 8 (heading and detail)
all headings centered and bold
all fields size width .450
all fields size height 0.100
Snap fields to the ruler.
Align the ruler to the grid.
don't leave grids between field columns.
Adjust the section size to be a little bit bigger than the fields but not too big or you will get extra rows in the excel.
Section Expert:
uncheck Free form placement in all sections.
Crystal Report XI Export Options are set at :
Microsoft Excel 97-2000 (xls)
column width based on objects in page header
Export page headers and page footers "One per report
Check Show Guidlines.
Run the report from a link to test
After the report displays, export the report
I used Excel and it exports perfect with no wraping, no merging, no hidden rows, no blank rows (unless they are blank on the report)
For days I followed the recommendations on documentation, and still - after running and exporting it through a link the fields would go in the wrong columns, or wrap, or the rows would squish together or hide. I checked and double checked and re-traced my steps - still, the problem persisted.
Finally, I discovered that CHANGING the size of the fields would make it work.
The fields had been sized the same, however, the problem was that they were sized too small. My report has 27 fields to display in the detail, I had the fields sized at .400 width and 0.100 height. Changing the width to .450 corrected the report.
Here are the steps I took (most were adopted from articles and help) I hope these details help. I posted this on my own open question as a solution.
I removed the grouping and subtotals, they become obsolete in a new sort anyway.
How many fields do you have? What size are they?
Check these things:
In the Crystal Report::
File Options:
Check snap to Grid
Uncheck Free-format
Grid size .50
File Layout:
Check all for design and Preview,
show Rulers, Guidlines, grid, ect
In Design/preview
View at 200% to see the grid
Font size (in my case) Times New Roman 8 (heading and detail)
all headings centered and bold
all fields size width .450
all fields size height 0.100
Snap fields to the ruler.
Align the ruler to the grid.
don't leave grids between field columns.
Adjust the section size to be a little bit bigger than the fields but not too big or you will get extra rows in the excel.
Section Expert:
uncheck Free form placement in all sections.
Crystal Report XI Export Options are set at :
Microsoft Excel 97-2000 (xls)
column width based on objects in page header
Export page headers and page footers "One per report
Check Show Guidlines.
Run the report from a link to test
After the report displays, export the report
I used Excel and it exports perfect with no wraping, no merging, no hidden rows, no blank rows (unless they are blank on the report)
ASKER