sqlsql-serverreporting-servicesssrs-2016
Can SQL Server Reporting Services print multiple tables and charts on one page?
I'm new to SSRS and I'm not sure if what I want to do is possible with SSRS. I have a list of 100+ schools in my data set. I'd like to print one page per school, and for it to look like the picture below. Each table and chart are using a unique data set, but it's all coming from one main table.
Can SSRS print two separate tables and 2 charts on the same page per school?
If so, where do I set the page breaks and how would I set this up please? If you need any more information, please let me know.
Thank you!
Solution
You can use a list in order to group by school and set the page break property of the list to End.
As long as your table and graph data fit to one page, you can position report components as your sample layout
- SQL count occurrences based on values in other columns
- How to write this SQL query to find each account balance?
- SQL Query to get latest price
- Join newest price from price-table for all products
- Order By In a SQL Table Valued Function
- Return columns with a single value
- Missing FROM-clause entry for a table
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- select multiple cells inner join one table
- Split a string with no delimiters into columns
- SQL query to get the employee who has not been appraised
- TOAD for Oracle, variables for schema/ table names
- TSQL Pseudo Random text generator
- Get user last purchase date from specific product in WooCommerce
- Recursive CTE in Postgresql
- Add missing dates in a table
- ORACLE APEX ADMIN LOGIN ISSUE
- Cast value to type (TEXT) using string representation of type ("TEXT")
- Get records that have total count of over X amount
- Excluding records between dates AND with an associating value
- SQLdevelopersfruit puzzle
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Fetch last row for each month, or previous month if not found
- Convert table with columns as path (bread crumbs / levels) to hierarchy (tree) representation
- How to create table like another table with additional columns in MYSQL
- Connecting to Microsoft SQL server using Python
- How to use STRING_AGG function inside another STRING_AGG function in SQL Server
- Clean up a SQL Server Query with too many DISTINCT clauses in it
- How to decrypt stored procedure in SQL Server 2008
- In DuckDB, Is it possible to change a value based on the previous value ordered by another column without using UDFs?