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

SSRS Row Grouping help needed please

I'm guessing this is very simple but I am missing something and need help please. My dataset looks like: CITY STREET HOUSES Norton Main St 10 Newton Main St 30 Providence Angel St 15 Boston State St …
Jay
  • 455
  • 3
  • 17
  • 34
0
votes
1 answer

Column visibility based on 2 parameters in SSRS

I have a parameter 'Section' which has values A,B,C and another parameter 'Field' which has values X,Y,Z. now my requirement is i need to make column visibility based on both the parameters,if my parameter 'section' is A and parameter 'field' is X…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

How can I display 'NA' for blank values of Datetime datatype in SSRS

I have a field 'Clockin' which will display the Date and Time,Now i have some blank values in it.how can make blank values to 'NA'?
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
0 answers

How can i show drill down records in SSRS email subscription

I have a report which has drill down option ,when i subscribe that report to my email,i am unable to see the drill down records.Do i need to change any settings in order to display the drill down ? thanks in advance
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

How do i remove empty excel sheet while exporting the report in SSRS 2008R2?

I have one issue with SSRS reports. i ll export the report with excel format. but unfartunatily excel page break empty sheet will created. how do i remove that empty excel sheet from SSRS 2008R2.EX: sheet1 contain data and sheet2 not contain data…
Parthiban R
  • 1
0
votes
0 answers

How can I calculate YTD values in report?

My client has a standard report which shows monthly figures for various sales, enquiries etc. The report shows all months since the start of the contract (about three years ago, but growing by 1 every month!). The last row in the Tablix shows the…
Edwardo
  • 872
  • 1
  • 11
  • 24
0
votes
2 answers

How to set multivalued parameter to Select All when given specific values to the parameter in SSRS

Hi I have a multivalued parameter 'location' in which i am specifying values in parameter like 'Dallas','Chicago','Seattle'.how can i set the default value to 'Select ALL' I know how to make if values are from query,but how can i make all of them…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

How to cascade parameters in SSRS having specific values

I have 2 parameters 'Groupby1' and 'Groupby2' in my report,for the first parameters i have specified some values like Column A,column B,Column C. Now i need to make the 2nd parameter cascading based on the first one like if i select Column A in…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

SSRS Previous Function not calculating first time around

I have a report that I built in SSRS that calculates a sum of numbers for every business day going back 10 business days. There is a column group for each business day, and there are row groups for each item being totaled. The function to…
BigDevJames
  • 2,650
  • 5
  • 21
  • 36
0
votes
1 answer

How to write the following sql function in SSRS expression

Is there any equal function to datepart(dw,getdate()) in SSRS expression which gives me the week number of a particular day ie for monday it should be 2 . Thanks in adavance
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

The added or subtracted value results in an un-representable datetime

I have the following expression to check parameter date values and replace from date if necessary: =IIF(Parameters!FromDate.Value is nothing, IIF(Parameters!ToDate.Value is nothing, DateAdd("d",-30,Now()), …
Leila
  • 232
  • 6
  • 15
0
votes
1 answer

SSRS Matrix column group percentage

this is the table Provider ID flag A 1 N A 2 N A 3 D B 4 D B 5 D B 6 N this is the matrix in ssrs Flag Provider N D Percentage A …
fairy
  • 3
  • 2
0
votes
2 answers

How to sort horizontal axis labels in a SSRS chart

I have a bar chart as below the horizontal axis has months and years,is there any way i can sort the months order? like January,february,March... thanks in advance
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
1 answer

Grouping data in a SSRS report

In developing an SSRS 2008 R2 report, I'll like to show some data grouped by values, while merging others, I've run into a problem doing this on report builder. | Parent Group …
BobaFett
  • 3
  • 2
0
votes
2 answers

How can i run the report without specifying the parameter value in SSRS

H, I have a parameter 'Client' as drop down in SSRS report. My requirement is to select all the records for all the clients if i don't select any parameter value and if i select particular value in the drop down,i need to display records for the…
SqlLearner
  • 763
  • 8
  • 23
  • 37
1 2 3
…
27 28