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

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

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.

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

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.

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

 

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,

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

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:

      <Extension Name="ACXLSX(Data Only)" Type="Aspose.Cells.ReportingServices.Excel2007SimpleXlsxRenderer,Aspose.Cells.ReportingServices">
       <Configuration>
            <DeviceInfo>
                <SimplePageHeaders>True</SimplePageHeaders>
   <OmitDocumentMap>True</OmitDocumentMap>
            </DeviceInfo>
        </Configuration>
      </Extension>

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.

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

Hi,

 

You need to add page break (start) at the second Tablix about Tablix page break issues

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

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,

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

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.

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

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