BOR15K (8/6/2013)
I guess I need to look for another solution as customer's sites do not have SSRS installed.Any other advise, please?
Kind Regards
The only tool in the SQL Server stack that can format Excel files is SSRS.
All the others (SSIS for example) just dump the raw data into the Excel file. You could try to work with named ranges though as destinations in SSIS, but SSIS is not included in SQL Server express.
Macro's are always another alternative. You take an excel file with the layout already present and you fetch the data using a macro.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP