EXPORT CRYSTAL REPORT WITH SUBREPORT TO PDF

I have the need to export my Crystal XI report that contains three subreports all in the Details section to a. I need all the info in the Details section to be on one line once it is in Excel just like it would be if I viewed it in Crystal Reports. 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. Is that correct?

Author:Kazizilkree Tauzragore
Country:Antigua & Barbuda
Language:English (Spanish)
Genre:Health and Food
Published (Last):22 January 2016
Pages:135
PDF File Size:2.92 Mb
ePub File Size:15.29 Mb
ISBN:832-2-13679-499-4
Downloads:25909
Price:Free* [*Free Regsitration Required]
Uploader:Shabar



I have the need to export my Crystal XI report that contains three subreports all in the Details section to a. I need all the info in the Details section to be on one line once it is in Excel just like it would be if I viewed it in Crystal Reports.

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. Is that correct? In the main report, set the location of the top of the subreport to be the same as other data on the line. 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.

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. This page was generated in 0. Active Topics. Topic: Exporting to Excel with subreports. I've tried several different export formats - all do something similar. Are there other ideas I should try? IP Logged. Posted: 28 Jan at am. The Excel exports in Crystal are really picky about formatting. In the subreport, suppress all sections except the one that contains your data. In the main report, turn off the borders on the subreport.

I can't guarantee that this will work, but I believe it will. Printable version. You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum. All Rights Reserved.

LIEBHERR LTM 1035 PDF

Best practices for creating a Crystal Report for export into Excel

Best practices for creating a Crystal Report for export into Excel. Search Knowledgebase. Crystal Report is notoriously difficult with preserving the exact format into Excel, especially for complex reports with multiple subreports and suppressed sections. However, there are a few standard best practices for designing the Crystal Report in order to reproduce a closer copy of the report format. Unmark Free Form Placement on all report sections to improve the export to Excel. Unmarking that option will force you to place objects in your report in a grid of rows, and this will export more cleanly to Excel. This can give extra columns that may be needed for the Excel Export.

BORJAS G.J.LABOR ECONOMICS PDF

Subscribe to RSS

Log In. Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members! Already a Member? Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free.

Related Articles