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
5
votes
2 answers

Interactive sorting In SSRS on Values - Matrix report

I want a interactive sorting in SSRS matrix report. From database we are getting 3 columns -PrimaryKey,Columns and Value. We are grouping rows by Primary Key and grouping column by Columns and use Value as data. My Matrix Report - ID …
Wumar
  • 103
  • 1
  • 1
  • 11
5
votes
2 answers

SSRS and AD Groups

I had a request come through asking me to create an AD Security group that could be used in SSRS for users to get reports. There are currently other AD groups that work but the one I have created does not allow users to connect. Creating AD groups…
user2596180
  • 51
  • 1
  • 2
5
votes
1 answer

SSRS Comparing 2 rows (new vs old) and highlighting the differences / changes

I have a report which gives the current state of an item, and the previous state of an item and I want to display both rows and highlight the differences. For example: STATUS ORDER# NAME ADDRESS QTY PRICE TOTAL new …
Jay
  • 455
  • 3
  • 17
  • 34
5
votes
1 answer

How to I get cumulative monthly subtotals in SSRS?

I'm using SSRS to create a report which shows a lot of transactions according to a trade date. I've made a group on the month and year called 'grpMonthYear'. Inside that group I've made a subgroup on 'TradeDate'. The groups and all work perfectly.…
Vivek Todi
  • 361
  • 1
  • 9
  • 24
4
votes
1 answer

How can I fix the number of groups in each page of SSRS

I have a Report which displays 6-groups(5-Rows in each Group) of information. The report is having some filter which can be modified by user. When first time report get loads without any filter its page rendering in report viewer and Print page is…
Irfan
  • 665
  • 6
  • 29
4
votes
2 answers

How to group this SSRS report?

I have an SSRS report. It looks like this: Its definition looks like this: As you can see it's just a bunch of numbers in different columns A to G. Those numbers were grouped by A then B then C. For each row in the report, column D,E,F,G are my…
Just a learner
  • 26,690
  • 50
  • 155
  • 234
4
votes
1 answer

Column and Row grouping in SQL Server Reporting Services 2008

This is the desired result I need to populate as a report, where xx is number of people. I have a table which has fields like: ---------- table1 ---------- id state year(as Quarter) gender I need to determine the count from id and populate as a…
jero
  • 543
  • 3
  • 13
  • 30
4
votes
1 answer

SSRS Reporting: How to limit the number of rows returned in a group

How can I limit the number of rows returned in a group? So far, when the report runs, it returns a lot of records for each group. However, I only want it to return the top 4 records in each group. I tried the expression:…
Guillermo Greco
  • 63
  • 1
  • 1
  • 5
4
votes
1 answer

how to display multivalued parameter value in SSRS text box

I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT ALL' option in the parameter i should display just…
SqlLearner
  • 763
  • 8
  • 23
  • 37
4
votes
4 answers

SSRS 2008 R2 export to Excel leaves row one as blank

In an SSRS 2008 R2 existing report, I want to change the report so the users have the option to hide headers when they export the report to excel. By allowing the users to hide headers when they export the SSRS 2008 report to excel, they can sort…
user1816979
  • 511
  • 4
  • 13
  • 25
4
votes
2 answers

Repeat parent group if child group goes to another page

I have a report that allows Finance to print off multiple invoices at the same time. The problem I'm running into is that they want the Bill To information repeated on each page of the invoice. I have two groups set up on the report. Group A is…
DForck42
  • 19,789
  • 13
  • 59
  • 84
4
votes
2 answers

How to add a total count column for an expression field

If I have a table (tablix) in SSRS, and one of the columns is a simple expression: =Fields!NumPorts.Value - Fields!PortsUsedLastQuarter.Value Then how can I add a "total count" column for this? I can't add a total column, it's greyed out because…
Matt Roberts
  • 26,371
  • 31
  • 103
  • 180
3
votes
4 answers

Summarize data that has already been grouped

I have a data set that looks like this: User | Task | Time --------|--------|-------- User A | Task X | 100 User A | Task Y | 200 User A | Task Z | 300 User B | Task X | 400 User B | Task Y | 500 User B | Task Z | 600 User C |…
Joe Phillips
  • 49,743
  • 32
  • 103
  • 159
3
votes
1 answer

SSRS Using Sum Based On Condition From Multiple Procedures?

I am creating a report and trying to Get a Sum combining values from multiple tables and can't figure it out and am beginning to wonder if it is even possible? I have 2 stored procedures returning the same data with different time frame. One stored…
buzzzzjay
  • 1,140
  • 6
  • 27
  • 54
3
votes
1 answer

Consolidating multiple rows to a single row

Is it possible to join multiple row values to a single row? The stored procedure from where I acquire the data that I use return multiple, almost identical rows except that the category-column dfferentiates for products that have been assigned…
Leonard
  • 3,012
  • 2
  • 31
  • 52
1
2
3
…
27 28