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):||25 October 2011|
|PDF File Size:||18.88 Mb|
|ePub File Size:||12.27 Mb|
|Price:||Free* [*Free Regsitration Required]|
If I understand you correctly, you have a subreport that returns some piece of data on the same line as other data in your main report. Sign up or log in Sign up using Google.
Forums – C# Corner
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. 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.
Thank you for your reply, Lan. Anyone know how to solve this? For instance here’s a. Crystal Subreport – Export to Repirt issue Why not use the regular Excel export instead crystall data only–then the guidelines method will work.
Thanks for crytsal reply, heringer.
Essentially, I have a Crystal Report that too of three sub-reports. In one of my systems, this is a Machine Identifier. 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.
Export crystal report to excel (data)
I can’t guarantee that this will work, but I believe it will. If the link doesn’t work, the knowledge base article ID is c Saturday, November 27, By continuing to browse this site, you agree to this use. Sign in to vote. Then set sbreport number of columns to 3 and try how the report will run. Right click on the sub report to manage individual sub report links.
For Crystal Reports please see: When you OPEN the. Are there other ideas I should try? Lan 1, 1 9 Unfortunately, your solution did not repodt for me. This page was generated in 0. Crystal Subreport – Export to Excel issue The end users need to do several operations on the excel once it is exported. Here’s what I would try: The end users need to do several operations on the excel once it is exported. Wednesday, November 24, 3: You need to make sure all the fields in your report match the field size in your subreport easiest way to do this is to make all fields in your report the same size.
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: In the main report, turn off the borders on the subreport. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. I had this same issue, but I’ve found the solution All your sub reports must be linked to a common field in order to line up correctly.
It’s easy to join and it’s free. Friday, February 23, 4: Business objects has a knowledge base article addressing this issue. The only ‘sacrifice’ is that with this option, the header names might be truncated Subrepogt can try to place the subreport in the details section then go to section experts, select details and check “Format with multiple columns”. What ever would be the same DATA in each of your data sources.
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:. But still hope that they can solve this issue.