Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Exporting to Excel with subreports Post Reply Post New Topic
Author Message
duprekk
Newbie
Newbie


Joined: 04 Jan 2013
Online Status: Offline
Posts: 2
Quote duprekk Replybullet Topic: Exporting to Excel with subreports
    Posted: 04 Jan 2013 at 11:41am
I have the need to export my Crystal XI report that contains three subreports (all in the Details section) to a .csv or Excel file.
 
The info in the subreports, after opening in Excel, appears on a separate row just beneath the main report data row.
 
I need all the info in the Details section to be on one line once it is in Excel (just like it would be if I viewed it in Crystal Reports).
 
I've tried several different export formats - all do something similar.
 
I tried the Find/Replace Line Break suggestion found on this forums, but Excel 2010 can't find a Line Break in that worksheet.
 
Are there other ideas I should try?
 
Thank you in advance for any assistance you can give!
 
KKD
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 28 Jan 2013 at 6:39am
If I understand you correctly, you have a subreport that returns some piece of data on the same line as other data in your main report.  Is that correct?
 
The Excel exports in Crystal are really picky about formatting.  Here's what I would try:
 
1.  In the subreport, suppress all sections except the one that contains your data.
2.  In the subreport, go to File>Page Setup and set ALL of the margins to 0.
3.  In the main report, turn off the borders on the subreport. 
4.  In the main report, set the location of the top of the subreport to be the same as other data on the line.  If you have column headers, set the location of the left of the subreport to be the same as the column header that it is under.
5.  In the main report, set the height of the subreport to be the same as the other data in the section where it's located.
 
I can't guarantee that this will work, but I believe it will.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.