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: Arashirg Negore
Country: Mauritania
Language: English (Spanish)
Genre: Business
Published (Last): 5 November 2004
Pages: 50
PDF File Size: 18.81 Mb
ePub File Size: 10.81 Mb
ISBN: 557-7-40046-634-1
Downloads: 13444
Price: Free* [*Free Regsitration Required]
Uploader: Vilmaran

I found if you export to excel not data only it works but that’s not what i need. The Tek-Tips staff will check this out and take appropriate action. Crystal Reports for Visual Studio Xeport https: 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 on a separate row.

Thanks for your reply, heringer. I could not find ANY way to get a subreport value to export on the same line as the rest of the data as long as I used the “Data Only” option.

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

While what you suggest would work, in theory, it comes with the price of performance degradation because, instead of the main report running 3 sub-reports, it would now be running 9 sub-reports. I am new to Crystal and am wondering if anyone could help 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.


Thursday, March 22, 2: Crystal Subreport – Export to Excel issue Why not use the regular Excel export instead of data only–then the guidelines method will work.

If the link doesn’t work, the knowledge base article ID is c I am not having success exporting direct to an excel worksheet. The only ‘sacrifice’ is that with this option, the header names might be truncated Sign in to vote.

Crystal Reports Exporting to Excel with subreports

Saturday, November 27, Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. The individual sections of the sub-reports still do not line up with each other.

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

Students Click Here Join Us! In the main report, turn off the borders on the subreport.

Red Flag This Post Please let us know here why this post is inappropriate. Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Export Crystal Report Main report and Subreport data to Excel

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. Monday, March 12, 2: Friday, February 23, 4: 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. Thank you for your reply, Lan. What ever would be the same DATA in each of your data sources. Crystal Reports for Visual Studio Retired. Therefore, there is no data returned in the sub-reports which would be the same through-out all three reports.


Anyone know how to solve this?

I can’t guarantee that this will work, but I believe it will. Join your peers on the Internet’s largest technical computer professional community.

Unfortunately, your solution did not work for me. This will work just in case you can make the subreport to use the same datasource. In Crystal Reports 10 exporting with multiple sub reports. Click Here to join Tek-Tips and dubreport with other members! Proposed as answer by erosan Wednesday, November 24, 3: In one of my systems, this is a Machine Identifier.

However, when exporting to excel it inserts three blank rows between each record.

Forums – C# Corner

Hi all, I have a problem whenever I export the crystal report with a subreport to a excel Data Onlythe subreport data will display next row. I need all the info in the Details section to be crysral one line once it is in Excel just like it would be if I viewed it in Crystal Reports. I need a solution to this as well.