Free Support Forum - aspose.com

Reporting Services - Groups

I'm trying to do a simple layout but can't seem to figure out how to do it with Aspose.Cells. I have a list of companies and these are broken into sectors. My layout needs to look like:

Sector 1
...Company Row(s) for Sector 1...

Sector 2
...Company Row(s) for Sector 2...

... etc ...

The best I have gotten is only a single sector and the companies under this sectors, but the sector layout didn't repeat the structure.

-Damien


Please try Aspose.Cells.ReportingServices design tool .

1. Download latest version(http://www.aspose.com/community/files/52/ssrs-rendering-extensions/aspose.cells.reporting.services/entry125756.aspx) and install it.
Reference to installation guide(http://www.aspose.com/documentation/ssrs-rendering-extensions/aspose.cells-for-reporting-services/installation.html)
2. Design report in excel.
Reference to user guide(http://www.aspose.com/documentation/ssrs-rendering-extensions/aspose.cells-for-reporting-services/user-guide.html)
3. The attachment is an example. Please reference.

I have followed all your directions, but still can't structure the Excel file correctly. My RDL file is a simple table with two columns, Sector and Company Name. I load this into Excel sucessfully. I want to group all the companies under it's sector (as described before, but there are n sectors). My layout is as follows:

+--+----------------------------------------------------+
| | A | B | C |
+-------------------------------------------------------+
|1 | | Sector |
+-------------------------------------------------------+
|2 | | | Company |
+-------------------------------------------------------+

I belive my problem is with my attribute. I've tried various Range and Group By options with no luck to produce a grouped company list with the sector as the "header" for each group.

Thanks,
-Damien


The attachment is an new example. Please reference.

If the example still does not satisfy your requirement , please post your excel template file here.

Thank you.