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: Mazuzahn Mooguzilkree
Country: Chad
Language: English (Spanish)
Genre: Business
Published (Last): 10 January 2012
Pages: 33
PDF File Size: 16.64 Mb
ePub File Size: 14.76 Mb
ISBN: 589-9-78446-826-7
Downloads: 10622
Price: Free* [*Free Regsitration Required]
Uploader: Masida

HI Ya I need a solution to this as well. I have been able to get the reports to line up doing that. Friday, February 23, 4: Crystal Subreport – Export to Excel issue Why not use the regular Excel export instead of data only–then the guidelines method will work.

Each sub-report contains the same 3 sections, but use different data sources. Crystal Reports for Visual Studio Retired. This will solve the issue.

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

Skip, Just traded in my old subtlety Students Click Here Join Us! I’ve tried several different export formats – all do something similar.


Sign up or log in Sign up using Google. Is there a way to do that? Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. This site uses cookies for analytics, personalized content and ads.

This link might help with that.

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

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. I hope this helps everyone! You need to make sure all the fields in your report match the field size in your subreport easiest way to do this is to make all fields in your crstal the same size.

You can usually avoid the row and column merging if you are careful about alignment and positioning. Wednesday, November 24, 3: In the main report, turn off the borders on the subreport. But crystla hope that they can solve this issue. The Tek-Tips staff will check this out and take appropriate action.

I am not having success exporting direct to an excel worksheet. Red Flag This Post Please let us know here why this post is inappropriate. Essentially, what I want to do is have all sections line up, regardless of the amount of data that may be contained in the individual sections:.

Promoting, selling, recruiting, coursework and thesis posting is forbidden. I am using CR In Crystal Reports 10 exporting with multiple sub reports. The content you requested has been removed. 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.


What ever would be the same DATA in each of your data sources.

Why not use the regular Excel export instead of data only–then the exlort method will work. Remove From My Forums. As it happens, I was just testing this yesterday. Hi Stalek, all three sub-reports are linked using three different input parameters StartDate and EndDate which create a date range for which information is populated, and ItemType which specifies explrt item the report is generated for.

Subrfport all sub reports are placed to the right of all info being reported in your main report, and everything is lined up correctly Tuesday, February 6, 5: Help us improve MSDN. Saturday, November 27, Friday, March 23, 1: 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.