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
0 answers

SSRS Report Builder 3.0 Sum multiple Scopes in denominator

I have a scope issue in the summing of values to get a percentage. What I have: =Fields!UPC_COUNT.Value/Sum(Fields!UPC_COUNT.Value, "C2") What I need is something like this: =Fields!UPC_COUNT.Value/Sum(Fields!UPC_COUNT.Value, "C2" & "AREA") Any…
EPWebS25
  • 11
  • 1
1
vote
1 answer

SSRS Repeating certain groups and pages

I'm struggling with a problem in SSRS. I have created a customer invoice that is looking good in report viewer however, it needs to be set to print in a certain way. There are 4 main elements to this report. Header, this needs to repeat on every…
Easy987us
  • 21
  • 4
1
vote
0 answers

Display Group Name Value of each group in a column header outside the group

I have an SSRS 2012 table report with groups; each group is broken i.e. one group for one page, and there are multiple groups in multiple pages. 'GroupName' column has multiple values - X,Y,Z,...... I need to group 'GroupName' with X,Y,Z,..... ie…
user3812887
  • 439
  • 12
  • 33
1
vote
2 answers

MS Report Designer - What are table groups and how are they used?

I am working on a project with some existing MS Reports using Reporting Services 2000/2005 and Visual Studio 2005 with the built in Report Designer. I have come across a report that makes use of a table to display data which is fetched by a Stored…
Saajid Ismail
  • 8,029
  • 11
  • 48
  • 56
1
vote
1 answer

How to have a summarized data on the first page and the rest of the page is seperated per grouping in ssrs 2013?

I'm a newbie in SSRS. My first objective is to seperate the display of each item per group. I've done this by setting the my tablix row group properties in PageBreak -> BreakLocation to Between In result, when I exporting report to Excel, I get…
Mako
  • 33
  • 5
1
vote
2 answers

Reporting Services Sum of Inner Group in Outer Group

I have a report in Reporting Services 2008 using ASP.net 3.5 and SQL Server 2008. The report has 2 groupings and a detail row. This is the current format: Outer Group Inner Group Detail Row The Detail Row represents an item on a…
Spoonybard
  • 11
  • 2
1
vote
2 answers

How can I add an interactive sorting on expression column in Sql Server Reporting Services Report

Hi I am new to SSRS and I created a form. I also added a couple of column based on expressions. I was trying to sort the table on the basis of an expression column but the option is not available in cell properties - interactive sorting. Can anyone…
Dr. Mian
  • 3,334
  • 10
  • 45
  • 69
1
vote
2 answers

Not getting SSRS report output in desired format

I am designing SSRS 2005 report which has four subreports within a main report. The report has a group header containing "name" dataset field .Each subreport is grouped on the same "name" field.This name field is also one of the column for the…
xdev
  • 641
  • 6
  • 18
  • 38
1
vote
1 answer

SSRS report grouping (AX 2012)

I'm modifying the sales invoice report. What I want to do is to group lines by LineHeader. i.e. if invoice has 6 lines and 3 salesid, report should be like: LineHeader {2 lines below}, LineHeader {2 lines below}, LineHeader {2 lines below}. How to…
AYETY
  • 698
  • 4
  • 23
  • 38
1
vote
1 answer

SSRS Expression- Adding Totals per page

I need an expression to add a total per page in SSRS in the footer of the report. Click on link below to see screenshot. So when users run SSRS, the first page must show a total for order qty , ship qty and subtotal for the first page only. When…
SSRS_Robert
  • 11
  • 1
  • 3
1
vote
2 answers

How to repeat multiple tables in report For multiple values?

I have one report in which I have table like below, Now as for change I need to add the second table for each customer and the new report should look like as below, So basically, I want to repeat two tables for each customer there will be multiple…
Mahesh
  • 8,694
  • 2
  • 32
  • 53
1
vote
1 answer

SSRS - Column Group - Table Horizontally Expanded

There was a requirement, to have data horizontally expanded in the Rows. So I have created Child Row group in Column group of Matrix as shown in this link. Reference Link It is working fine. And it displays result as below. Requirement was : Show…
Mittal Patel
  • 808
  • 1
  • 22
  • 37
1
vote
0 answers

calculating percentage of subtotals in charts

I am working with the following dataset: stD Category Month repaired 1 1 repaired 2 1 not repaired 1 1 repaired 1 …
MVac
  • 11
  • 1
1
vote
1 answer

avoid grouping on empty values RDLC

I have a column group on a datafield. I need to group only when there is a value in the field. Right now it groups on the NULL field too. I have tried the following group expressin: =Fields!ScaleName.Value <> "" OR Fields!ScaleName.Value <>…
alicewilliam86
  • 443
  • 1
  • 8
  • 22
1
vote
0 answers

Avoid subreports in SQL Server Reporting Services by combining datasets to enhance performance

I have a free form report which is basically a company overview report. The report looks something like this: ------------ Company XYZ ------------ - address - telephone -... **Contacts** - Bryan - Caroline - Patrick **Complaints** -…
Nathan
  • 1,865
  • 4
  • 19
  • 25
1 2 3
…
27 28