I am calling SSRS reports from an in house piece of software. All the reports made before me render as xlsx or xls and mine continuously are rendering as csv files which is messing up my formatting. Does anyone know how to address this?
From ReportBuilder, select Export and change the render type from CSV to Excel. If you have access to the VB code but not ReportBuilder itself, look for the 'render' command and change the 'format' parameter to Excel. If neither of those work, try the suggestion at https://itstillworks.com/change-default-rendering-ssrs-6364430.html