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.