Free Support Forum - aspose.com

SSRS Excel Data Only Export

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)

See attached:
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

Hi,

Thanks for your posting and using Aspose.Cells for RS

Please download and try the latest version:
Aspose.Cells
for Reporting Services v1.8.0.3 (SSRS2008R2
)
and let us know your feedback

I was using the Aspose.Cells for Reporting Services 1.8.0 version that I downloaded yesterday. Is this one any differant?

I downloaded it from : http://www.aspose.com/community/files/52/ssrs-rendering-extensions/aspose.cells-for-reporting-services/entry353793.aspxhttp://www.aspose.com/community/files/52/ssrs-rendering-extensions/aspose.cells-for-reporting-services/entry353793.aspx

Hi,

Yes, this is a minor release. You were using the major release before.

Minor release fix the problems in the major release, but you need to do manual installation.

Just replace your older dll with this new one and it should work.

Hi ,

At present Aspose.Cells.Renderer does not export following report items data:

1. The Data Element Output of report item sets to no output.

2. The visible of report item set hide.

Please provide your report define file here.

We will check it.

For number 2.. I would like this to work like the XML output does. The tablix will still output if hidden, if the item is set to Output

Hi,


Thanks for providing RDL file.
I have logged a ticket for it with an id: SSRS-40016. We will look into it soon.

Thank you.

I tried the new dll from the previous post (1.8.0.3) and still have the same issues with the export.

1. The report title was showing but I was able to suppress it by modifing the XML in the redering extension to this:




True
True


But I still have the issue that the tablex that is set to noOutput still outputs, and the one that is hidden that is set to Output does not show in the excel file.

The reason for the two tables in this case (see RDL from above) is that the first tablix has a form style layout with concatenated field labels, and the second table just has a simple table layout.

I would like the excel data only export to always respect the noOutput, Output, Auto options.

noOutput = dont export for a data extract
Output = export in a data extract even if field or table is hidden
Auto = export if field or table is visible, dont export if the field is hidden.

Additionally, I have another report that has two Tablix tables, both are set to output.

Each tablix has the "Page Name" set, I would idealy like the data exported into two differant tabs (sheet) in Excel. (like the Export to Excel works natively)

Currently with the ASPOSE Data Export they both export to the same sheet, one after the other.

Hi,

We have logged your provided information in our database. We will advise you asap.

Hi,

<span style=“font-size:10.0pt;font-family:“Verdana”,“sans-serif”;mso-fareast-font-family:
Calibri;mso-fareast-theme-font:minor-latin;mso-bidi-font-family:“Times New Roman”;
color:#1F497D;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>You need to add page break (start) at the second Tablix about Tablix page break
issues

<span style=“font-size:10.0pt;font-family:“Verdana”,“sans-serif”;mso-fareast-font-family:
Calibri;mso-fareast-theme-font:minor-latin;mso-bidi-font-family:“Times New Roman”;
color:#1F497D;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>
<span style=“font-size:10.0pt;font-family:“Verdana”,“sans-serif”;mso-fareast-font-family:
Calibri;mso-fareast-theme-font:minor-latin;mso-bidi-font-family:“Times New Roman”;
color:#1F497D;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>Thank you.

I added a page break to the start of the second Tablix, and still have the same result.Both tables extract to the same sheet in Excel.

And I still have the issue that the tablex that is set to noOutput still outputs, and the one that is hidden that is set to Output does not show in the excel file.

(Im an extracting using Excel 2007 Data only)

Hi,


Thanks for your feedback.

We have logged it and we will soon look into it.

Thank you.

Hi,

The Excel 2007 data only rendering did not have the break page function in older version.

Now we have added new page break feature for excel 2007 data only rendering.

Please download and try the latest version: Aspose.Cells for Reporting Services v1.8.0.5 (SSRS2008R2).

And let us know your feedback.

I tried the new dll, and the page break still doesnt work to create a new tab

Hi,

Please try the latest installer instead: Aspose.Cells for Reporting Services v1.8.0.5 (MSI) and let us know your feedback

Hi,

We have tested sample report define file.

The page break can work normal.

Please check and reference the attached report define file.

If you still face the issues, please post your RDL (report define) file here.

We will check it soon.

I downloaded the MSI installer for 1.8.0.5 and now the data export to excel exports to two differant sheets, but the report header shows on the first sheet. I do not want the header to show on a data extract

Also I get an extra sheet in the results in the middle of my valid sheets.

so.. I have

sheets..

Summary - sheet2 - TimeDetail (and sheet 2 is blank)

UPDATE - I removed the page break on the second tablix, and now I get two sheets as expected, except the second sheet has 13 blank lines. I want both sheets to start at the top.

Hi,

Thanks for your feedback.

We have logged your issue in our database.

Our development team will look into it and once, we have some update relating to it, we will let you know asap.

Hi,

Please download and try the fixed version: Aspose.Cells for Reporting Services V1.8.0.8 (SSRS2008R2)

Copy Aspose.Cells.ReportingServices.dll into following folder:

${SQL SERVER 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin</b>

If you still face issues , please post your report define file here.