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: Toshakar Brajas
Country: Maldives
Language: English (Spanish)
Genre: History
Published (Last): 6 October 2007
Pages: 186
PDF File Size: 10.82 Mb
ePub File Size: 6.46 Mb
ISBN: 483-3-79576-759-9
Downloads: 93999
Price: Free* [*Free Regsitration Required]
Uploader: Kigor

Crystal Subreport – Export to Excel issue Why not use the regular Excel export instead of data only–then the guidelines method will work. Business objects has a knowledge base article addressing this issue.

By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. I am using CR 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:.

I’ve tried several different export formats – all do something similar. This will solve the issue. Hi Stalek, all three sub-reports are linked using three different input parameters StartDate and EndDate which create a date range for sibreport information is populated, and ItemType which specifies the item the report is generated for.


You can usually avoid the row and column merging if you are careful about alignment and positioning. What ever would be the same DATA in each of your data sources. I have a report with two sub-reports, all on one row of my master report. 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.

Export Crystal Report Main report and Subreport data to Excel

Each sub-report contains the same 3 sections, but use suvreport data sources. Thank you for helping keep Tek-Tips Forums free from inappropriate posts.

Sign up using Facebook.

A regular excel report does not work since it does a lot of column merging. Click Here to join Crysgal and talk with other members!

Register now while it’s still free! Monday, March 12, 2: 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. Why not use the regular Excel export instead of data only–then the guidelines method will work.

formatting – Crystal Reports – Using Subreports as Columns – Stack Overflow

Then set the number of columns to 3 and try how the report will run. HI Ya I need a solution to this as well. ANy luck solving this issue?? 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. For instance here’s a. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. I had this same issue, but I’ve found the solution I had surbeport use the regular Excel option with subreporg techniques mentioned above.


Saturday, November 27, Crystal Subreport – Export to Excel issue The end users need to do several operations on the excel once it is exported. The Excel exports in Crystal are really picky about formatting. 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.

If the link doesn’t work, the knowledge base article ID is c Edited by boltonss Saturday, July 12, 5: I can’t guarantee that this will work, but I believe it will.