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: Kazshura Mazugor
Country: Germany
Language: English (Spanish)
Genre: Finance
Published (Last): 25 March 2015
Pages: 395
PDF File Size: 17.67 Mb
ePub File Size: 6.40 Mb
ISBN: 558-3-53819-891-2
Downloads: 9831
Price: Free* [*Free Regsitration Required]
Uploader: Zulubei

Export Crystal Report Main report and Subreport data to Excel

Email Required, but never shown. In Crystal Reports 10 exporting with multiple sub reports.

Thanks for your great help!! Tue Mar 23, 5: Sign up using Email and Password. Register now while it’s still reoort I tried this and it worked for me.

I haven’t tried this yet as it will be a bit labourious, but may subeport it a go tomorrow as I’m running out of options. Exporting subreports to excel Hi Jason Yes: 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.

Join your peers on the Internet’s largest technical computer professional community. The three sub-reports generate counts based off of the parameters, expport of which is an overall count, the other two are sub-set counts. Are there other ideas I should try? Exporr finally got it to export on one line by changing the export type to ‘MS Excel ‘ and selecting the option for ‘Constant column width’.


Export Crystal Report Main report and Subreport data to Excel

Exporr Stalek, all three sub-reports are linked using three different input parameters StartDate and EndDate which create a date range for which information is populated, and ItemType which specifies the item the report is generated for. Please let me know if there is any alternative. Right click on the sub report to manage individual sub report links. By joining you are opting in to receive e-mail. I am not having success exporting direct to an excel worksheet.

Post as a guest Name. NET application, but the results are exactly the same. Exporting subreports to excel If memory serves, there’s a recent tech support document about this on the BO web site.

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

In the main report, turn off the borders on the subreport. Exporting subreports to excel I don’t see your custom options.

In the subreport, suppress all sections surbeport the one that contains your data. Exporting subreports to excel Silly question All data from the main report is forced left unless there is data from the sub in front of it.

From there, import your file to excel using the “text to column wizard”. Then resize the section to minimize the height of the section. Not endorsed by or affiliated with SAP. Jeff Beese 1 4 What ever would be the same DATA in each of your data sources.


Sub Report 1 Sub Report 2 Sub Report 3 Section 1 Section 1 Section 1 a a a b b Section 2 c c a Section 2 d b a Section 2 c b a Section 3 c b a d Section 3 b Section 3 a a 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: If I understand you correctly, you have a subreport that returns some piece of data on the same line as other data in your main report. The Tek-Tips staff will check this out and take appropriate action.

Each sub-report contains the same 3 sections, but use different data sources. Click Here to join Tek-Tips and talk with other members! Click Here to join Tek-Tips and talk with other members! Therefore, there is no data returned in the sub-reports which would be the same through-out all three reports. You have to run the subreport before you can export it.

Then set the number of columns to 3 and try how the report will run. The output displays OK, but I now need to export to Excel.

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.