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: Nashakar Faushicage
Country: Venezuela
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 6 April 2006
Pages: 149
PDF File Size: 7.96 Mb
ePub File Size: 10.2 Mb
ISBN: 340-7-62344-784-6
Downloads: 28186
Price: Free* [*Free Regsitration Required]
Uploader: Gak

This link might help with that. For instance here’s a.

Export Crystal Report Main report and Subreport data to Excel

By joining you are opting in to receive e-mail. Stack Overflow works best with JavaScript enabled. 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. Has anyone got one?

I’ve tried several different export formats – all do something similar. 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. A regular excel report does not work since it does a lot of column merging. Here’s what I would try: What ever would be the same DATA in each of your data sources. All your sub reports must be linked to a common field in order to line up correctly.


Export crystal report to excel (data)

Join cryatal peers on the Internet’s largest technical computer professional community. 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.

You can usually avoid the row and column merging if you are careful about repor and positioning. Promoting, selling, recruiting, coursework and thesis posting is forbidden. By using our site, you acknowledge cryystal you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. 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. In the main report, turn off the borders on the subreport.

The Crystal ReportsĀ® Underground

You can be bitten! ANy luck solving subrwport issue?? Crystal Reports for Visual Studio Retired https: I have been able to get the reports to line up doing that. Please do not use. Each sub-report contains the same 3 sections, but use different data sources.


Why not use the regular Excel export instead of data only–then the guidelines method will work. Anyone know how to solve this? Crystal Subreport – Export to Excel issue You can usually avoid the row and column merging if you are careful about alignment and positioning. In one of my systems, this is a Machine Identifier.

In Crystal Reports 10 exporting with multiple sub reports. Therefore, there is no data returned in the sub-reports which would be the same through-out all three reports. Saturday, November 27, 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.

Because of the different data sources, the sections in the individual sub-reports may vary in length from one another, so my rcystal report is rendered as such: Then open it in Excel?

Crystal Reports for Visual Studio Retired.