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: Voodooran Jugami
Country: Iceland
Language: English (Spanish)
Genre: Education
Published (Last): 27 May 2009
Pages: 273
PDF File Size: 8.73 Mb
ePub File Size: 3.41 Mb
ISBN: 941-5-19561-212-7
Downloads: 2402
Price: Free* [*Free Regsitration Required]
Uploader: Gardarn

Thank you for your reply, Lan. If the subreport is on-demand then you are in trouble, but if it is not then the data should be exported.

All help is most subrepory You can try to place the subreport in the details section then go to section experts, select details and check “Format with multiple columns”. I’ve tried several different export formats – all do something similar. Exporting subreports to excel http: Subreport wraps to next line when exporting to Excel: All data from the main report is forced left unless there is data from the sub in front of it.

Jeff Beese 1 4 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. Join your peers on the Internet’s largest technical computer professional community. 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:. Are there other ideas Expoet should rdport


Exporting subreports to excel Hi Jason Yes: 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.

I dont have any export option for subreport, I mean its disabled. Now i’m able to export the main report in excel with the nice format that means i set the “Report export options”. I have the same issue. The output displays OK, but I now need to export to Excel.

I don’t know whether we can achieve it or not bcoz i’ve not see ” report export options ” for sub report.

Did you get this to work? Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Crystal Reports Exporting to Excel with subreports

Crystal Reports 9 through I need all the info in the Details section to be on one line once it is in Excel just like it would be if I viewed it in Crystal Reports. I am having a small problem with formatting on a Crystal Report that I am hoping that you may be able to help me with. Display posts from previous: I had the same problem with subreports wrapping and this fixed it.


There are some tricks to exporting with subreports which Ken Hamady has outlined.

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

If memory serves, there’s a recent tech support document about this on the BO web site. Register now while it’s still free!

Have you tried that? In the subreport, suppress all sections except the one suberport contains your data. Not endorsed by or affiliated with SAP.

I have tried umpteen different settings with SubReport Format, but cannot get all the columns in one row. This will work just in case you can make the subreport to rfport the same datasource. Exporting subreports to excel Subreport wraps to next line when exporting to Excel: Fri Mar 27, 1:

Subscribe US Now