sql-serverreporting-servicesreportreportbuilder
Report Builder: Print Table Results into Different Worksheets in Excel
I'm using Report Builder for SQL Server 2017. My report has multiple tables which is using more than one datasources.
Is there a way to print table results into different worksheets in Excel?
Solution
Yes, within the property section of each table there is a field called "PageName". Set the name for each table to what you want your tab in Excel to be called. When exported to Excel, then a separate worksheet is created for each one.
- Summation of a column using certain conditions
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?
- Is there any way to get lcid of current session in a function with schemabinding option?
- How to find databases which accessible to me in Sql server?
- Default encoding in SQL Server Management Studio
- Database stuck in "Restoring" state
- Unable to open BCP host data-file
- How to join parent object with nested array using OpenJson SQL
- Efficient paging with Repeater, SQL Server and custom Pager
- Queries using LIKE wildcards in sql server
- Conditional aggregation in SQL: display condition-dependent count in percentage?
- What would be the ideal way to do paging using a Infragistics WebDataGrid and SQL Server 2008
- output sql data to html with hyperlink
- Update all column names to be lowercase
- Connect python-polars to SQL server (no support currently)
- SQL Server pivoting on data without an aggregate
- replace or remove characters and then cast to decimal
- Query to get only numbers from a string