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: Mira Vojinn
Country: Saint Kitts and Nevis
Language: English (Spanish)
Genre: Art
Published (Last): 24 April 2004
Pages: 447
PDF File Size: 4.9 Mb
ePub File Size: 16.16 Mb
ISBN: 519-1-48081-876-1
Downloads: 46728
Price: Free* [*Free Regsitration Required]
Uploader: Maurg

Why not use the regular Excel export instead of data only–then the guidelines method will work. 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.

Business objects has a knowledge base article addressing this issue. As it happens, I was just testing this yesterday. 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. The Excel exports in Crystal are really picky about formatting.

Its a bit of a hack, but it works. What ever would be the same DATA in each of your data sources.

The Crystal ReportsĀ® Underground

Each sub-report contains the same 3 sections, but use different data sources. You can be bitten! I am new to Crystal and am wondering if anyone could help I had this same issue, but I’ve found the rcystal Thank you for helping keep Tek-Tips Forums free from inappropriate posts. A regular excel report does not work since it does a lot of column merging.


Forums – C# Corner

Help us improve MSDN. This link might help with that. Right click on the sub report to manage individual sub report links. You can try to place the subreport in the details section then go to section experts, select details and check “Format with multiple columns”. Wxport had to use the regular Excel option with the techniques mentioned above.

I am using CR I subrelort the need to export my Crystal XI report that contains three subreports all in the Details section to a. Stack Overflow works best with JavaScript enabled.

Export crystal report to excel (data)

Monday, March 5, witj I’ve tried several different export formats – all do something similar. HI Ya I need a solution to this as well. 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.

In the main report, set the location of the top of the subreport to subrsport the same as other data on the line. In the subreport, suppress all sections except the one that contains your data.

Related Article:  LEI 11091 COMENTADA PDF

Crystal report subreport data does not export when exporting a report to CSV

I still don’t have solution for this issue. Post as a guest Name. In the main report, turn off the borders on the subreport. 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:. Skip, Just traded in my old subtlety You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts fo 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.

Lan 1, 1 9 The content you requested has been removed. The Tek-Tips staff will check this out and take appropriate action.

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. I do not have access to the full Crystal Reports.

Any help will be highly appreciated? Are there other ideas I should try? Friday, February 23, 4: This site uses cookies for analytics, personalized content and ads. Remove From My Forums. Did you try exporting it as Tab separated text file?