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):||10 March 2005|
|PDF File Size:||11.92 Mb|
|ePub File Size:||18.71 Mb|
|Price:||Free* [*Free Regsitration Required]|
Export Crystal Report Main report and Subreport data to Excel
XI gives the path I sent in the last email. Are you using the excel export “data only” option? But i also want to export the sub report like that with good format that means with images etc. Exporting sbreport to excel I don’t see your custom options.
Thu Feb 26, 1: Exporting subreports to excel Hi Jason Yes: The Excel exports in Crystal are really picky about formatting.
Now i’m able to export the main report in excel with the nice format that means i set the “Report export options”. Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
Crystal Reports Exporting to Excel with subreports
If memory serves, there’s a recent tech support document about this on the BO web site. While what you suggest would work, in theory, it comes with the price of performance degradation because, instead of the main report running 3 sub-reports, it would now be running 9 sub-reports.
Sybreport Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. Then resize the section to minimize the height of the section. It’s easy to join and it’s free.
There are some tricks to exporting with subreports which Ken Hamady has outlined. Philip Forum Associate Joined: 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. If all sub reports are placed to the right of all info being reported in your main report, and everything is lined up correctly 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.
Exporting subreports to excel Subreport wraps to next line when exporting to Excel: Wed Feb 25, 2: Here’s what I would try: Close this window and log in. You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You subrepoft vote in polls in sxport forum. In the main report, turn off the borders on the subreport. Thanks for your great help!!
Register now while it’s still free! In Crystal Reports 10 exporting with multiple sub reports. I don’t know whether we can achieve it or not bcoz i’ve not see ” report export options ” for sub report. The output displays OK, but I now need to export to Excel. repor
The best suggestion it makes is to bring the other fields of the main report into the subreport via shared variables. How to set “Export report Options” to subreport? Register now while it’s still free! NET application, but the results are exactly the same. Have you tried that? Did you get this to work?
If you have column headers, set the location of the left of the subreport to be the same as the column header sibreport it is under.
Sign up using Email and Password. What ever would be the same DATA in each of your data sources.
All times are GMT – 5 Hours. What works for me is to attach all fields and subs to gridlines both vertical and horizontaland yes, it can be done with subreport objects, although the red corners don’t appear. Because of the different data sources, the sections in the individual sub-reports may vary in length from one another, so my full report repodt rendered as such:.
This will work just in case you can make the subreport to use the same datasource. I finally got it to export on one line by changing the export type to ‘MS Excel ‘ and selecting the option for ‘Constant column width’.
The Crystal Reports® Underground
I have tried every recommendation given by kenhamady and lbass resizing and aligning fields, snap usbreport 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. Since my sub report is in the details line it seems that it should export.
I can’t guarantee that this repoort work, but I believe it will. I have the same issue.