Subreports do not export to Excel 1

[rteel]

I was viewing the thread thread1462-1401263 which is now closed. No solution was posted however the user onpnt makes the claim that they where able to export subreports. I do not know how that is possible unless there was some miscommunication and some important bit of information was left out. We are currently running into the same issue as goofaholix described.

We have a report with three subreports. The subreports have parameters which are populated from the data in the master report. The subreports are located in a table as we need to group this data. We are directly rendering these as Excel or PDF and are not using the ReportViewer control. The reports are rendered from a C# web application.

When we render the reports to PDF they look great with the exception of the left and bottom boarders are missing from the subreports. When we export to Excel the data in the master report is exported however the subreports are replaced by the text "Subreports within table/matrix cells are ignored". This behavior also occurs in Visual Studio while previewing the report and selecting export to Excel.

Does anyone know how onpnt was able to export to Excel? If not, does anyone know a way around this?

The Report output needs to be something similar to this.

City
Building
Classes
Data
Staff
Data
Students
Data

Building
Classes
Data
Staff
Data
Students
Data

We are looking at creating one query to return all the data however dealing with subreports makes this much easier.

Thanks,
Rich

 

[xlbo]

The issue is with subreports in a table

If you need to keep data together, you may look into using the LIST control item instead - you may then use textboxes within the list control to generate a table-esque structure - you may also create groups and have subtotals within a list control...AFAIK, subreports embedded in a list or ractangle DO export to excel just fine

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[rteel]

Thank you for your response. The previous thread I refered to was missing this information. We should be able to resolve this problem now.

Thank You,
Rich