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

Create a Header Row in SSRS

I am trying to create a header row for a matrix in my SSRS report. Currently my matrix is configured as the following: If I right+click to add a new row, it will insert a row above but I cannot merge the entire row of cells to form a single row,…
MISNole
  • 992
  • 1
  • 22
  • 48
3
votes
2 answers

Add "COUNT" column in SSRS in place of details rows

Apologies for this very newb-like question. I have some detail data that I want to group... I have added three group by columns (LOB, Event Classification, Assigned) to my table and want to add a third (Count) that counts the number of rows in the…
ProfNimrod
  • 4,142
  • 2
  • 35
  • 54
3
votes
3 answers

SSRS page break after row with subreport (in rectangle)

I've spend hours searching for a solution for something 'simple'. I have a report (SSRS 2008 R2) with a tablix with rows grouped on saleslineid. For each salesline I want to show a sub-report with specs and after that the components of the…
Mike Dole
  • 675
  • 2
  • 14
  • 30
3
votes
1 answer

To draw horizontal line in tablix region

I am using SSRS 2005(MS-BIDS 2005) to design reports.For designing one of the table i have a requirement to draw a horizontal lines above and below group headers and footers as shown in the image below When i try to drag and drop a line from the…
xdev
  • 641
  • 6
  • 18
  • 38
3
votes
2 answers

ADD Total is Greyed Out In SSRS Tablix

I am trying to add Totals to at the end for many columns,but when i right click on the box Add Total is Greyed out,How can i enable ADD Totals? thanks in advance
SqlLearner
  • 763
  • 8
  • 23
  • 37
3
votes
1 answer

SSRS Group by in the List Report

I am working on a SSRS Report where i have to group by the Customer Name. Dataset will be something like this. Select Column1, Column2,Column2 from Customer Group by CustomerName Expected Report Layout Customer Name : Jim Mouse DOB : …
goofyui
  • 3,362
  • 20
  • 72
  • 128
3
votes
0 answers

SSRS Matrix Page Break of Column Groups

I am currently working with SSRS 2012 and have apparently hit a road block. Is it possible to set a page break on each new instance of of a column group variable. I have given a basic example below. I have selected the page break across group…
mich_1706
  • 247
  • 4
  • 14
3
votes
5 answers

Calculating grand totals from group totals in Reporting Services

I have some data grouped in a table by a certain criteria, and for each group it is computed an average —well, the real case is a bit more tricky— of the values from each of the detail rows that belong to that group. This average is shown in each…
Auron
  • 13,626
  • 15
  • 47
  • 54
3
votes
2 answers

SSRS display 2 different details

I'm trying to create an ssrs report where the parent grouping has 2 different sets of details, I can't seem to figure out how to display the unique details below the parent row example: table1 master master1 master2 table2 master, hand master1,…
user3014803
  • 33
  • 4
3
votes
1 answer

How to show data in column in SSRS

I'm using SSRS for my reporting, my reporting solution is in Visual Studio 2008 Business Intelligence Development Studio. I have a report in which the data should be displayed in this format. I have added a Column Group in my table which is having…
Sam M
  • 1,077
  • 2
  • 20
  • 42
3
votes
3 answers

How to apply parent group for multiple datasets in SSRS VS2008

I have been battling this issue for days without success. I have a very tricky format of a report i need to achieve but the main thing is that all the datasets will need to be grouped by 1 parent. I'll attempt to explain... Say we have dataset1,…
user1732364
  • 925
  • 4
  • 28
  • 58
3
votes
2 answers

SQL Server Reporting Services: Cell Value Not Repeating when using table/matrix wizard

I have a dataset which shows a worker’s scores on various skills using four test types along with their supervisor and the director above the supervisor. To save space, the dataset example below is for just one worker. This is what I start…
user2270911
  • 195
  • 1
  • 5
  • 18
3
votes
1 answer

SSRS report with multiple child tables

So I am working on an Invoicing Report in SSRS 2008. The database contains 4 relevant tables: - Work Order - Labor - Materials - Services (Subcontractors) Obviously the work order table contains all the relevant information about the overall work…
D.R.
  • 1,199
  • 5
  • 19
  • 42
3
votes
2 answers

SSRS - Count grouped by Column AND Row in a Tablix

I have an SSRS tablix similar to this: +----------+-----------+--------+--------+ | Total | RowGroup | Group1 | Group2 | +----------+-----------+--------+--------+ | Perdiod1 | RowGroup1 | Value | Value | | | RowGroup2 | Value |…
tomsky
  • 535
  • 4
  • 11
  • 28
3
votes
1 answer

SSRS 2008 - Multiple Groupings For Date Range

A record in a table contains a range of valid dates, say: *tbl1.start_date* and *tbl1.end_date*. So to ensure I get all records that are valid for a specific date range, the selection logic is: <...> WHERE end_date >= @dtFrom AND start_date < @dtTo…
krysolov
  • 31
  • 1
1 2
3
…
27 28