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):||13 January 2018|
|PDF File Size:||6.24 Mb|
|ePub File Size:||15.38 Mb|
|Price:||Free* [*Free Regsitration Required]|
Click Here to join Tek-Tips and talk with other members!
Because of the different data sources, the sections in the individual sub-reports sjbreport vary in length from one another, so my full report is rendered as such: My report has about a dozen fields per record listed on the details line and it also has one sub-report that is pulling one field from a related table. I dont have any export option for subreport, I mean its disabled. The best suggestion it makes is to bring the other fields of the main report into the subreport via repirt variables.
I don’t see your custom options.
Sign up using Facebook. Select a search Explain These Choices Not endorsed by or affiliated with SAP. By joining you are opting in to receive e-mail. It’s easy to join and it’s free.
Crystal report subreport data does not export when exporting a report to CSV
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. Students Click Here Subteport Us! If memory serves, there’s a recent tech support document about this on the BO web site. Register now while it’s still free! Email Required, but never shown.
Hope this helps someone. In the subreport, suppress all sections except the one that contains your data. What ever would be the same DATA in each of your data sources. I’ve tried several different export formats – all do something similar. Exporting subreports to excel Hi Jason Yes: Thanks for your crysstal help!!
Red Flag This Post Please let us know here why this post is inappropriate. Students Click Here Join Us!
Export Crystal Report Main report and Subreport data to Excel
Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. Subreprot Mar 23, 4: The Excel exports in Crystal are really picky about formatting.
I have tried every recommendation given by kenhamady and lbass resizing and aligning fields, snap to grid, attach both left and right sides of fields and subs to gridlines, eliminate all space between fields, make the section as small as possible, etc and contined to get the same results. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.
How to set “Export report Options” to subreport?
All help is most appreciated! Exporting subreports to excel Subreport wraps to next line when exporting to Excel: Promoting, selling, recruiting, coursework and thesis posting is forbidden. I do not have access to the full Crystal Reports.
I have the same issue.
I am not having success exporting direct to an excel worksheet. Crystal Reports 9 through In the main report, set the height of the subreport to be the same as the other data sybreport the section where it’s located. Thu Feb 26, 1: XI gives the path I sent in the last email. NET application, but the results are exactly the same. All times are GMT – 5 Hours.
Esport you for your reply, Lan.