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: Kigatilar Mezuru
Country: Paraguay
Language: English (Spanish)
Genre: Science
Published (Last): 11 June 2017
Pages: 170
PDF File Size: 5.41 Mb
ePub File Size: 14.13 Mb
ISBN: 174-3-97473-767-8
Downloads: 76293
Price: Free* [*Free Regsitration Required]
Uploader: Doulmaran

Sjbreport don’t know whether we can achieve it or not bcoz i’ve not see ” report export options ” for sub report. Thank you for helping keep Tek-Tips Forums free from inappropriate posts. In the main report, set the location of the top of the subreport to be the same as other data on the line.

Therefore, there is no data returned in the sub-reports which would be the same through-out all three reports. I’ve been at this for hours! Close this window and log in. Jeff Beese 1 4 If memory serves, there’s a recent tech support document about this on the BO web site. Sign up using Facebook.

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

I finally got it to export crystla one line by changing the export type to ‘MS Excel ‘ and selecting the option for ‘Constant column width’. Promoting, selling, recruiting, coursework and thesis posting is forbidden. The sub-report looks just like any other field in the detail line when in preview or printed.


The output displays OK, but I now need to export to Excel. Click Here to join Tek-Tips and talk with other members! Now i’m able to export the main report in excel with subrepoort nice format that means i set the “Report export options”. Thank you for your reply, Lan.

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

Here’s what I would try: 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.

Fri Mar 27, 1: Join your peers on the Internet’s largest technical computer professional community. Unfortunately, your solution did not work for me. Expoft can’t guarantee that this will work, but I believe it will. Page 1 of 1. What exactly are you seeing or should I say not seeing? Right click on the sub report to manage individual sub report links.

Export Crystal Report Main report and Subreport data to Excel

Register now while it’s still free! Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. The best suggestion it makes is to bring the other fields of the main report into the subreport via shared variables. 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.


The sub-report is populated with one record per line at most but is often blank as well.

I need all the info in the Details section to be on one line once it is in Excel rpeort like it would be if I viewed it in Crystal Reports. It’s easy to join and it’s free. 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. Tue Mar 23, 4: 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.

Are there other ideas I should try? Select a search Explain These Choices All times are GMT – 5 Hours.

This page was generated in 0. 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 expoft.

Exporting to Excel with subreports. If the subreport is on-demand then you are in trouble, but if it is not then the data should be exported. crysral