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 Category Grouping

I'm trying to create a grouped category on a bar chart in SSRS. My query is: select distinct filedate, transaction_date, duedate, event_instance, event_name, eventstatus (datediff(DD, duedate, filedate)+1) as DaysAged, -(DATEDIFF(WK, duedate,…
BIReportGuy
  • 799
  • 3
  • 13
  • 36
1
vote
1 answer

SSRS 2012 Show Row Group Total in Column

Is there a way to merge cells vertically so that a Row Group's Total can be shown in the column? Here is how I want my report to look: +-------+--------+--------+---------+--------------+--------------+ |Year | Half | Qty | Amount | Year Ttl…
New.Developer
  • 41
  • 4
1
vote
1 answer

SSRS: Collect Small Slices on a Pie Chart

What i want is the behaviour described here. Basically i want to group small slices into a larger one. My problem is that the link does this based on what percentage the slices represent in the pie; I want to do this based in values of the…
sergio
  • 1,026
  • 2
  • 19
  • 43
1
vote
1 answer

report services hidden details and not shows white space

I have this report when you execute this see as it But when you press on + or - this stays as it it has a ugly white space. i would like this see as it (example on Excel) so you could see details are hidden and there is not a white space when…
angel
  • 4,474
  • 12
  • 57
  • 89
1
vote
1 answer

2 weeks or fortnight per page in SSRS report

I have records for 3 weeks that needs to be displayed on an SSRS report 2 weeks per page. So my report would have 2 pages - first 2 weeks in the first page and 3rd week in the second page. How do I do this with a grouping expression?
sujith
  • 57
  • 5
1
vote
1 answer

SSRS report with column group is huge and mostly empty

I can't find a way to get this report to do what I want. My data has this form: varchar ClientName Datetime CallDate varchar CallReason I'm trying to display it in the following fashion ( "|" represent a column in the report): | Client 1…
0xFF
  • 808
  • 1
  • 12
  • 33
1
vote
1 answer

highlight value that is x% higher than preceding value (SSRS grouping)

I have a report that measures average execution per hour.I would like to higlight the hours where executiontime is x% higher then the last. So the reports now looks like this: DATE | Time | average 8-4 | 11:00 | 4,2 10:00 8-4 | 10:00 |…
Henrov
  • 1,610
  • 1
  • 24
  • 52
1
vote
1 answer

SSRS Format a multi-value field

I have a number field in my ssrs report that has multiple values separated by a comma. I want to convert the number to currency but I get an error when the field has more than on value. I'm converting the text box to currency and added the (*)…
D-ONE
  • 33
  • 6
1
vote
1 answer

SSRS expression Year and Month only from Date field

How do I build an expression in SSRS that only captures the Month and Year and not the day from a datestamp field? I am trying to create a Month To Date column in SSRS. I have a date timestamp field, I also created a Month field and a Year field…
donviti
  • 284
  • 4
  • 12
  • 27
1
vote
3 answers

How to align different Tablix in SSRS

I have a SSRS report in which i need to align multiple tablix in same Order as i need to export to EXCEL The other tablix's is just a copy of the first tablix with only change of data set.But all the tablix will have same Columns.I need to align…
SqlLearner
  • 763
  • 8
  • 23
  • 37
1
vote
1 answer

SSRS - Single page per row

Creating a report that is a display of a persons online application, so there are text boxes and multiple tables per person. I need each person to print on the same page, so a user can select either a particular application, or a date range, like…
BattlFrog
  • 3,370
  • 8
  • 56
  • 86
1
vote
0 answers

SSRS Collapsed (hidden) rows still show up when exporting

I am writing a SSRS 2005 report in BIDS 2008 which has recursive grouping and a visibility toggle. Initial toggle state is false, so all detail rows are hidden. When I view the report in the preview window, it shows up correctly, similar to…
derbal213
  • 46
  • 6
1
vote
0 answers

SSRS - Group Consecutive Rows of Same Time Spans

Related to this SQL question - Group consecutive rows of same value using time spans I want to convert this table: ╔═══════════╦════════════╦═══════════╦═══════════╦═════════╗ ║ Classroom ║ CourseName ║ Lesson ║ StartTime ║ EndTime…
Mortalus
  • 10,574
  • 11
  • 67
  • 117
1
vote
1 answer

Grouping/Formatting Data in SSRS

I am trying to show a group level data in a single column. Please find details below. I have data in database in below format: The above data can be grouped like below: How can it be done like below in SSRS (grouping in a single column). Please…
p2k
  • 2,126
  • 4
  • 23
  • 39
1
vote
1 answer

In SSRS How to make a sequential Group Column

I want to make a Sequential Group Column with the help of Matrix in SQL Server Reporting Service (SSRS), In the image above, there are Dates with Days name, Mon 24, Tue 25 and Fri 28, So I want to make it like that: Keep the sequence of Dates, no…
Sohail xIN3N
  • 2,951
  • 2
  • 30
  • 29
1 2 3
…
27 28