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):||14 August 2013|
|PDF File Size:||13.41 Mb|
|ePub File Size:||16.83 Mb|
|Price:||Free* [*Free Regsitration Required]|
Unfortunately, there’s nothing you can do to get the subreport export onto the same line with data only, but they suggest a couple of alternatives:. Why not use the regular Excel export instead of data only–then the guidelines method will work. I’ve tried several different export expott – all do something similar. I have a report with two sub-reports, all on one row of my master report. Unfortunately, there’s nothing you can do to get the subreport export onto the same line with data only, but they suggest a couple of alternatives: However, when exporting to excel it inserts three blank rows between each record.
You can be bitten! Jeff Beese 1 4 I need a solution to this as well.
Because of the different data sources, the sections in the individual sub-reports may vary in length from one another, so my full report is rendered as such: Are there other tl I should try?
Here’s what I would try: Tuesday, February 6, 5: ANy luck solving this exporg Thank you for your reply, Lan.
I found if you export to excel not data only it works but that’s not what i need. Sign in to vote. But still hope that they can solve this issue. Business objects has a knowledge base article addressing this issue. Close this window and log in.
Crystal Reports 9 through I do not have access to the full Crystal Reports. I have the need to export my Crystal XI report that contains three subreports all in the Details section to a. This subrrport solve the issue. Lan 1, 1 9 What ever would be the same DATA in each of your data sources. Crystal Subreport – Export to Excel issue You can usually avoid the row and column merging if you are careful about alignment and positioning.
In the subreport, suppress all sections except the one that contains your data. The individual sections of the sub-reports still do not line up with each other.
All your sub reports must be linked to a common field in order to line up correctly. The end users need to do several operations on the excel once it is exported. 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.
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. All data from the main report is forced left unless there is data from the sub in front of it.