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: Mashura Gardasar
Country: Uganda
Language: English (Spanish)
Genre: Love
Published (Last): 26 March 2007
Pages: 304
PDF File Size: 12.69 Mb
ePub File Size: 5.79 Mb
ISBN: 254-2-84903-828-4
Downloads: 36513
Price: Free* [*Free Regsitration Required]
Uploader: Tygokree

The Tek-Tips staff will check this out and take appropriate action. Fri Mar 27, 1: 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.

In the main report, set the location of the top of the subreport to be the same as other data on the line. Edport subreports to excel I don’t see your custom options. The individual sections of the sub-reports still do not line up with each other. All data from the main report is forced left unless there is data from the sub in front of it.

I have the same issue. All help is most appreciated! Stack Overflow works best with JavaScript enabled.

Export Crystal Report Main report and Subreport data to Excel

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’. I don’t know whether we can achieve it or not bcoz i’ve not see ” report export options ” for sub report.

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.

Please let me know if there is any alternative. The sub-report is populated crhstal one crysta per line at most but is often blank as ceystal. 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.


I am not having success exporting direct to an excel worksheet. Join your peers on the Internet’s largest exort computer professional community. Exporting subreports to excel Hi Jason Yes: I have the need to export my Crystal XI report that contains three subreports all in the Details section to a. How to set “Export report Options” to subreport?

But i also want to export the sub report like that with good format that means with images etc. I do not have access to the full Crystal Reports. This rpt is actually being called by a.

Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Join your peers on the Internet’s largest technical computer professional community. I don’t see your custom options. I tried this and it worked for me.

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

Exporting subreports to excel There are some tricks to exporting with subreports which Ken Hamady has outlined. 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 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.

Since my sub report is in the details line it seems subrreport it should export. Crystal Reports 9 through Wed Feb 25, 2: Here’s what I would try: Exporting subreports to excel Subreport wraps to next line when exporting to Excel: In the main report, turn off the ccrystal on the subreport. 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.



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

Post as a guest Name. The three sub-reports generate counts based off of the parameters, one of which is an overall count, the other two are sub-set counts. I’ve been at this for hours! Are there other ideas I should try?

In the main report, set the height of the subreport to be the same as the other data in the section where it’s located. It’s easy to join and it’s free. Crystal Reports 4 Other topics Forum Exporting subreports to excel.

Crystal Reports Exporting to Excel with subreports

Then resize the section to minimize the height of the section. If all sub reports are placed to the right of all info being reported in your main report, and everything is lined up exporrt 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. It’s easy to join and it’s free.

If the subreport is on-demand then you are in trouble, but if it is not then the data should be exported. Does any one has solution for this? The help file for Crystal says that it will not export sub-reports when they are in page header or page footer sections.