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 .
|Published (Last):||6 April 2006|
|PDF File Size:||7.96 Mb|
|ePub File Size:||10.2 Mb|
|Price:||Free* [*Free Regsitration Required]|
This link might help with that. For instance here’s a.
Export Crystal Report Main report and Subreport data to Excel
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.
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.