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

SSRS - Changing tab name when exporting to excel

I have tabbed my report in SSRS 2012 by having my page breaks based upon grouping classname and it works great. How do I change the tab names when exporting to Excel? I tried having an expression for page name =Fields!classname.Value. In doing so,…
user3798811
  • 493
  • 1
  • 4
  • 7
19
votes
6 answers

Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and each column is a field in a form for that…
AaronSieb
  • 8,106
  • 8
  • 39
  • 58
17
votes
1 answer

Trying to Add Sub Row Group inside Parent but flush left in the nested cell

What I am trying to do: I am trying to create nested groups but I want the sub row group to show directly underneath the parent, flush to the left like the parent. So in this case You'd have: Market SubMarket so results for example would…
PositiveGuy
  • 46,620
  • 110
  • 305
  • 471
16
votes
2 answers

How to sum the Group totals only?

I'm trying to sum only group HourTarget totals. 7:00 8:00 HourTarget Line 1 2715 1008 3224 A 2307 1008 3224 B 408 0 3224 Line 2 2308 2432 2656 A 2308 …
Whistler
  • 1,897
  • 4
  • 29
  • 50
15
votes
5 answers

SSRS Stop group in tablix being split across printing pages

I have a tablix in SQL REPORTS (SSRS) that has many grouped items. It fits roughly 3.5 groupped item per page when printnig, however I dont want the groups to be split up over the 2 pages, I want a pagebreak to happen whenever the group needs to be…
Michael
  • 8,229
  • 20
  • 61
  • 113
13
votes
3 answers

RowNumber for group in SSRS 2005

I have a table in a SSRS report that is displaying only a group, not the table details. I want to find out the row number for the items that are being displayed so that I can use color banding. I tried using "Rowcount(Nothing)", but instead I get…
FistOfFury
  • 6,735
  • 7
  • 49
  • 57
9
votes
4 answers

SSRS distinct lookupset function

I'm using Join(Lookupset) to find unique group values which returns a sequence number. This is my function: Join(LookupSet(Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Value , Fields!itemId.Value & Fields!UseByDate.Value &…
jhowe
  • 10,198
  • 19
  • 48
  • 66
9
votes
2 answers

Border formatting of SSRS row group

This is my report. Above row contains a parent row group and a child row group. I have done border formatting of the report . I simply right click each Text box and gives border accordingly. But, I am not able to set border for entire Group. In…
muhammad kashif
  • 2,566
  • 3
  • 26
  • 49
8
votes
1 answer

SSRS Check Filtered Group RowCount

I would like to check the RowCount of a filtered group from without the scope of the group. I particularly would like to know when the group is empty so that I can set the Hidden property on another row in the table that is not in the…
Frank Pearson
  • 872
  • 5
  • 16
8
votes
1 answer

Grouping in SSRS?

i am new to the SSRS and Have data as below RCnt Jobnumber NJCT JD pmt flag cnt1 cnt2 2 001008 0 PRESSURE SEAL PSI Y 0 0 2 2 001008 0 PRESSURE SEAL PSI Y 0 0 10 2…
user2553512
8
votes
2 answers

How to create a report with sections and page breaks using SSRS

I'm trying to create a report that looks like this: using a select from this table: (fiddler here for query and data) CREATE TABLE StudentData ( id int PRIMARY KEY IDENTITY, name varchar(30), subject varchar(30), currentGrade…
Danny Cullen
  • 1,782
  • 5
  • 30
  • 47
7
votes
5 answers

I want Datetime Parameter in DDMMYYYY Format in ssrs report

I want to change the Datetime parameter to DDMMYYYY format.its default value is MMddYYYY.when user will select date from date picker the date should be display in ddmmyyyy format. I tried all expression like =Format(Parameters!DateFrom.Value,…
Rock
  • 161
  • 2
  • 6
  • 17
7
votes
2 answers

How to display yesterdays date in SSRS expression

In one of the column name, I need to display yesterday's date like - September 4,2014 I used DateAdd("d",-1,Today()) function to display,but it is displaying like - 9/4/2014 12:00:00 AM. How can i get the above format like - monthname,dd,YYYY ?
SqlLearner
  • 763
  • 8
  • 23
  • 37
7
votes
2 answers

SSRS Repeating group headers?

I have this data DateRecived JObNumber REcCnt 20130626 1234 1 20130627 1238 11 20130628 1240 2 20130629 1242 23 I applied the group by on…
user2553512
6
votes
2 answers

How to add SSRS page break after 65536 rows, counting group header/footer

I have an SSRS report which is failing to export to excel when the row count is greater than the Excel 2003 limit of 65536 The report already has a grouping level with a group footer. I have tried to add an extra grouping level with a page break on…
JamieA
  • 1,984
  • 4
  • 27
  • 38
1
2 3
…
27 28