Column header text is showing blank though the report design having the column header text

Aspose.Cells Product Family
1

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,

  1. 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.
  2. 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.
1 Like
2

@BalaR,

Thanks for sharing some details.

Could you provide us RDL file and Excel renderings (by Aspose.Cells for RS and SQL Server reporting services built-in renderer), etc., we will check it soon.

Thank you.