I have a report that has two tablix tables that point to the same dataset. One is used for display and printing as is not intended to export for data extracts. (DataElementOutput is set to NoOutput for the entire Tablix control)
The other tablix is hidden and is intended to be used when exporting to a data only format (XML, ,CVS, Excel Dataonly). (DataElementOutput is set to Output for the entire Tablix control)
This report runs and works as expected. Except for when using ASPOSE cells Excel data only extract export.
When exporting to XML, I get the results as I expect. When I export to Aspose Excel data only ... I get the tablix data that is visible and that is set to NoOutput... and I dont get the hidden one, that is set to output.
Is this a bug?
Also, when exporting to Excel Data only .. I also get the "Report Name" and the "Report Title". The report title is set to NoOutput.. not sure where to set the name.... Can this be excluded from the Excel Data only extract?
Thanks (im usssing SSRS 2008R2)
Aspose Cells Data Export.xlsx - Shows how the report exports using Aspose Excel Data only export
Designer.doc - Screen shots of the RDL designer
Printed Output.pdf - shows how the report is viewed and how it would print.
XML converted to Excel - show the data exported to XML, then opened and saved in Excel
XML Output - Report exported and saved to XML