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

How to display XML data extracted from db server to SSRS

I am writing a simple report in Reporting Services that displays data extracted from a single table. One of the table columns contains XML data, which I want to pass to the sub-report as a parameter. This sub report should render the values in…
desi
  • 466
  • 1
  • 4
  • 22
-1
votes
1 answer

SSRS column group displays data on unique rows

I have a data set where i'm using a table to display Name, Radio #, and Unit # information in SSRS tablix. As some of the groups have 60+ members, i thought it would be better to expand the tables into 4 columns repeating those detail fields instead…
A-aron
  • 1
  • 1
-1
votes
1 answer

Creating totals result from a calculated column. SQL Server 2016

I am trying to create 1 total for my "calcColumn". I am calculating new values based off of column 4 and resultLimit column. I cannot seem to get any grouping or rollups to work, I did not include them because it was a mess and likely VERY wrong.…
user3643304
  • 1
  • 3
-1
votes
3 answers

SSRS Count Record Based on Field Value (Status) in a Group

I have the data table below: --> Click here for the picture. I want to add new column and count how times an employee is present in the office something like this: --> Click here for the picture. How can I count it in expression given that I have…
dalday
  • 31
  • 1
  • 6
-1
votes
1 answer

Percentage by Row Group

I have a matrix with rows grouped by Dept (Department). I am trying to get the actual hours / required hours percentage in a column for each row group, but I can only get the total %, not the % by group. Ex: I should get this: Total Employee…
AlanL
  • 1
  • 1
-1
votes
1 answer

large data on chart SSRS

I am creating a report that shows client ticket status on a Chart control in SSRS. The problem is, when the number of clients are less, data fits perfectly on the chart but when the number of client records exceeds 20, chart tries to fit everything…
Nav
  • 1
  • 1
-2
votes
1 answer

SSRS 2008 - grouping sets?

If I have a list object which groups a tablix according to a country value in my dataset, is it possible to add my own custom combinations? E.g. If I have UK, France, Germany, US, Japan boxes, and then one for EU which puts UK France and Germany in…
Paul M
  • 1
1 2 3
…
27
28