Anyone can suggest how to change the Excel-Data only format for Trial Balance on cloud?
1 Like
I’ve had luck tricking SSRS in the past (not sure if it still works). Save a copy of the report style and name it Excel Friendly.
Make the changes you need to that report as far as formatting for Excel Friendly.
Then upload the report.
Print using the new Excel Friendly format with output to Excel Data Only. This will generate the file on the server with the _ExcelDataOnly suffix.
Now you can save your local copy to _ExcelDataOnly and make any additional changes you need (typically the column widths don’t usually take on the first upload).
Change your report location to add the _ExcelDataOnly suffix on the Report Style.
Then Upload your ExcelDataOnly report.
Now change your report style location back to the default filename (without the _ExcelDataOnly).
This should leave the one you uploaded in place of the original auto-generated one.
3 Likes