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
40
votes
4 answers

The report server cannot process the report or shared dataset

I have a problem when I deploy my report project to a remote ssrs with the shared datasource. When I'm using the SQL Server data tool to "preview" my report, it's looks like have no problem. But when Y deply the project, this error message…
lucasasecas
  • 944
  • 2
  • 9
  • 18
37
votes
5 answers

Right pad a string with variable number of spaces

I have a customer table that I want to use to populate a parameter box in SSRS 2008. The cust_num is the value and the concatenation of the cust_name and cust_addr will be the label. The required fields from the table are: cust_num int …
Tony
  • 801
  • 1
  • 7
  • 22
36
votes
8 answers

Download all SSRS reports

I want to get a copy of all .rdl files in one server. I can do the download manually one report at the time, but this is time consuming especially that this server has around 1500 reports. Is there any way or any tool that allows me to download all…
asmgx
  • 7,328
  • 15
  • 82
  • 143
34
votes
18 answers

SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: An error has occurred during report…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
33
votes
10 answers

How to get named excel sheets while exporting from SSRS

Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in SSRS 2005 ? solution: Found this…
rao
  • 1,024
  • 2
  • 11
  • 17
32
votes
3 answers

Copy and paste a table (tablix) in SSRS

I have a tablix that has data for one day, and I need to have the same data at the bottom but in 3 different lines. I'd like to copy the main day table 3 times at the bottom, and then use different datasets for each one. I tried copying the tablix…
urbanmojo
  • 737
  • 3
  • 12
  • 21
32
votes
3 answers

Value expression error: "[BC30456] 'RdlObjectModel' is not a member of 'Reporting Services'

Stumbled on an obscure problem. Posting this because my searches of stack overflow did not find my answer. Hopefully this will help someone else. Problem: My reporting services report will compile, but at run-time provides an error along the lines…
Voysinmyhead
  • 1,315
  • 1
  • 10
  • 18
31
votes
3 answers

Implementing Target lines, in SSRS column Charts

I have a column graph, that shows a trend of consumption over time, The y-axis being consumption and x-axis being time in month, I have to implement a target consumption. I implemented a target, by adding data field with a Line chart type, this is…
Brian Paul
  • 651
  • 2
  • 12
  • 21
30
votes
3 answers

Listing all Data Sources and their Dependencies (reports, items, etc) in SQL Server 2008 R2

I am new to SQL Server, and I am sorry if there is an obvious solution to my question but I can't seem to find it. I am looking to generate a report (or list) of all the data sources and their individual dependencies on an SQL Server 2008 R2…
Marwan مروان
  • 2,163
  • 8
  • 30
  • 40
30
votes
7 answers

SSRS tablix column CanGrow property for width?

I'm working on a tablix in SSRS 2008 and want my columns to autosize (width only) to their contents. CanGrow only affects height. Is there a property I'm missing or any way to otherwise rig the columns to do this?
John Straka
  • 1,874
  • 5
  • 28
  • 49
30
votes
1 answer

Reporting Services 2008 - The report server installation is not initialized

I am trying to set up Report Server 2008 on a separate machine to the Reporting Services databases which are on a SQL Server 2008 R2 machine. I configure everything in the Reporting Services Configuration Manager (identical to a set up we have…
openshac
  • 4,966
  • 5
  • 46
  • 77
30
votes
12 answers

SSRS 2008: error message saying my parameter doesn't exist but it clearly does?

I have a report that has about 10 parameters and about 10 datasets and one datasource. I typed alot but I really need help so I figured I would try and provide as much info about the problem as I could right from the start. Let's simplify it…
gloomy.penguin
  • 5,833
  • 6
  • 33
  • 59
29
votes
7 answers

Visual Studio for SSRS 2008 - How to organize reports into subfolders in Solution Explorer?

Right now I have a project called reports with several reports. In solution explorer it looks like this: Shared Data Sources -- DEV Reports -- Report1 -- Report2 -- Report3 I want to make it look like this and have the same structure carry…
Greg
  • 45,306
  • 89
  • 231
  • 297
28
votes
1 answer

How to check if a value is selected in a multi-value parameter

In SSRS 2008, I use Multi-value parameters to, well, select multiple values for a particular parameter. In my report I have conditional formatting: a particular label has to be blue if the item is selected; otherwise it will stay black. My intuition…
vstrien
  • 2,547
  • 3
  • 27
  • 47
28
votes
3 answers

tablix returns only 1 record for dataset

I have a tablix on an SSRS report: When I run the report it only returns 1 record! I did a sql server trace, and the query that is being executed is returning 14 rows. On the same report, I dropped another table, and put just one field on it, and…
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
1
2
3
…
99 100