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: Akilar Nejas
Country: Suriname
Language: English (Spanish)
Genre: Finance
Published (Last): 8 December 2012
Pages: 406
PDF File Size: 20.60 Mb
ePub File Size: 14.23 Mb
ISBN: 931-1-54671-934-7
Downloads: 5680
Price: Free* [*Free Regsitration Required]
Uploader: Kigagor

Crystal Reports Exporting to Excel with subreports

Thank you for helping keep Tek-Tips Forums free from inappropriate posts. Crystal Reports for Visual Studio Retired https: Monday, March 12, 2: Sign up or log in Sign up using Google.

Sign up using Email and Password. Thursday, March 22, 2: A regular excel report does not work since it does a lot of column merging. However, when exporting to excel it inserts three blank rows between each record. I am using CR The end users need to do several operations on the excel once it is exported. Red Flag This Post Please let us know here expkrt this post is inappropriate. Business objects has a knowledge base article addressing this issue.


The only ‘sacrifice’ is that with this option, the header names might be truncated I hope this helps everyone!

Stack Overflow works best with JavaScript enabled. The three sub-reports generate counts based off of the parameters, one of which is an overall count, the other two are sub-set counts. But still hope that they can solve this issue.

This will solve the issue. I am not having success exporting direct to an excel worksheet.

Export crystal report to excel (data)

From there, import your file to excel using the “text to column wizard”. The Excel exports in Crystal are really picky about formatting. I crhstal don’t have solution for this issue. 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.

Has anyone got one? By continuing to browse this site, you agree to this use. Thank you for your reply, Lan.

Forums – C# Corner

Because of the different data sources, the sections in the individual sub-reports reportt vary in length from one another, so my full report is rendered as such:. HI Ya I need a solution to this as well.


As it happens, I was just testing this yesterday. Saturday, July 12, 5: Any help will be highly appreciated? Hi Stalek, all three sub-reports are linked using three different input parameters StartDate and EndDate which ssubreport a date range for which information is populated, and ItemType which specifies the item the report is generated for.

Promoting, selling, recruiting, coursework and thesis posting is forbidden. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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

This page was generated in 0. Is there a way to do that? I had this same issue, but I’ve found the solution I have been able to get the reports to line up doing that.