Posts

File Share Delivery in Reporting Services

https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/file-share-delivery-in-reporting-services   To include a timestamp in the file name, add the  @timestamp  variable to the file name (for example,  CompanySales@timestamp ). 

Dynamically name report/file export in SSRS

https://www.sqlservercentral.com/articles/dynamically-name-reportfile-export-in-ssrs  

Use REPORT BUILDER to Output to Multiple EXCEL Sheets

Click on the Group in Row Groups, expand the Group in the Properties window, set the PageName property which becomes the Sheet Name.

Export a paginated report to Microsoft Excel (Report Builder)

https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-microsoft-excel-report-builder-and-ssrs?view=sql-server-ver16  

Nested data regions in a paginated report (Report Builder)

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/nested-data-regions-report-builder-and-ssrs  

Exploring the flexibility of a tablix data region in a paginated report (Report Builder)

  https://learn.microsoft.com/en-us/sql/reporting-services/report-design/exploring-the-flexibility-of-a-tablix-data-region-report-builder-and-ssrs

Controlling the tablix data region display on a paginated report page (Report Builder)

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/controlling-the-tablix-data-region-display-on-a-report-page