This looks great in Crystal, but when I export the report to excel-data only (which is mostly what the report is used for) the sub-report comes out. Exporting Crystal Reports into Excel. When I export a report to excel all columns export correctly except the sub report it makes it a new row. Any tips on how to. Your main report should report at least that field. Right click on the sub report to manage individual sub report links. In Crystal Reports 10 exporting with multiple .

Author: Shaktirg Tujar
Country: Saint Kitts and Nevis
Language: English (Spanish)
Genre: Science
Published (Last): 22 May 2011
Pages: 371
PDF File Size: 6.71 Mb
ePub File Size: 10.4 Mb
ISBN: 438-2-24949-571-7
Downloads: 66958
Price: Free* [*Free Regsitration Required]
Uploader: Vudoktilar

This site uses cookies for analytics, personalized content and ads.

Please do not use. In the main report, turn off the borders on the subreport. 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. Thank you for helping keep Tek-Tips Forums free from inappropriate posts. Right click on the sub report to manage individual sub report links.

Promoting, selling, recruiting, coursework and thesis posting is forbidden. I am not having success exporting direct to an excel worksheet. Lan 1, 1 9 Are there other ideas Repott should cfystal This will solve the issue.


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. However, when exporting to excel it inserts three blank rows between each record.

I had to use the regular Excel option with the techniques mentioned above.

Export or save a Subreport as a new Main Report? URGENT

The individual sections of the sub-reports still do not line up with each other. Crystal Reports 9 through The Excel exports in Crystal are really picky about formatting.

Proposed as answer by erosan Wednesday, November 24, 3: I want the data to be display together same row with the main report data. Tuesday, February 6, 5: Exporting to Excel with subreports. Anyone know how to solve this?

By joining you are opting in to receive e-mail.

The Crystal ReportsĀ® Underground

Thanks for your reply, heringer. I have a report with two sub-reports, all on one row of my master report. Friday, March 23, 1: Crystal Reports for Visual Studio Retired https: Because of the different data sources, the sections in the individual sub-reports may vary in length from one another, so my full report is rendered as such: For Crystal Reports please see: I used to think you just had to set suppress blank report on the subreport but that doesn’t work.


Therefore, there is no data returned in the sub-reports which would be the same through-out all three reports. I still don’t have solution for this issue.

Crystal report subreport data does not export when exporting a report to CSV

I am new to Crystal and am wondering if anyone could help Thursday, March 22, 2: In exporg subreport, suppress all sections except the one that contains your data. I have been able to get the reports to line up doing that.

Register now while it’s still free! Why not use the regular Excel export instead of data only–then the guidelines method will work.

I hope this helps everyone!