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

Remove the dynamically generated blank columns from rdl

I have a SQL server result set which I need to display using SSRS rdl. The result set id like: SpeakerId Product Topic 16 a A 16 a B 16 b C 16 a D 17 …
sjs
  • 45
  • 1
  • 8
1
vote
0 answers

In SSRS are group variables always re-evaluated or cached?

In an SSRS report I've got a row group for which a handful of variables are defined; i.e. they are defined at the group not the report level. Some of the variables are a function of the other variables. Within the context of a row is the value for…
dkackman
  • 15,179
  • 13
  • 69
  • 123
1
vote
1 answer

SSRS Bar Chart by Group with Separate Categories

I have built quite a few SSRS reports with Charts, but I have been a new chart that I need to build and I am not sure if it is possible or how to create it? Any ideas?
buzzzzjay
  • 1,140
  • 6
  • 27
  • 54
1
vote
1 answer

Serial Number in SSRS Pivot Report

I am trying to put a column in SSRS report with running serial number. The report is pivoted in SSRS. I tried the same with RunningValue function and RowNumber too. But still it could not generate it in the way i want. It's generating the rownumber…
Gopal Krishna Ranjan
  • 848
  • 1
  • 12
  • 21
1
vote
1 answer

SSRS group based on two columns

I have a report that displays a list of duplicate accounts based on our business rules. This works when one new account is matched with other existing accounts. Where I'm having trouble is when multiple new accounts match the same existing…
StevenWhite
  • 5,907
  • 3
  • 21
  • 46
1
vote
2 answers

Trying to use a group by statement in an aggregate in SSRS Report Builder 2008

I have a report in SSRS 2008 that has two row groupings. The lowest level of detail is grouped by legalcase, and then there is a summary row that is grouped by outside counsel name. The query in the dataset is actually returning records at a lower…
user1603734
  • 1,071
  • 2
  • 10
  • 15
1
vote
0 answers

SSRS Creating Treeview

So I'm having problems when trying to make a treeview from a group. I have a folder structure in my database that gives me the path that each node should have. The problem is that the recursive parent seems to only look at the immediate parent…
McScripter
  • 11
  • 2
1
vote
3 answers

Grouping issue in SSRS

So I have a table that has divisions and sub-divisions. The structure is as follows: COMPANYID | DIVISIONID | DIVISION | PARENTID 1 | 1 | North | NULL 1 | 2 | South | NULL 1 | 3 | East |…
D.R.
  • 1,199
  • 5
  • 19
  • 42
1
vote
1 answer

Conditional Group in SSRS Tablix or DB View

I've created a report that is supposed to use a tablix to group data exactly as seen below: Region | State | Customer | CustomerKey | Status North | NY | Bob | 111 | VIP | | Mary | 112 |…
dp3
  • 1,607
  • 4
  • 19
  • 28
1
vote
1 answer

How to apply grouping in SSRS RDL report

I have to create report SSRS RDL.I am new to report. Can anybody suggest me how to design report OR apply grouping so that it looks alike as given below format: and following records are coming from database: Where Total AA = 3(1+2),4(3+1) Total…
Sukhjeevan
  • 3,074
  • 9
  • 46
  • 89
1
vote
1 answer

Pull data from footer into the body (or into a new report)

I have an SSRS report. At the level of the footer I'm showing the table index of a table added in the report body, because it contains more than 500 pages (the table index is drawn from code "concatenating the report group name with the page…
jozef
  • 335
  • 1
  • 3
  • 15
1
vote
2 answers

SSRS Constant group height

In my report I have a group with an inner detail group. Group details more of the group I need 3 groups on each page and I need each one to be lined up correctly. Each group member can have between 1 and 4 rows. When there are 4 rows for each…
Aheinlein
  • 480
  • 2
  • 7
  • 19
1
vote
1 answer

SSRS - Manager with employees utilized by other managers

I am trying to create an Employee Utilization report in SSRS (Visual Studio 2010, SQL Server 2012) We have employees who work for multiple program managers. I need a report that shows program managers, the employees who work for them, and the…
ARay
  • 23
  • 1
  • 5
1
vote
0 answers

SSRS filter TOP N with others

I have a datase with man rows and couple groups/subgroups. Child group can have many records and i need to show only 5 first and others have to be in row "Other". I managed to filter group like this: Expression: Product Operator: Top N Value: 5 But…
JNM
  • 1,175
  • 4
  • 20
  • 39
1
vote
1 answer

SSRS - Blank grouping/duplication issue

I'm sure this is a quick fix, but it's really got me scratching my head as I'm new to working on this level/type of issue in SSRS... First screen: http://www.pasteshack.net/images/579309001341850589.png Second…
Waller
  • 1,795
  • 4
  • 18
  • 35
1 2 3
…
27 28