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
3
votes
1 answer

How to create more than one group in List , SSRS 2005?

I am using a List in one of my reports. It has a detail grouping on a field, and controls like subreports. Now my requirements changed a bit and I need to have an outer group around the existing one, and a page break on the outer group. How do i do…
san
3
votes
1 answer

Using an Expression for Border Style in a Tablix in SSRS report

I have an interesting dilemma with an SSRS report that the powers that be have decided needs some extra styling. I basically have a column group that I need to have a bold border around. In the picture below, I need to have the lines I've drawn in…
timmyda
  • 65
  • 2
  • 12
3
votes
1 answer

Sorting in SSRS Reports overriding Group sorting

I am new to SSRS (2005) and am creating my first report. I need to create a group-based running value but is sorted or some other field. For example, from the data below |Employee| Day |Hours|Salary| |E1 | 1.1 | 5 | 5 | |E2 | 1.2 | 6…
Siva
  • 97
  • 1
  • 5
3
votes
2 answers

SSRS combine multiple datasets into one graph

I've been looking around online for a way to fully combine datasets in SSRS (2008 R2). Basically, I need to create a single table and graph composed of a number of different datasets (all with the same columns as below) which are retrieved from…
Super Nova
  • 81
  • 1
  • 4
  • 8
2
votes
1 answer

Repeating tablix header on each page, but want to change heading on repeated rows second page

I have an SSRS report with a simple tablix control where (using advanced mode for row groups / column groups) I've set one of the rows to repeat on each page. I was hoping that when a heading is repeated on a new page I could use an expression to…
Michael A
  • 9,480
  • 22
  • 70
  • 114
2
votes
1 answer

Aggregate not populating chart correctly in SSRS

Below, I've attached a sample of my data as well as a sample of the chart output. I want to aggregate the data and include one row with this number; however, SSRS is just showing multiple of the same value. In the example below, you'll notice…
Tom
  • 2,180
  • 7
  • 30
  • 48
2
votes
1 answer

SSRS : How to "not have" a footer after first page?

I need to display a piece of information on the very first page of my report. This piece of information has to be at the very bottom of the report (why I choosed a footer). It will have a height of approx 3 inches, which is considerate. I want the…
Dominic Goulet
  • 7,983
  • 7
  • 28
  • 56
2
votes
1 answer

SSRS: Setting the bottom border based on the grouping

I would like to apply a bottom border to my report based on the first group I have 3 groups: Parent: Region Child 1: City Child 2: Area I want the border applied to the bottom on the last row of the group, based on the parent group: Region. I am…
temitaio
  • 131
  • 2
  • 6
2
votes
1 answer

How to force to show beginning of the week in ssrs report

When the client select start date ,end date and group by : weekly is there any way to force to show in the week column as first day of the week. For example if I choose 10/1/2019 as start date and 10/2/2019 as end date and group by : weekly then…
Ronney
  • 25
  • 3
2
votes
1 answer

Group days by week sql server / ssrs

I'm going to rephrase a question that I prevously had asked. I want to group dates by week. I currently have two functions: The first of which returns all fiscal weeks of the year and the second all the dates. I do a left outer join on the Fiscal…
Node17
  • 537
  • 1
  • 8
  • 22
2
votes
1 answer

How to summarize values of all first rows of sub-groups in a group while using MS SSRS?

In our DB, we have: (x means don't care) GID UID COST ================================ A 1 100 A 1 x A 2 200 A 2 x B 3 330 B 3 x And the customer report required to look like: UID …
William X
  • 6,751
  • 6
  • 31
  • 50
2
votes
1 answer

How to display previous business day using ssrs expression

I have a requirement in ssrs report to display previous business day date in expression.I am using the below sql in sql server to display date DATEADD(DAY, CASE DATENAME(WEEKDAY, GETDATE()) WHEN 'Sunday' THEN -2 …
SqlLearner
  • 763
  • 8
  • 23
  • 37
2
votes
1 answer

SSRS: Group Totals need to be displayed together

I've a report which is Grouped by Book ABC and then grouped by State to display the total of Qty. Is it possible to display the Group totals all together at the bottom of the report ? Something like below: Here is my Report Design: It is a table…
Tess
  • 43
  • 1
  • 1
  • 6
2
votes
3 answers

Pass field from one dataset to another dataset as parameter In SSRS 2008 R2

I have a scenario where one of my data-set returns multiple records. Now I have implemented grouping in my report so as to display each record from this data set on a different page. Now I have an another dataset which loads some data using fields…
Hitesh Gupta
  • 147
  • 1
  • 3
  • 10
2
votes
2 answers

How to hide parameter based on another parameter value in SSRS

I have 2 parameters param1 and param2. param1 has values true and false. My requirement is that if I select true in param1 then param2 should be hidden and if I select false in param1 then param2 should be visible. Can this be achieved in SSRS?
SqlLearner
  • 763
  • 8
  • 23
  • 37
1 2 3
…
27 28