Which file export format do you use if wanting to export the subreport & main report data? I have found that .csv or .xls doesn't export the subreport data. Only .ttx format does. Anyone else having issues where it can take several hours for the report to export to .ttx? Anyone else have other suggestions for this? Your feedback would be appreciated!! Thank you!
When a sub-report is inserted into a larger report only the first page of results execute in the sub-report. When you export, the sub-report is run for each subsequent page in the report. Depending on the size and complexity of the report exporting can take a long time and I have experienced crashing due to insufficient temporary memory space within CR when exporting very large reports. We do have a dedicated VM to run reports that we anticipate problems with so we don't tie up our work computers, but sometimes we need to break the report into smaller chunks and then combine the outputs.
I've never had an issue with exporting to .xls or .csv with sub-reports other that the temp space issue mentioned above.