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

How can I select row values that are in between "First(Fields...)" and "Last(Fields..)" that adhere to row groups?

Using SSRS 2008R2. Currently, I have a select statement that queries a few tables and returns a bunch of hierarchical data. 1 Store-> 1+ Sections -> 1+ Items The returned dataset resembles something like this(plus 20 other columns): Store_num |…
Christian
  • 503
  • 3
  • 7
  • 21
1
vote
2 answers

Double grouping + exporting in SSRS

I'm trying to create a report that allows the user to select not only a field to group by, but a second level grouping as well. To demonstrate - the records being queried are people's time sheet entries. So each record has fields such as staff…
teleute00
  • 561
  • 6
  • 25
1
vote
1 answer

insert new child group or change the order in to a list of parent-child

I would like to insert new child group or change the order in to a list of parent-child groups. Is this doable? I can add a child to the bottom of the list. But I dont know how to move the row. groups: Center Category Rollup3MgrLn …
mackjazzy
  • 48
  • 1
  • 8
1
vote
1 answer

SSRS: Calculating percent change within a Group in Report Builder

Something that seems like it should be simple, is causing me quite a headache. I have a table based off an MDX query (simple drag-and-drop from a Cube) and would like to calculate a % increase of values within a group. [It won't let me post an…
Adam Lilienthal
  • 11
  • 2
1
vote
2 answers

SSRS group total by grand total

I have a report which is grouped by location and charge_type with detail information. I would like to show the charge_type totals below the location information and right above the grand total. Current report, including totals after the city and…
Claire Douglas
  • 13
  • 1
  • 4
1
vote
2 answers

Add row number to outer group in t-sql or ssrs

I have a query that returns data with group category and some details like this: Category | Title ================== cat1 --- titlex cat1 --- titley cat2 --- titley cat3 --- titlez cat3 --- titlex cat4 --- titlex I want to display a…
Goran Obradovic
  • 8,951
  • 9
  • 50
  • 79
0
votes
1 answer

SSRS 2008 Break the column in different pages

I am creating a SSRS 2008 Report in my report i have 200 columns, it is difficult for visualizing purpose, is there any way in SSRS by which i can show 20 column per page with row hearer in each page. ex.. 1 2 3 4 5 6 7 8 …
krishna
  • 9
  • 1
  • 3
0
votes
1 answer

SSRS 2005 - How to tell when Group has changed

Is there a way to determine when a Grouping has changed in SSRS 2005? For example, if you are grouping on OrderID, displaying the Order Header info, and the details are the Order_Items etc... Is there an event to check for to tell when the "new"…
D.S.
  • 1,413
  • 2
  • 16
  • 26
0
votes
1 answer

SSRS column grouping..blank rows issue

I am trying to build a SSRS report. I need a report like this. TopGroup_Val1 SecondGroup_Val1 Deatils{Col1..Col2..Col3.........} ......................... SecondGroup_Val2 Col1..Col2..Col3......... ......................... …
crazyTechie
  • 2,517
  • 12
  • 32
  • 41
0
votes
1 answer

SSRS Grouping by value ranges: change scope when selecting value

Currently developing a report that groups items by value range. Using fictional data to describe the situation: I'm trying to get this desired output, but I cannot use aggregate functions (Sum, Avg) when grouping items. Is there any way to group…
Bas
  • 26,772
  • 8
  • 53
  • 86
0
votes
1 answer

SSRS Changing Row Colors Based on Groups?

I have a report in SSRS and I am trying to change the background color based on a group. I have 3 groups: YearMonth, Portfolio, and Name. I want to change the color of every other portfolio group. Inside each portfolio group I want all rows to be…
buzzzzjay
  • 1,140
  • 6
  • 27
  • 54
0
votes
0 answers

Using with RDLC report & grouping

I have a sql table with Monthly remarks. Each month has 2 or more than two remarks entries SQL Table name…
Maria
  • 1
  • 1
0
votes
0 answers

SSRS/Power BI Paginated Report; grouping multiple tablix in a hierarchy

I have two Tablix/tables in Report Builder, one is a Profit & Loss (P&L) and the other is Key Ratios. Both the P&L and ratios are separate datasets in Report Builder with their values being defined by DAX queries that reference Calculation Groups in…
Dax_is_Excellent
  • 1
  • 1
0
votes
0 answers

SSRS - Batch printing grouping Issue? Report seems to be randomly messing up PO Number and page numbering

I'm using MS Report Builder v15.0.19210.0. I have an SSRS report that is driving me crazy. If it is used to print a PO individually, all is well. The issue starts when the report style is used to print a batch. When used to print a batch, some of…
Erin
  • 3
  • 3
0
votes
0 answers

Is it possible to use 2 different datsets in a single Rowgrouping in SSRS?

I am using SSRS 2012 for the reports design. I have 2 different datasets which has the location details from different sql server DBs. I want to group the location from each dataset and display the value for each location. Is there any possibility…
user3737504
  • 7
  • 2
1 2 3
…
27 28