How to achieve group outline Aspose SSRS?

Aspose.Cells Product Family
1

I have a rdl that does grouping but i am not sure if we can show the grouping outline when rendered to excel.

2

Hi,


Thanks for your query.

It should work fine regarding Grouping outline (as per your RDL file) in the rendered Excel report. Could you provide us your RDL file and output Excel file (XLS/XLSX) by Aspose.Cells for RS and an output Excel file (XLS) by built-in Reporting Services renderer, we will check it soon.

Thank you.
3

The .rdl and excel file are attached. Desired output should be like the last excel attachment.

4

Hi,


Thanks for providing us sample files.

We observed you need to apply grouping rows in the worksheet of the generated Excel file. I have logged a ticket with an id “SSRS-40231” for your issue. We will check if you need to update your RDL file a bit or add some other configurations to accomplish your task (if possible).

Once we have an update on it, we will let you know here.

Thank you.
5

Any updates on this one?

6

Hi,


I am afraid, there is no update on your issue (logged earlier as “SSRS-40231”) yet. However, I have logged your concerns against your issue into our database. Hopefully the concerned developer from product team will evaluate your issue soon.

Once we have an update or a possible ETA for it, we will let you know here.

Thank you.
7

Hi,

Thanks for considering Aspose.Cells for Reporting Services.

We have checked your provided report definition file.

At the moment, Aspose.Cells for Reporting Services Report Designer does not support this feature.

We will spend one or two weeks on a fixed version for supporting group outline for table report item (will only support SSRS2008 version or later).

8

Hi,


We have
added your requested feature for group outline. Please try our latest fixed version (attached): Aspose.Cells for Reporting Services (SSRS2008R2) V2.4.0.4.


Please copy Aspose.Cells.ReportingServices.dll into following folder : ${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.


Please let us know your run result. And, we will continue to work on it to make the feature perfect.


Thank you.

9

Thanks for the help! It works however we need small change here. When the report is first rendered in excel, can we keep the outline expanded (show) instead of hide.


Or probably add a feature client side to set the default behavior(show/hide outline) to begin with.
10

Hi,


Good to know that the new feature (group outline) is working now. For your recent demand, we will check if this can be done using some configurations or we could enhance the supported feature for your needs. I have logged your concerns/comments against your issue “SSRS-40231” into our database. Our concerned developer from product team will evaluate it soon.

Once we have an update on it,we will let you know here.

Thank you.
11

We have added, configure UI for group outline.

Please try the fixed version: Aspose.Cells for Reporting Services V2.4.0.5.

You need to re-install Aspose.Cells for Reporting Services V2.4.0.5 in order to update client and server components.

Please refer to following contents which show, how to configure group outline.

1. Open report definition file with Aspose.Cells for Reporting Services Client.

2. Open “Modify Report” From and choice outline tab. ( see image007.jpg )

3. Hit Modify button and update Hide configure. ( see image008.jpg )

4. Hit Commit button and save hide configure. ( see image009.jpg )

5. Save and publish report.

Please let us know your run result. Have a good day.

12

After installing the fixed version, the aspose excel add-in throws an error on load. Please see the screenshot attached.

13

Hi,

Thanks for using Aspose.Cells for Reporting Services.

Please refer to following online documents about Aspose.Cells for Reporting Services Client FAQ:

( Automation Error|Documentation )
( Runtime Error 429|Documentation )

If you still have any question, please give us detailed information about your run environment.

14

The issues you have found earlier (filed as SSRS-40231) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.