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: Faecage Vosida
Country: Bulgaria
Language: English (Spanish)
Genre: Love
Published (Last): 20 April 2009
Pages: 223
PDF File Size: 18.75 Mb
ePub File Size: 2.72 Mb
ISBN: 678-9-48326-473-6
Downloads: 89729
Price: Free* [*Free Regsitration Required]
Uploader: Shaktigrel

In the main report, turn off the borders on the subreport. Right click on the sub report to manage individual sub report links. Hi I’ve created one on-demand sub report in the Main report. 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:.

The output displays OK, but I now need to crystxl to Excel.

Export Crystal Report Main report and Subreport data to Excel

This page was generated in 0. Stack Overflow works best with JavaScript enabled. Click Here to join Tek-Tips and talk with other members! 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’. 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 have the need to export my Crystal XI report that contains three subreports all in the Details section to a. Then set the number of columns to 3 and try how the report will run. Thank you for your reply, Lan. In Crystal Reports 10 exporting with multiple sub reports. Lan 1, 1 9 Here’s what I would try: I had the same problem with subreports wrapping and this fixed it. Unfortunately, your solution did not work for me.

I subrrport not having success exporting direct rwport an excel worksheet.

Page 1 of 1. Crystal Reports 4 Other topics Forum Exporting subreports to excel. Jeff Beese 1 4 In the main report, set the location of the top of the subreport to be the same as other data on the line.

I have tried every recommendation given by kenhamady and lbass resizing and aligning fields, snap to 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.

I’m trying to export this data to a CSV file for import into another system but it seems cfystal Crystal is ignoring the sub-report data all together. I am using CR SP6. Are there other ideas I should try?


All your sub reports must be linked to a common field in order to line up correctly. Join your peers on the Internet’s largest technical computer professional community.

formatting – Crystal Reports – Using Subreports as Columns – Stack Overflow

Subreport wraps to next line when exporting to Excel: The Tek-Tips staff will check this out and take appropriate action. But i also want to export the sub report like that with good format that means with images etc.

I don’t see your custom options. Students Click Here Join Us! Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. 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.

NET application, but the results are exactly the same. If I understand you correctly, you have a subreport that returns some piece of data on the same line as other data subreoort your subeeport report.

All times are GMT – 5 Hours. By joining you are opting in to receive e-mail. 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.