I have used Aspose Cells to design the excel template by adding dataset and bind the fields (Around 30 fields) into the excel sheet.
I published the designed report into the SQL Server Reporting Services.
Currently, I have faced two issues,
- Some of the column header text is showing as blank, but the data is displayed properly.
Root Cause: The Column header text having text like “Total”, Due to that the report is not showing header text.
- For the single database field, the first three columns (A1, B1 & C1) are merged and showing the values. Also, some of the columns are hidden.
So, I am not able to generate the pivot table using the excel exported from the SSRS.