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: Meztirn Yozshugar
Country: Lesotho
Language: English (Spanish)
Genre: Finance
Published (Last): 23 December 2013
Pages: 121
PDF File Size: 2.66 Mb
ePub File Size: 14.79 Mb
ISBN: 767-9-38983-956-9
Downloads: 95435
Price: Free* [*Free Regsitration Required]
Uploader: Barisar

The end users need to do several operations on the excel once it is exported.

Export Crystal Report Main report and Subreport data to Excel

I do not have access to the full Crystal Reports. Business objects has a knowledge base article addressing this issue.

All your sub reports must be linked to a common field in order to line up correctly. Promoting, selling, recruiting, coursework and thesis posting is forbidden.

While what you suggest would work, in theory, it comes with the sjbreport of performance degradation because, instead of the main report running 3 sub-reports, it would now be running 9 sub-reports. Monday, March 12, 2: I had to use the regular Excel option with the techniques mentioned above.


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

Sign up using Email and Password. For instance here’s a. Please do not use. Email Required, but never shown.

The Crystal ReportsĀ® Underground

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 the item the report is generated for.

But still hope that they can solve this issue. If I understand expor correctly, you have a subreport that returns some piece of data on the same line as other data in your main report. Crystal Reports 9 through Thursday, March 22, 2: Friday, March 23, 1: Wubreport regular excel report does not work since it does a lot of column merging.

I found if you export to excel not data only it works but that’s not what i need.

I still don’t have solution for this issue. Sign in to vote. 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:. Anyone know how to solve this?

From there, import your file to excel using the “text to column wizard”. All data from the main report is forced left unless there is data from the sub in front of it.

Did you try exporting it as Tab separated text file?


Here’s what I would try: Any help will be highly appreciated? Sign subreeport or log in Sign up using Google. Jeff Beese 1 4 By continuing to browse this site, you agree to this use.

Then set the number of columns to 3 and try how the report will run. You can be bitten! Thanks for your reply, heringer. You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum.

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: I think my solution is inevitablly going to come from the sql that generates the data for these reports, by forcing it to return the same number of rows for all three sub-reports instead of null values where data may not exist in one.