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

Graphing a single row in an SSRS Line Graph

I have a table setup with the following columns: Product Name SalesMonth1 SalesMonth2 SalesMonth3 SalesMonth4 SalesMonth5 An example of a row is as follows: Bread 300 600 800 900 1000 I am trying to put this into a line graph in SSRS but am having…
Jeff
  • 427
  • 1
  • 14
  • 31
0
votes
1 answer

Sorting Group on the summation of two values

I have a field (PharmacyTotal) in my report that takes the SUM of a field called Price: [Sum(Price)] I then have another field(LabTotal) that takes the sum of a LookUpSet like this: =Code.SumLookup(LookupSet(Fields!Patient_Name.Value,…
etm124
  • 2,100
  • 4
  • 41
  • 77
0
votes
1 answer

how to partition a sql query result table in particular set of rows in SSRS

consider a scenario.. for my query select A.Name, B.Time, C.Class from A left join B on B.b = A.b left join C on C.c = B.c derives the following result.. ***************************************************** Name Time …
Dee Law
  • 78
  • 1
  • 6
0
votes
1 answer

Grouping data based on expression using CountDistinct aggregate function

I am newbie to Stack overflow and also SQL server reporting services. So please excuse me for the format of the question. So here is the situation: I am developing a SSRS report which needs to be grouped by an Count of Distinct product names as…
lvars
  • 77
  • 1
  • 10
0
votes
1 answer

SSRS - display some data once and other records need to display all

i have a report i am creating, the data looks like this in the database: MF5059DD PEPPERED EGG 192 / 1.9 OZ 2014-03-08 3 0 84.0000 MF5059DD PEPPERED EGG 192 / 1.9 OZ 2014-03-10 3 0 -6.0000 MF5059DD PEPPERED EGG 192 / 1.9 OZ …
user2296802
  • 27
  • 1
  • 1
  • 5
0
votes
2 answers

SSRS Calculating Totals

In SSRS I have a report generated from a stored procedure. I have one column that is named "Price" and the report has various groupings (shown below). So because there are so many groupings there are a lot of totals for price. I need to roll these…
Mickey Sly
  • 429
  • 2
  • 6
  • 21
0
votes
1 answer

SSRS Group by in the Report Header

I am working on a simple SSRS Report. Report Header : AccountName Report Sub Header : Group By CustomerName, Address In the Detail, I need Column1,Column2,Column3 I am able to show the Detail section in a Table Format. I am not able to set the…
goofyui
  • 3,362
  • 20
  • 72
  • 128
0
votes
1 answer

SSRS report error-Object disconnected

I have an SSRS report which uses 4 datasets retrieving appox 1000 records each. These records are presented in SSRS using grouping (row wise / column wise) to generate group counts and perecentages. There are 4 such tables. The procedures used to…
Richa
  • 407
  • 1
  • 10
  • 22
0
votes
1 answer

Add an Individual Field to Every Page of an SSRS Report

Goal I'd like to be able to add an individual field (or multiple fields) to an SSRS report outside of a tablix. Basically, per the example in the screenshot below, I'm attempting to create an invoice template wherein a page would be generated for…
Jason H.
  • 445
  • 1
  • 5
  • 10
0
votes
1 answer

SSRS footer data based on groups

I have this report which has a group based on a field "DeliveryNumber". It works fine, after every new DeliveryNumber the report shows new data. But now I want to do the same with the page footer. On every group the footer should show data belonging…
Serve Laurijssen
  • 9,266
  • 5
  • 45
  • 98
0
votes
1 answer

Column Visibility Based on each group SSRS 2008

![enter image description here][1]I am trying to achieve column visibility based on group name. As you will see in my picture that I have displayed data based on my group name which are leakcheck, evac, pressure. I have used code below in advanced…
user3348975
  • 1
  • 2
0
votes
1 answer

SSRS & Parent-Child hierarchy & parent does not exists within it's own tree

I have an SSRS report that pulls data from a cube and shows expense items and cost values. Im using a parent-child hierarchy to show the expense items relationship and roll-up costs as well. I need to show a parent expense item within it's self to…
Brandon Michael Hunter
  • 1,179
  • 3
  • 20
  • 48
0
votes
1 answer

ssrs 2008 : Do not want group header to appear for every group

I need to generate SSRS report as shown in the above picture (the top portion of the image got cut off but it has the header as shown below which should appear on only at top of each page). HEADER is as below Bin ItemNr Description QtyOnHand My…
Anirudh
  • 581
  • 5
  • 14
  • 32
0
votes
1 answer

ssrs column grouping based on a query field

I have a matrix in my report. The columns of the matrix will be based on the "Code" column in my query. The different values of Code are A, B, C, D, E, F I want 3 columns in my matrix: if the Code is in (A,B) then data will be shown in a single…
JamDakh
  • 113
  • 2
  • 3
  • 5
0
votes
1 answer

How to show columns data in Reportview bar charts

I need to show the data from a SQL query as shown below on bar chart by using SQL Reporting bar chart Where I have to show the chart like this
Dev Developer
  • 163
  • 1
  • 8
1 2 3
…
27 28