Export data from crystal report viewer to excel
Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9135
Printed Date: 04 May 2025 at 6:36pm
Topic: Export data from crystal report viewer to excel
Posted By: rionaldo
Subject: Export data from crystal report viewer to excel
Date Posted: 16 Feb 2010 at 9:01pm
|
Dear Team CR, i have a problem about export data that i preview on crystal report viewer (FYI : i'm using CR embedded in Visual studio . NET 2002) when i export the report to excel,i got the result is not on a good format. looks like the column or cell in excel it was merged,,so i found problem to the result in excel's files. can u help me..how to export data from crystal report to excel with a good export result (the cell or column not be merged) thanks for the help. 
------------- Rionaldo Sirait |
Replies:
Posted By: lockwelle
Date Posted: 18 Feb 2010 at 6:46am
|
I don't know about vs2002, but CR does a horrible job of exporting to excel. You would think that CR knows that a field is a cell and to put the data in the same cell, but it doesn't. The solution, at least in CR XI is to set the cell size small. I can't seem to find it, right now, but I have done it in code.
HTH
|