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

ssrs with custom rows in Matrix

I have this raw data: In the data the "Act" is actual number, "Fct" are forecasted, and I have to create a row called "Var" to calculate (Act-Fct). The "Cum" is the accumulated variance. The "Prev" refers to the previous year data and the"VarYOY"…
maverick07281975
  • 53
  • 2
  • 10
0
votes
1 answer

How to filter on a group field in a tablix?

I have a tablix in SSRS 2008 R2 which I mean to only display when field value tablix_flag = 2. My dataset looks like: tablix_flag ACA_N_ACO_Link2 Details3 1 CA9CEE16-84FE-418E-933F-33208185A294 C 1 …
salvationishere
  • 3,461
  • 29
  • 104
  • 143
0
votes
0 answers

Filter issues with Adjacent Groups

I am building a report in SSRS. I have a return set like something below: store, name, filter, data 1 Hol 1 1.5 2 Nam 2 3.5 3 Hol 3 1.5 2 Nam 3 3.5 Now the issue is I have a table with 3 adjacent…
user2584086
  • 1
  • 1
0
votes
1 answer

ssrs master detail report

I'm fairly new to SSRS and I can't seem to find an example of a master detail report. I'm trying to create a report which has matrix control which has all the data from query 1, now I want to have it where if the user clicks on a column it displays…
vince anon
  • 73
  • 1
  • 8
0
votes
2 answers

Sorting on Group in SSRS Report

I have report that based on the Createdon date group and its amount on that.so I have created group on createdon in SSRS Report and also put sorting based on createdon date.The data is like this Date Total Amount 6-22-2013 …
Kartik Patel
  • 9,303
  • 12
  • 33
  • 53
0
votes
1 answer

Grouping and Total on one Column Values

I have this group in a table. Where I need to display one value on the top and rest according to its alphabetical order. Table Column1 Value#1 Value#2 Alpha 12 26 Beta 65 745 Gamma 987 …
snp.it
  • 512
  • 2
  • 10
  • 30
0
votes
1 answer

Page headers on SSRS subreports in grouped table

I have a multiple page report. It takes 3 parameters: start date, end date, and job number. They have requested the ability to run this report for all jobs or multiple jobs at a time. I created a second report and made the job number parameter…
RememberME
  • 2,092
  • 4
  • 37
  • 62
0
votes
1 answer

SSRS Top N and Bottom N filter tie-breaker

I have an SSRS report with groups that filter by TOP 3 and BOTTOM 3. In one set of data, I have a 16 way tie for bottom 3. I want to set a "tie-breaker", so if it's not a tie, filter bottom 3 based on my original condition, but if there is a tie…
RememberME
  • 2,092
  • 4
  • 37
  • 62
0
votes
1 answer

SSRS - Replace the Chart

I have a question, want some assistance. Q) My question is that i have a chart in which analyst assigned for many incidents and some analyst have 1 or two incident assigned. just because of this the bar chart looks ugly some time. So thats why i…
ahsan
  • 95
  • 6
  • 13
0
votes
1 answer

SQL Server Reporting Services 3.0 - default sort by count

Creating dashboard of list of computers with ad - sccm details. In reporting services 3.0 I have a table like this from a much bigger data set. OSName1 | OSName2 | OSName3 (count computers) | (count computers) | (count…
user2471508
  • 1
  • 1
0
votes
1 answer

Exclude field value from Total Grouping issue

in my report there is 3 parts: Placement from a dataset Processed from another dataset Unprocessed is the difference between Placement and Processed. The report is working fine and the grouping is perfect. However i want only when the Type is…
Georges Sabbagh
  • 259
  • 3
  • 12
  • 27
0
votes
1 answer

Matrix report - Page breaks for each column group

I'm using VS2005 to create my reports. I have a matrix report that works beatifully. I have country going down on the left hand side (row group called "matrix1_country_name") and data going across for 2 column groups, product_node and month (column…
Ryan Ward
  • 1,523
  • 4
  • 15
  • 23
0
votes
0 answers

Webservice Report Export ReportExecution2005.asmx 404 Not Found

I am trying to connect to a SSRS Server 2008 r2 to access the webservice. http://srsserver/reportserver/ReportExecution2005.asmx But whenever I tried to connect to the URL I get a 404 error. I have logged onto the server the file exists of the…
Micah Armantrout
  • 6,781
  • 4
  • 40
  • 66
0
votes
1 answer

Always Expand groups on export/print of an rdlc report SSRS(even if user has explicitly collapsed the group)

I am facing a problem in creation of an rdlc ssrs report. Scenario is as follows: The report has Expand all/Collapse all radiobutton option to toggle a group's visibility. Report should always be in expanded state if exported to pdf,word etc or…
user2210524
  • 1
  • 2
0
votes
1 answer

Create Sql Server Reporting Service using subreport to repeat records

i am creating a Sql Server Reporting. I want pick one row from one dataset and all details regarding this row under it. Like Department name Dot-Net is on header and its employee details under it.Then Department PHP and all PHP employee below…
Bharat Bhushan
  • 115
  • 3
  • 16
1 2 3
…
27 28