This looks great in Crystal, but when I export the report to excel-data only (which is mostly what the report is used for) the sub-report comes out. Exporting Crystal Reports into Excel. When I export a report to excel all columns export correctly except the sub report it makes it a new row. Any tips on how to. Your main report should report at least that field. Right click on the sub report to manage individual sub report links. In Crystal Reports 10 exporting with multiple .
|Published (Last):||16 November 2014|
|PDF File Size:||4.19 Mb|
|ePub File Size:||3.87 Mb|
|Price:||Free* [*Free Regsitration Required]|
formatting – Crystal Reports – Using Subreports as Columns – Stack Overflow
I can’t guarantee that this will work, but I believe it will. The end users need to do several operations on the excel once it is exported. I want the data to be display together same row with the main report data. I need repott solution to this as well. I am not having success exporting direct to an excel worksheet. Help us improve MSDN. I have the need to export cryxtal Crystal XI report that contains three subreports all in the Details section to a.
I had this same issue, but I’ve found the solution Crystal Reports 9 crystall Click Here to join Tek-Tips and talk with other members! 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.
Export crystal report to excel (data)
repoort Edited by boltonss Saturday, July 12, 5: Skip, Just traded in my old subtlety Register now while it’s still free! Saturday, November 27, Students Click Here Join Us! Hi Stalek, all three sub-reports are linked crystsl 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.
The Excel exports in Crystal are really picky about formatting. Then open it in Excel?
Export Crystal Report Main report and Subreport data to Excel
Remove From My Forums. This link might help with that. But still hope that they can solve this issue. Essentially, I have a Crystal Report that consists of three sub-reports.
Unfortunately, there’s nothing you can do to get the subreport export onto the same line with data only, but they suggest a couple of alternatives:. Then set the number of columns to 3 and try how the report will run. Because of the different data sources, the sections in the individual sub-reports may vary in length from one another, so my crsytal report is rendered as such:.