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

SSRS - Getting this error: Numeric aggregate function on data that is not numeric

I have a report that is giving me grief about this statement: Format((Sum(Fields!Mean.Value)) / RowNumber("category_desc"), "F2") The mean field is a calculated field that is the sum of five fields in my table. Category_desc is the group. When I…
Michael Robinson
  • 1,106
  • 3
  • 13
  • 40
1
vote
1 answer

Index out of range error on 2012 SSRS Report (converted from 2005 rdl)

I have upgraded a rdl file from 2005 to 2012 using visual studio 2012 ultimate and I am getting an error that I did not receive in the 2005 version. The error is: Index was out of range. Must be non-negative and less than the size of the collection.…
bsivel
  • 2,821
  • 5
  • 25
  • 32
1
vote
1 answer

SSRS count rows grouping on data

I have an existing SSRS report that shows some overall counts on the top of the report. The report data looks like: column1 column2 A1 true - true B5 false A1 true - false C3 false What I need…
Blaze
  • 1,863
  • 7
  • 23
  • 40
1
vote
1 answer

how to write the current month Dynamically in SSRS

I have Column which has the label "JUL-CurrentMonth Fiscal Year To-Date" How can i write the expression in which Current month should be populated Dynamically in the label? I was trying this "July-" &month(today) " Fiscal Year To-Date" but it is…
SqlLearner
  • 763
  • 8
  • 23
  • 37
1
vote
1 answer

Font color for percentage Fields in SSRS

Hi I Have a requirment that if the the percentage is >100 then I need green else black. So i have used the expression = iif((fields!JulyRev.Value/Fields!JulyValue.Value) > 100, "SeaGreen","Black") But The above is not giving any green font if the…
SqlLearner
  • 763
  • 8
  • 23
  • 37
1
vote
1 answer

How can i change the background color and font color for a particular condition for multiple columns at a time in SSRS

I have a Tablix which has around 50 columns,I need to change the color of the font, if the value in the columns are less than 0.Is it possible to write the expression at one time rather than writing the expression for every column individually?
SqlLearner
  • 763
  • 8
  • 23
  • 37
1
vote
1 answer

ssrs 2008 passing parameter value incorrectly

In an SSRS 2008 R2 existing report, I am passing a new parameter called 'SchoolYear' to an existing report. I obtain the value for SchoolYear from the following statement =(Fields!SchoolYear.Value) that is used against the dataset DS_Main. I am…
user1816979
  • 511
  • 4
  • 13
  • 25
1
vote
2 answers

SSRS 2005 unwanted page breaks between subreports

I have a report that has one table with two rows. The first row is just a header, the second is a subreport. The subreport consists of a single table. I want to pass one parameter into the subreport (Fields!patient_id.Value) and have the subreport…
Justin C
  • 786
  • 8
  • 17
1
vote
1 answer

Comparing value to another value when using grouping

I'm not even sure if it's possible to do this, as SSRS has alot of limitations. Suppose I have two entries in my SQL Table: Name: John Doe Value: 20 Month: January 2014 Name: John Doe Value: 30 Month: February 2014 I'm trying to do some…
George
  • 123
  • 1
  • 1
  • 8
1
vote
2 answers

SSRS Chart in tablix with Column Break

I wanted to create a multicolumn report with paging. For complexity I have Gauge control in first row and Chart control in second row. I have data from table like this MetricID | ColumnNo | RowNo    1         |    1            |    1             2…
Kiran Ramchandra Parab
  • 486
  • 6
  • 23
1
vote
1 answer

Hide a column of a specific Row-Grouped Table in RDLC

I have a matrix which contains a rowgroup and groups my products based on the Category. I have three categories: Laptops, Tablets, Televisions. My first two categories contain columns i.e. RAM which I don't want to display for the Televisions. Each…
alwaysVBNET
  • 3,150
  • 8
  • 32
  • 65
1
vote
2 answers

How to align each string in text in field column of ssrs

I have a field like this in the column field in ssrs. QUINIDINEssssssssssssssssssssssssssssssssssssssssssssssssssssss GL INJ 80MG/ML FLECAINIDEssssssssssssssssssssssssssssssssss TAB 50MG TAMBOCORsssssssssssssssssssssssssssssssssssssssssssss TAB…
soundarrajan
  • 149
  • 1
  • 3
  • 13
1
vote
0 answers

SSRS Hide Column Based on Drill Down Level

I have a ssrs reports with 3 row groups and 2 columns. e.g. Continent > Country > City | Sales | Tax The user drills down from Continent to Country to City. They can always see Sales and Tax. i want to hide the tax column when the user drills down…
user1786107
  • 2,921
  • 5
  • 24
  • 35
1
vote
1 answer

SSRS R2- compare single values in multi value parameters

I've got a multi value parameter that pulls available country codes to filter my table on. if I make it single value, no problem - @country default value to "US", and there are about 15 other countries to choose from - whichever one you pick, only…
nbpeth
  • 2,967
  • 4
  • 24
  • 34
1
vote
1 answer

SSRS display group value under group header

I have the following data in my table: GroupID | StaffName ------------------- G1 | Alex G1 | James G2 | William Then I want to Group them by GroupID. I have try using "Add Group -> Adjacent Before". But the result as…
Howard Hee
  • 909
  • 1
  • 13
  • 29
1 2 3
…
27 28