Stack Overflow
Stack Overflow

Questions tagged [ssrs-grouping]

Microsofts SQL Server Reporting Services (SSRS) allows creation of reports that contain Tablix controls where data is grouped by fields or expressions in row and/or column groups. Use the ssrs-grouping tag for questions about how to use group properties to change report behaviour.

SSRS reports can contain tablix controls (lists, tables, and matrices) which can group data in row and/or column groups. Use this tag for questions specific to this grouping behavior.

412 questions
1
vote
1 answer

SSRS add new page when it should not

I am using SSRS 2008. This does not make any sense but it is happening. I built a report that show invoices based on invoice number. The problem is that when I move the table up a single pixel it adds a new page in the end (it should not). I have…
asmgx
  • 7,328
  • 15
  • 82
  • 143
1
vote
2 answers

Row number within an SSRS report

I have a group in my report where I have to use row numbers within that group, I was wondering if there is a way to display row numbers using expressions, or if I have to modify my Store procedure and include row numbers for that group.
Avinash
  • 1,273
  • 4
  • 16
  • 23
1
vote
3 answers

SSRS - Is it possible to have detail rows under a parent row

I have a report that currently lists data of a parent and its the details on the same row. So lets say the columns of the parent group take up the first three columns and the details the next three. Currently the first three columns span the height…
Neil
  • 2,659
  • 7
  • 35
  • 57
1
vote
1 answer

SSRS Break after n occurrences of group

I am trying to group an SSRS report so that each page breaks naturally around the 11 inch mark. It looks as though you cannot dynamically set the Interactive Height property so I have set it to 0 and am applying page breaks to the dataset. I am…
gruff
  • 411
  • 1
  • 9
  • 25
1
vote
1 answer

Grouping in SSRS?

I am new to the SSRS and Have data like to be present as below. They are all from the same dataset, just like to group 2 columns, that is [WrkCrtId, Name] show on top of them. I've tried some ways to do this but still fail, I was wondering if any…
ppnfk
  • 74
  • 1
  • 5
1
vote
1 answer

Include NULL in each "Details Group" in SSRS

In SSRS I have a List with, say, a table with two columns: name and number e.g.: NAME NUMBER John 123 John 456 John NULL Name is never null, but number may be. In this case I want the report to include the NULL in each group, like this: GROUP…
Lynx Kepler
  • 662
  • 1
  • 9
  • 21
1
vote
0 answers

SSRS - Rectangle grouping (Multiple tables with different dataset in one rectangle)

I would like to design a report that has multiple tables (different datasets) in a rectangle and the rectangle is showing data which is grouped by company. Could anyone advise on this? Please feel free suggest other solution if my proposed solution…
Nel
  • 63
  • 2
  • 9
1
vote
1 answer

T-SQL help with multiple pivot / unpivot

I am not sure what will be the best approch pivot or unpivot. I have following column in one table. group1 | group2 | group3 | amtA1 | amtA2 | amtB1 | amtB2 | amtC1 | amtC1 and I need to product table like group1 X | amtA1 | amtB1 | amtC1 Y |…
codemihir1
  • 13
  • 3
1
vote
1 answer

SSRS Report - Creating Calendar Style Report with Multiple Data in a Single Calendar Cell

I am trying to achieve calendar style report using this link : http://msdyn.blogspot.com/2013/07/create-calendar-style-reports-in-sql.html But this Calendar Style Report is for the Sum of Sales. My desired result of the report is to return a list…
interkey
  • 355
  • 5
  • 21
1
vote
3 answers

Conditionally grouping tablix in SSRS reporting

My tablix has following columns Country, City, College, totalstudent,passedstudent,failedstudent I have a parameter "GroupBy" with values "country/city/college". So, when i select one of the parameter, my tablix should be grouped by that parameter…
OmGanesh
  • 952
  • 1
  • 12
  • 24
1
vote
1 answer

RDLC details columns between two gouping columns

How to put details columns between two grouping columns as follow:
geek
  • 346
  • 6
  • 14
1
vote
1 answer

How to add totals to each group in SSRS

I need to have a total for each grouping within a row group in SSRS. Currently, a total is added right at the end of the row group. So, if I have the following data: TeamName BusinessSegment PaymentPeriod BusinessArea ProductType …
Rudolf Lamprecht
  • 1,050
  • 1
  • 14
  • 37
1
vote
3 answers

SSRS - How do I achieve bars coloured according to projects in a Gantt-chart?

I am attempting to create a graph to visualize a kind of facility-utilization stat. My query returns rows like so: |StartDate |ProjectNumber |Facility-ID |Hours |EndDate | |2016-01-01 00:00:00 |Project-A |Fac-A …
Erik Wilson
  • 21
  • 5
1
vote
2 answers

Hide Control Key Group Value in SSRS

I have been using SSRS off and on since SQL Server 2008. There are a number of typical SSRS pitfalls and gotchas. One of these I need to go over with some one. This should be pretty easy for an experienced SSRS resource / expert. Let me explain the…
Nomad
  • 771
  • 4
  • 9
  • 19
1
vote
2 answers

SSRS. Group 2 different parts of a row in the report

I use SQL 2008 I have report with few groups on the left, then some numbers and another numbers (further on the right) which has to be groupped as well. Field1 Filed2 Filed3 Num1 Num2 Num3 Num4 fff sss aaa 1000 2000 3000 4000 …
Boppity Bop
  • 9,613
  • 13
  • 72
  • 151
1 2 3
…
27 28