sqlsql-serverreporting-servicesgroup-byssrs-2008
Sql select with grouping rows
In mssql-db I have a table with 5 columns. id, 1st_t1, 1st_t2, 2nd_t1, 2nd_t2
it's single "task" with 2 parameters(t1,t2) "grouped" by person type(1st,2nd)
Is it possible to select info like this on picture in Reporting Service?:
Or the only way is divide this table on two tables for each person type?
Solution
In your report, your detail must have two rows.
On the first you will drag and drop the data of the 1st person and on the second row for the second like in the image below
- Choosing simple products and variable products separately in WooCommerce tables
- collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- SQL query to check if a name begins and ends with a vowel
- Separating fields in the same column
- SQL filter for same values in different columns
- How do I repeat a SQL query over a set of records?
- SET CONSTRAINTS ALL DEFERRED not working as expected
- SQL YEAR(GETDATE())
- Dynamic sql to retrieve volume count throwing incorrect syntax error
- Snowflake SQL finding the rows diffs between 2 large tables
- Recursive CTE 'Query Error: relation [] does not exist', PostgreSQL v17
- Split single row to multiple rows based on date range - Amazon Redshift
- Insert literal '${value}' without variable substitution into PostgreSQL table from DBeaver
- data type changes when using AVG in view definition
- Postgresql with accent-insensitive and case-insensitive pattern matching
- Spring doesn't translate SQLException to DataAccessException
- SQL Merge WHEN NOT MATCHED BY SOURCE THEN on filtered source and targed tables
- How to find second match in sql
- SQL obtain timestamps for end datetime row 1 and start timestamp row 2
- find time half hour before "06:00 AM" in sql
- Tricky SQL update
- DBeaver @export command with SQL script
- Avoid repetition of strings in SQL query
- Remove Identity from a column in a table
- Escape a single quote in plain Databricks SQL
- Return 1 if value is 0 without CASE statement
- Append string text based on pattern search SQL
- How to find Cyrillic font (russian characters)?
- Why is my sql statements giving wrong results?
- Oracle JSON_OBJECT how to have a missing key