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

Conditional PageBreak on a group in SSRS 2008

I am working on a report in which there is a need of conditional pageBreak on a group. I have tried to set the disabled property of PageBreak(of the group) but it's not working out for me. The disabled property is not working either i set it to true…
ashish virmani
  • 21
  • 1
  • 3
0
votes
1 answer

SSRS , 2 datasets with a common Key ID using a List and Table

I want to have a List of a specific entity with 2 table in it using 2 differents DataSet. Is there any way to embed 2 table in a list? It seem to not be possible. DataSet 1 LocationID (PKEY) Name Address DataSet 2 LocationID (PKEY) …
Jean-Francois
  • 1,899
  • 4
  • 35
  • 73
0
votes
0 answers

How to prepare recursive reports based on a field value?

I am preparing a SSRS report where a table in the body has to be generated by considering a field value in header part and should repeat the same for all values of that field. I have created a group in body and used the expression…
Raj44
  • 449
  • 1
  • 4
  • 10
0
votes
0 answers

SSRS Indent Toggle Icon

I'm using Visual Studio to create reports. Very new to this. I'm trying to indent the plus/minus toggle button with the grouping so it'll be in line with the group text. I'm using the following in the Left Padding Expression but it isn't working…
Nick
  • 1
  • 1
0
votes
1 answer

SSRS Anchor Report to centre of screen

Morning Everyone, Can some please confirm if it is at all possible to anchor sections of your report to parts of the screen alike you can within C# Winforms? I would liketo anchor logos to the top left, tables to the middle ect.. but at the moment I…
user3707945
  • 45
  • 1
  • 7
0
votes
1 answer

SSRS Getting Column Names from CTE in the Fields of a Dataset

I am running a query in SSRS that is using 2 common table expressions. The query runs fine in the query designer, but the when I press ok and the dataset is formed; the fields in the dataset are the columns in the select * statement inside the cte.…
ENGR024
  • 307
  • 1
  • 13
  • 33
0
votes
1 answer

Remove header borders in Tablix

What I really want to do is merge column headers vertically, but that doesn't appear possible in SSRS. One work around presented in the quest SSRS tablix Merging cells vertically problem was to just remove the header borders. However, when I remove…
KyleMit
  • 30,350
  • 66
  • 462
  • 664
0
votes
1 answer

Add Sub Row Group inside Parent Group

I've already made this table below (I've made Groups column as parent group and the Status Column as Child group), what I need to add now, is to put the Status (column2) inside the Group (Column1): It want it to look like this ! Can somebody…
tollamie
  • 117
  • 1
  • 6
  • 20
0
votes
0 answers

SSRS Report Generator

I have a problem on how to output this one on ssrs. I want to output something like this: item1 item1.1 item1.1.1 item2 itme2.1 item2.1.2 item2.1.2.1 item2.1.2.2 item2.1.2.3 item2.1.3 Can I accomplish something like this…
user3312649
  • 190
  • 1
  • 4
  • 17
0
votes
1 answer

How to hide the parent table cell/row if child is hidden or having no data

I have table (t1) which is binded with some dataset. One of the row of this table is having another table (t2). so t2 is a child of t1. I want to hide row of t1 if there is no data in t2. I tried setting the visibility expression of t2 as…
Atul Sureka
  • 3,085
  • 7
  • 39
  • 64
0
votes
2 answers

SSRS 2008 R2 Subtracting current row from previous row where data is summed

I am fairly new to SSRS 2008 R2. Trying to convert my reports from Crystal. Thought this would be a simple task but this ended up being a pain. I have a table that is grouped by Year then Week_Number so the table looks this when run: (I am trying to…
Mike
  • 713
  • 6
  • 20
  • 41
0
votes
1 answer

SSRS Show a percentage of a a total value

I have a regular Table in SSRS. With 3 Groups... (Parent) STORE - CLERK - PRODUCT (Child) I have some regular aggregations. How many PRODUCTS Sold by a CLERK , How Many CLERKS Per STORE and Eventually How many PRODUCTS Per STORE On top of…
Azberg
  • 1
0
votes
2 answers

SSRS Print one row then detail

I have a report that has two sections of data. In a list component with textboxes I have Barcode, warehouse location, pallets. Then below this I have detail information in a tablix including Racklocation Use by date, Qty, Product, Description,…
jhowe
  • 10,198
  • 19
  • 48
  • 66
0
votes
1 answer

Where to Aggregate Using Microsoft Reporting Services?

I'm working on my first SSRS report and I haven't been able to find general guidelines as to how to create reports. Specifically, I would like to know what the general approach is when aggregate data is needed on a report. For example, let's say I…
Bruno
  • 533
  • 1
  • 6
  • 27
0
votes
1 answer

Grouping In RDLC/SSRS reports

I am new to SSRS/RDLC reports and I have to create a report . I have two data sets and in the two sets i have an year field I have to group it by year . First dataset 1 should come based on year after that dataset2 should come according to…
Abin T Abraham
  • 3
  • 2
1 2 3
…
27 28