Good afternoon, I have a Crystal Reports XI report that is pulling data from a SQL Server database. My report has about a dozen fields per. I have an existing report which displays cols A to G from an SP, and uses a SubReport to retrieve col H. Cols I & J are then retrieved from the SP. Exporting Crystal Reports to Excel can be tricky. I have written several articles on techniques to make it easier. But it gets even trickier when a.

Author: Jukora Zumuro
Country: El Salvador
Language: English (Spanish)
Genre: History
Published (Last): 18 August 2004
Pages: 191
PDF File Size: 20.87 Mb
ePub File Size: 2.2 Mb
ISBN: 420-1-21146-726-1
Downloads: 9353
Price: Free* [*Free Regsitration Required]
Uploader: Mausar

I’m trying to export this data to a CSV file for import into another system but it seems that Crystal is ignoring the sub-report data all together. Select a search Explain These Choices Thank you for your reply, Lan.

Red Flag This Post Please let us know here why this post is inappropriate. I’ve been at this for hours! Please let me know if there is any alternative. The three sub-reports generate counts based off of the parameters, one subreprot which is an overall count, the other two are sub-set counts.

The Crystal ReportsĀ® Underground

Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. It’s easy to join and it’s free. Now i’m able to export the main report in excel with the nice format that means i set the “Report export options”.

Related Posts  E5CN-R2MT-500 MANUAL EPUB

If memory serves, there’s a recent tech support document about this on the BO web site. Sign up using Email and Password. Click Here to join Tek-Tips and talk with other members! In the ccrystal report, turn off the borders on the subreport. Are you using the excel export “data only” option? All help is most appreciated! 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.

Reasons such as off-topic, duplicates, flames, expoft, vulgar, or students posting their homework.

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

I have tried umpteen different settings with SubReport Format, but cannot get all the columns in one row. Thank you for helping keep Tek-Tips Forums free from subrepirt posts.

Promoting, selling, recruiting, coursework and thesis posting is forbidden. Sign up or log in Sign up using Google. 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: Expport tried this and it worked for me.


Each sub-report contains the same 3 sections, but use different data sources. Exporting subreports to excel Silly question Students Click Here Join Us! In the main report, set the location of the top of the subreport to be subreprt same as other data on the line.

Export Crystal Report Main report and Subreport data to Excel

Tue Mar 23, 4: The Tek-Tips staff will check this out and take appropriate action. Exporting subreports to excel I don’t see your custom options.

Not endorsed by or affiliated with SAP. Students Click Here Join Us! If the subreport is on-demand then you are in trouble, but if it is not then the data should be exported.

The help file for Crystal says that it will not export sub-reports when they are in page header or page footer sections.