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: Moogusar Arall
Country: Haiti
Language: English (Spanish)
Genre: Art
Published (Last): 6 April 2005
Pages: 53
PDF File Size: 8.96 Mb
ePub File Size: 15.40 Mb
ISBN: 823-5-54496-642-5
Downloads: 44766
Price: Free* [*Free Regsitration Required]
Uploader: Vilkree

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. What ever would be the same DATA in each of your data sources.

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

Thu Feb 26, 1: Your main report should report at least that field. I crystall the same problem with subreports wrapping and this fixed it. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

I dont have any export option for xrystal, I mean its disabled. Exporting subreports to excel Silly question Page 1 of 1. How to set “Export report Options” to subreport? All your sub reports must be linked to a common field in order to line up correctly.


Exporting subreports to excel – Business Objects: Crystal Reports 4 Other topics – Tek-Tips

NET application, but the results are exactly the same. You have to run the subreport before you can export it. Wed Feb 25, 2: Join your peers on the Internet’s largest technical computer professional community. I have tried umpteen different settings with SubReport Format, but cannot crhstal all the columns in one row. 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 usbreport for all three sub-reports instead of null values where data may not exist in one.

Promoting, selling, recruiting, coursework and thesis posting is forbidden. By joining you are opting in to receive e-mail. I am not having success exporting direct to an excel worksheet. It’s easy to join and it’s free. In the main report, turn off the borders on the subreport.

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

Export Crystal Report Main report and Subreport data to Excel

Display posts from previous: Crystal Reports 4 Other topics Forum Exporting subreports to excel. How to set “Export report Options” to subrepor. Not endorsed by or affiliated with SAP. Because of the different data sources, the sections in the individual sub-reports repirt vary in length from one another, so my full report is rendered as such:.


Sign up or log in Sign up using Expot. In the main report, set the location of the top of the subreport to be the same as other data on the line.

Is there a way that I can get this crystzl piece of data to export to a CSV format? Hope this helps someone. Sign up using Email and Password.

How to set “Export report Options” to subreport?

The output displays OK, but I now need to export to Excel. I tried this and it worked for me. The Excel exports in Crystal are really picky about formatting. Crystal Reports 9 through It’s easy to join and it’s free. You can try to place the subreport in the eubreport section then go to section experts, select details and check “Format with multiple columns”.

Red Flag This Post Please let us know here why this post is inappropriate. Exporting subreports to excel http: Here’s what I would try: