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):||23 September 2014|
|PDF File Size:||4.79 Mb|
|ePub File Size:||10.53 Mb|
|Price:||Free* [*Free Regsitration Required]|
The Excel exports in Crystal are really picky about formatting.
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.
All times are GMT – 5 Hours. Click Here to join Tek-Tips and talk with other members!
Please let me know if there is any alternative. Students Click Here Join Us! I tried this and it worked for me.
If memory serves, there’s a recent tech support document about this on the BO web site. I’ve tried several different export formats – all do something similar.
Post as a guest Name. Email Required, but never shown. If the subreport is on-demand then you are in subrelort, but if it is not then the data should be exported. Join your peers on the Internet’s largest technical computer professional exportt.
Promoting, selling, recruiting, coursework and thesis posting is forbidden. This rpt is actually being called by a. Students Click Here Join Us! From there, import your file to excel using the “text to column wizard”.
I had the same problem with subreports wrapping and expor fixed it. Here’s what I would try: Tue Mar 23, 4: Does any one has solution for this? Promoting, selling, recruiting, coursework and thesis posting is forbidden. Exporting subreports to excel Silly question I haven’t tried this yet as it will be a bit labourious, but may give it a go tomorrow as I’m running out of options.
All help is most appreciated! Then resize the section to minimize the height of the section.
I don’t see your custom options. In Crystal Reports 10 exporting with multiple sub reports. Now i’m able to export the main report in excel with the nice format that means i set the “Report export options”. You can try to place the subreport in the details section then go to section experts, select details and check “Format with multiple columns”. 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:.
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: Page 1 of 1. Is there a way that I can get this one piece of data to export to a CSV format? How to set “Export report Options” to subreport?
I have tried every recommendation given by kenhamady and lbass resizing and aligning fields, snap to rdport, 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.
Jeff Beese 1 4 Your main report should exporrt at least that field. Did you get this to work? Right click on the sub report to manage individual sub report links.
Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
XI gives the path I sent in the last email. 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.
The Tek-Tips staff will check this out and take appropriate action.
The sub-report looks just like any other field in the detail line when in preview or printed. Hi Stalek, all rwport 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.
Exporting to Excel with subreports. This will work just in case you can make the subreport to use the same datasource. Close this window and log in. The Tek-Tips staff will check this out and take appropriate action. Hi I’ve created one on-demand sub report in the Main report.