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

SSRS Report Hyperlink Loses Functionality in .net Application

I have an SSRS report that employs RowGroups to group data. One of the fields used in the group is a field that stores a URL as text. I've set a Go To URL action on a textbox which enables it to act as a hyperlink that opens up the URL stored as…
dmedz
  • 191
  • 3
  • 5
  • 14
0
votes
1 answer

SSRS get the last row on each page

In SQL Server Reporting Services I have a row group with a dashed bottom border separating each row. I want to remove that dashed border from the last row on each page. How do I calculate the last row on each page? I counted 25 rows on the first…
Alaa Awad
  • 3,612
  • 6
  • 25
  • 35
0
votes
1 answer

Grouping in SSRS 2008 R2 - grouping and organizing fields

I am writing a report in which there are groups in 3 columns, and a subtotal figured at the end of each group. When I create the grouping, a column is created out to the left of the report. I am normally in the habit of renaming the grouping…
Jerry C
  • 181
  • 1
  • 5
  • 15
0
votes
1 answer

How to format background color of a cell which is under a group? - SSRS 2008 R2

I have the following matrix: Design view -------------------------- | OfficeSID | [Type] | -------------------------- | [OfficeSid] | [Value] | -------------------------- Preview ---------------------------- | OfficeSID | A | B …
user2104571
  • 1
  • 1
  • 1
0
votes
1 answer

SSRS in Visual Studio: Matrix grouping takes only the first row

Here's the situation. I'm doing a SSRS report in VisualStudio 2010. For some reasons, I can't do it from SQL Server and I can't change the stored procedure I use to get my data either. I receive data in the following format: 2013-01-28 4.0 …
0xFF
  • 808
  • 1
  • 12
  • 33
0
votes
1 answer

Counting Clients who meet criteria in SSRS

I've built a report in SSRS that is grouped by client. I have count by client of orders so the output would look like this: I need to create a grand total expression at the bottom of the report that counts the clients who have orders, so my total…
ryan
  • 188
  • 2
  • 7
0
votes
1 answer

Interactive Sorting in a Reporting Services report with multiple groupings and toggles

Using Reporting Services 2008 r2. In a Reporting Services report I have a table with two groupings: Group A and Group B. To show measures the Detail group is used. The Group B is set to Toggle on a value in Group A. Example: Group A is Car Makes…
user2007525
  • 1
  • 2
0
votes
1 answer

SSRS 2008 R2 "Reset" Line Chart RunningValue Across Groups

I have a stacked bar chart with a line chart overlay. The chart has 2 category groups (segment and quarter). The line chart is a RunningValue in the segment category. I need to be able to have the line chart "reset" itself across each instance of…
thomas
  • 2,592
  • 1
  • 30
  • 44
0
votes
3 answers

SSRS report when exported to Excel detail values should appear in single row

I have a table with one parent group row and a detailed row as shown in below screenshot. i got a requirement that the values come in detail row should be concatinated and show up in single row when exported to excel as shown in below…
hemanth
  • 577
  • 6
  • 17
0
votes
1 answer

SSRS: Insert Blank row after the group

I am working on a SSRS report which needs to show a blank row after every group. The group by field is "category". The values it takes are "first quarter 2010", second quarter 2010", "first quarter 2011", "second quarter 2011". I want the data in…
Satyam Singh
  • 19
  • 1
  • 5
0
votes
1 answer

SSRS Group per N distinct

I'm trying to solve a problem. As an example, let’s say I have a table containing 3 columns (Name, Timestamp, Value) with 30 unique or distinct Names and over + 1,000 rows I have created a line chart which plots Value(Y) vs. Time(X) for each Name…
user1457744
  • 1
  • 2
0
votes
1 answer

In an SSRS report, dividing the sum of one child group by the sum of another child group in a different parent group

I have a financial statement. It has detail lines divided into the groups for Sales, Cost of Goods sold, Operating Expenses, and Other Expenses. Sales and Cost Of Goods Sold are in the parent Group "IF" Operating Expenses are in the parent group…
Becky
  • 13
  • 1
  • 4
0
votes
2 answers

SSRS - Retrieve previous of first field outside selected data

I have an SQL table that contains 4 columns 1) ID 2) EquipmentID 3) Date 4) Hours e.g. 10000 I have an SSRS report that displays the contents of this table A from and to date parameter is used to select a date range of records The table is grouped…
Adam
  • 23
  • 1
  • 4
0
votes
1 answer

SSRS 2008 R2 - Group toggle aggregates

I'm working with a dataset where employee utilization is calculated as (Time Billed to X/Standard Billable hours). As such, to get the total billable percentage for an employee, I can just sum up the percentages billed to each client. However, I…
AJBCBR
  • 1
0
votes
1 answer

SSRS 2008R2 Matrix Column Group Totals

I am using a Matrix control in SSRS 2008R2 and I am trying to create totals for my column groupings. Here's a sample of my Matrix layout: January February March TOTALS 2011 2012 2011 2012 2011 …
BBK0919
  • 23
  • 2
  • 8
1 2 3
…
27
28