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.
|Published (Last):||18 August 2004|
|PDF File Size:||20.87 Mb|
|ePub File Size:||2.2 Mb|
|Price:||Free* [*Free Regsitration Required]|
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”.
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.