Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
0
votes
1 answer

SSRS get background color codes from database - expression

How can I make use below SSRS expression functionality to get background colors from database, as tooltip explains ?
Aditya
  • 2,299
  • 5
  • 32
  • 54
0
votes
1 answer

SSRS Column visibility expression in Groups

I have a report where I am grouping by Main Client, Client, Year, Quarter, Month, Date and Day. I have a request to add a new field after the client field called Hierarchy then I have to apply the column visibility in the Hierarchy…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

SSRS Multiple Sorts in one Matrix in One column

This is a follow on question from one I have earlier posted but have not reviewed the answers for and I didnt want to confuse things. Can someone tell me if this is possible. I have 2 columns, Company and revenue, I want to initially sort by…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
1 answer

Custom Sort Order in SSRS 2014

I am having to create a custom sort order within a SSRS Matrix, it returns 2 rows of data and then a total. When I add the custom sort order within the Row Group Sort Order, its moving the Total to the top and the relevant rows below it instead of…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
1 answer

SSRS Nested IIF using different fields to change font color

I have a report where I need to accomplish 2 tasks: =IIf(Fields!TargetVOC.Value = "","White","Black") =IIf(Fields!VOCFlag.Value=1,"Green","Red") I need to combine #1 and #2 in one expression. (see below) My…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

SSRS Total/Sum of IIF Expression

I'm having difficulty totalling this IIF expression using report builder 3.0 and SQL Server 2008. Some info on the table, I have a 20% commission and a $5,000 cap. I just need to total the Cap…
Nick
  • 155
  • 4
  • 16
0
votes
0 answers

How to recover the share data sources in ssrs

I am having some trouble with my reports, accidentally I deleted the share data sources and now my reports are not running and I have around 400 reports. How to recover the share data source. I have the backup of the reportserver and the…
Red Devil
  • 2,343
  • 2
  • 21
  • 41
0
votes
2 answers

Unable to get data from stored procedure to ssrs report

i am try to access data from stored procedure to ssrs report. but i don't get the answer. it shows the error "[rsRuntimeErrorInExpression] The Caption expression for the chart ‘Chart 4’ contains an error: The query returned no rows for the dataset.…
Anupa Sankar
  • 491
  • 2
  • 7
  • 17
0
votes
0 answers

SSRS - How to repeat Table Header on every page with different data?

In an SSRS report, instead of a page header, I've a table header that I've made to repeat at the top of every page. I can't use page header since it is a sub-report and headers/footers of a sub-reports get over-ridden by the main report. The report…
SJaka
  • 712
  • 13
  • 40
0
votes
1 answer

SSRS date parameter : report start date should be yestardays on daily bases but on monday it should be friday's date

In my report I want to populate date parameter automatically. on daily bases date need to be select previous day (today()-1) , but on Monday it need to select Friday date. please help me to write a function around this I have date parameter in my…
Anil
  • 65
  • 5
0
votes
0 answers

Not able to Trim or remove Hexadecimal character from SSRS report parameter

My SSRS report is throwing the below error when i run the report. An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow) The server sent an…
Vignesh R
  • 15
  • 6
0
votes
0 answers

SSRS Toggle Expand/Collapse using Parameter

I have report which are grouped by Client,Sub Client, Year, Quarter, Month, Date and Day. The group is set-up using Expand and Collapse option. For subscription purposes the report does not work when rendering in .pdf version because it needs to be…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
0 answers

SSRS actual parameter values are overriden by default values

I have set default values for my ssrs report. Setting in my Report Parameter Properties This works when I preview the report. The problem is that when I have deployed the rdl and when I generate a report I am getting the default values and not the…
ndavid9
  • 13
  • 3
0
votes
0 answers

convert a vertical table to horizontal table

I have a table and the format is below: Staff Client Problems Status 1 101 a 1 1 101 b 0 1 101 e 1 2 102 g 0 I want to create a report based on it…
Ice
  • 429
  • 2
  • 6
  • 19
0
votes
1 answer

SSRS Dynamic Gauges

I have a report that has a collection of many gauges arranged in a grid. The row of data that each gauges references is different based on the parameters used to run the report. To accomplish this, I code each gauge individually to reference a…
nicbjones
  • 35
  • 4
1 2 3
…
99 100