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

SSRS Border around a group fails at end of page

I would like to put a border around each entire group. I have found an expression online to help with this, but it has one flaw. When the group extends to a new page, the bottom border of the last item, and the top border for the first item on the…
Aheinlein
  • 480
  • 2
  • 7
  • 19
1
vote
5 answers

Excel Export Fail when Number of rows in the Excel sheet exceeded the limit of 65536 rows ssrs

In SSRS 2008 (I use Sql Server BIDS to create reports) how to solve "Excel Export Fail when Number of rows in the Excel sheet exceeded the limit of 65536 rows ssrs" issue Thanks
Somashekhar
  • 493
  • 1
  • 12
  • 33
1
vote
2 answers

Create multiple report rows from single row of data

I've been asked to create a report grouped by values in multiple columns on a single row from a SQL database. For example Employee Name | Type1Column1 | Type1Column2 | Type2Column1 | Type2Column2 John Doe | 0.00 | 10.00 | 20.00 …
John Kattenhorn
  • 839
  • 11
  • 25
1
vote
1 answer

How to calculate a median on a group in SSRS 2008 R2

I'm using SSRS 2008 R2 to do some reports in my project, In one of my report i want to display the median of login duration along with average total etc. and the users are grouped by region and country and I want the median of that group. I have…
sudheshna
  • 1,150
  • 1
  • 13
  • 24
1
vote
1 answer

Can not sort month-year column?

I have a date column. I created Month-Year column in my report using the following expression, but I am not able to sort month-year wise. =MonthName(Month(Fields!new_sitevisiteddateutc.Value))& "-"& Year(Fields!new_sitevisiteddateutc.Value) I would…
Ritesh
  • 401
  • 4
  • 11
  • 19
1
vote
1 answer

group by month and week in SSRS graph

I have a got a line graph report in SSRS 2008 R2. when I do the grouping in graph I first group by year, then month, then week and I get Sum(Count) as data value.(see below) Count Date Week Month Year 10 datex 26 6 2010 15 …
AnarchistGeek
  • 3,049
  • 6
  • 32
  • 47
1
vote
2 answers

SSRS Show all subtotals for each currency at bottom of report

I'd like to show the subtotals for each group at the bottom of my report, rather than inside each group. How can I do this?
Conrad Addo
  • 424
  • 1
  • 5
  • 15
1
vote
1 answer

SSRS Column Group Layout

I have a report that lists items and then the number of units and subtotal for each day. I have the report set up with a column group so that it has day as a column header and then the units and subtotal listed below (example 1 below). The user is…
hjReads
  • 39
  • 6
1
vote
1 answer

Display a 0 value if null in grouping, but only under a specific condition in SQL

I am using SSRS 2008, and have a large query I inherited with multiple sales reps as a parameter. I wanted to create a total row with groupings of total closed sales by month. In the body of the large query I used a CASE statement for creating those…
White_Homme
  • 21
  • 2
1
vote
0 answers

(SSRS v.15) How do I obtain a group's each individual totals outside of the group?

My query includes 4 groups. Category > Type > Activity > Nature > detailPrice. I have the report built with 4 different List Items stacked into each other. Each list is one of the four groups. The detailPrice is a table (pink).Each of the 4 groups…
snowyphoenix
  • 7
  • 1
1
vote
1 answer

SSRS Report Fails, How do you determine root cause?

I have a report that essentially is a purchase order. It contains multiple tablixs and about 4-5 shared datasets. For some reason when I attempt to load a PO for specific purchase orders the report goes into a loop and just sits there while the…
Brent Pabst
  • 1,156
  • 1
  • 15
  • 37
1
vote
2 answers

List report, filter by letter

I am building a summary report which looks at users that are marked in a database as having a common trait i.e return all users by name in the last 5 years whose contract contains an end date. This generates a figure e.g. [250] I drill through on…
Nic
  • 11
  • 1
1
vote
2 answers

SSRS-Problem in Comparing rows under a group and show it Matched or Unmatched

I have data looks like below, and am grouping at Column1. I need to compare column2 with in Group and highlight if the values for column2 is same or different in Column3- Column1 Column2 Column3 123 111 123 111 1234 2222 1234 …
Janny
  • 25
  • 7
1
vote
1 answer

Sum the grouping total individually for Report items

I have a report item which is based on a calculation from 2 different entities. I am trying to group the report based on the product number.But I am not able to get the total for each group. But found a way to get the grand total from the report…
VJ4407
  • 29
  • 5
1
vote
1 answer

How do I implement optional grouping in SSRS 2008?

I have a report table in SSRS 2005. It looks like this: Group Header Row Group Detail Rows Group Footer Row The groups are displayed based on a report parameter called GroupBy. If this parameter is null, then there is no grouping. So, the…
bunkscene
  • 69
  • 8
1 2 3
…
27 28