Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008]

Microsoft SQL Server 2008 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed. Use with the [reporting-services] and/or [ssrs] tags

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2008. More info in the tag.

This tag is for questions specific to SSRS 2008.

6153 questions
20
votes
7 answers

SQL Reporting services: First call is very slow

I've installed a SQL Reporting server (2008 R2), with some reports. But I've some performances issues. The first call of the day to the server(going on the report interface by example), is VERY slow(something like 30-45seconds at best). The report…
J4N
  • 19,480
  • 39
  • 187
  • 340
20
votes
10 answers

Parameter is missing a value ssrs 2008

I have a parameter of integer datatype which is hidden. When i run the report, report gives me an error Parameter X is missing a value However if i make the parameter visible it works. I tried providing default value of 0 but that does not…
Adarsh
  • 203
  • 1
  • 2
  • 6
20
votes
1 answer

WHERE clause in SSRS expression

What's the syntax for inserting a WHERE clause in an SSRS expression? I am using BIDS 2008. =Sum(Fields!QuantityToShip.Value) WHERE FIELDS!Program.Value = "FC" The code listed above represents the logic I want to use, but obviously inserting the…
sion_corn
  • 3,043
  • 8
  • 39
  • 65
19
votes
6 answers

Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and each column is a field in a form for that…
AaronSieb
  • 8,106
  • 8
  • 39
  • 58
19
votes
9 answers

Empty or Null value display in SSRS text boxes

Using SSRS (2008) what is the best way you have found to handle null or empty values and replace them with something else to display. The quite obvious solutions is =IIF(IsNothing(Fields!MyField.Value),"NA",Fields!MyFields.Value) That works though…
keithwarren7
  • 14,094
  • 8
  • 53
  • 74
19
votes
7 answers

SSRS Expression: The value expression for textbox has scope parameter that is invalid for aggregate

i'm recieving the following error: Error 1 [rsInvalidAggregateScope] The Value expression for the text box ‘Textbox2’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that…
User999999
  • 2,500
  • 7
  • 37
  • 63
19
votes
5 answers

How do I find a specific textbox within a SSRS 2008 R2 Report

I have a large report that I built in Report Builder 3.0. The report consist of several tablexes and several (800 - 1000) textboxes. When I get an error in an expression, the system says I have an error in Textbox205 for example. Is there an easy…
Teddy Jackson
  • 191
  • 1
  • 1
  • 3
19
votes
6 answers

ssrs setting column visibility on rowgroup

I'm trying to hide a column but it belongs in the RowGroups area. Unfortunately, the Column Visibility is greyed out and disabled. I'd like to just hide the column under certain conditions (using expressions) but keep the grouping. I found a similar…
Gabe
  • 5,113
  • 11
  • 55
  • 88
19
votes
1 answer

Caching vs Report Snapshot in SSRS

I was reading an article on how to improve performance in SSRS at here and was wondering; What exactly is difference between Caching & Report Snapshot? What are the parameters that should be handy when deciding between Caching & Report…
xorpower
  • 17,975
  • 51
  • 129
  • 180
18
votes
3 answers

Display Superscript in SSRS reports

I m working on SSRS 2008. i want to display date as 1st January 2011.. but "st" should be in superscipt .. not like "1st". is there any way to display "st", "nd","rd" and "th" in superscipt without installing any custom font type(other Font Type).
Touseef
  • 414
  • 1
  • 5
  • 17
18
votes
2 answers

"An item with the same key has already been added" Error on SSRS When Trying to Set Dataset

When i try to set the Dataset in SSRS IDE, i get the error you see in the snapshot. The query works totally fine in SQL Server Management Studio, i wonder where did i go wrong?! The connection to DB is well established. OPTIONAL: In case you want…
Beginner_Pal
  • 1,285
  • 6
  • 18
  • 23
18
votes
2 answers

SSRS report parameter.label showing parameter.value

I have a SSRS report, in my report I have a dataset which has an ID and NAME field, then I created a parameter and set its value to ID from dataset and Label to NAME of dataset. I can see the label when I preview report and select it, but I am also…
alphaprolix
  • 601
  • 2
  • 10
  • 25
18
votes
2 answers

SSRS: How to display a hyperlink in sql services reporting

I'm using SSRS for 2008 R2 to display some data-generated reports. In my database table, I have a cell called Remarks. It usually contains links to software defects. The cell is nvarchar(max) and I've added links such as…
bearaman
  • 1,071
  • 6
  • 23
  • 43
17
votes
8 answers

How Get Reports To See Shared Data Sources

I am running 2008 R2 I have an entire set of reports that I have to load into RS. These were developed and sent to our company by a third party. They connect to a shared data source. I uploaded the reports into folders that separated them by…
NomadicDeveloper
  • 857
  • 4
  • 17
  • 29
17
votes
2 answers

Working with Time Zones in SSRS

We store all our dates SQL Server 2008 database in UTC time in DateTime columns. I'm using SSRS to create reports and I need to convert all the times on the reports to the Time Zone of the computer where they're running the report from. I know…
jamiegs
  • 1,761
  • 2
  • 15
  • 23
1 2 3
…
99 100