SSRS Export SQL data to a predefined Excel printing format and put it on intranet

  • Previously, I created a SSRS report and set the report properties to landscape, tabloid and 17 x 11 printing format. When user goes online and ran the report and export it to Excel the predefined printing format did not take place. I do not think SSRS cannot invoke the Excel printing format. I need something that I can place Excel on intranet and can call a view or store procedure for user to export it with my pre defined printing format. Also on the report I have group by section and bold the line on each new group. Can this be done on Excel? Any recommendation? Thanks.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply