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
11
votes
2 answers

Use an Aggregate function in Sort Expression

I have a report which uses a dataset returned from a stored procedure. There are two key columns: Name and Value I am using this dataset for two tablixes. The first is just a straightforward tablix displaying the data. The second groups the data…
openshac
  • 4,966
  • 5
  • 46
  • 77
11
votes
3 answers

Can not access Report Manager URL in Reporting Services Configuration Manager

I've installed the SQl Server 2008 Reporting services on my PC but when I try to access the Report Manager URL (http://localhost/Reports) I first get prompted to log on, and then after several attempts I end up at a blank screen. I don't know if…
Daniel Hollinrake
  • 1,768
  • 2
  • 19
  • 39
11
votes
5 answers

How to display a time span of seconds in hh:mm:ss format in Reporting Services

In MS Reporting Services 2008, I have a field that is a duration stored as seconds. Is there a slick way to get it into hh:mm:ss format in a group section of the report?
seanicus
  • 1,141
  • 4
  • 19
  • 40
11
votes
2 answers

Query runs quickly in Oracle SQL Developer, but slowly in SSRS 2008 R2

It's that simple: a query that runs in just a few seconds in SQL Developer connecting to Oracle 11g takes 15-25 minutes in SSRS 2008 R2. I haven't tried other versions of SSRS. So far I'm doing all the report execution from VS 2008. I'm using the…
ErikE
  • 48,881
  • 23
  • 151
  • 196
11
votes
5 answers

Dynamically create filename in SSRS 2008

I have been asked a couple times to change the file name dynamically in SSRS 2008. Example: ReportName_201101.RDL. The 201101 represents the execution date. Can this be accomplished in SSRS 2008?
Rebecca
  • 111
  • 1
  • 1
  • 3
11
votes
2 answers

How to apply customized css to SSRS report

I am new to SSRS. I have created a report and was able to deploy it on the server. I am calling the report from ASP.NET application. How can I change the CSS of the report? I want to change the styles for individual data cells of the table deing…
biluriuday
  • 428
  • 1
  • 7
  • 16
11
votes
3 answers

How to get all SSRS reports from Sharepoint url?

I'm very new to SSRS and SharePoint, We deployed the reports in SharePoint location, often some of the Reports doesn't have connection string. For this in order to ensure, I need to get all reports from SharePoint location using c# WPF and check the…
Selva
  • 1,310
  • 2
  • 14
  • 31
11
votes
6 answers

SSRS expression - If null value then return 0 instead of blank

I've seen a few examples but I just can't figure it out for my case. My expressions sums all values from field Total from the dataset AutoDeliveryCount. I need to reference the dataset since I'm using a few Total fields in my report. If the stored…
user3749447
  • 299
  • 2
  • 5
  • 13
11
votes
4 answers

converting date from mm/dd/yyyy to dd/mm/yyyy in SSRS

I have datetime type from DB table. In SSRS report, I'm getting datetime format mm/dd/yyyy. I want to change it to dd/mm/yyyy. I have added expression…
bapi
  • 1,903
  • 10
  • 34
  • 59
11
votes
3 answers

The report server Cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database SSRS Error

I am getting the following error when trying to deploy my SSRS reports on our SQL 2008 R2 Server "The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database...". Most of the solutions on…
Hassan Mokdad
  • 5,832
  • 18
  • 55
  • 90
11
votes
1 answer

Percentages in SSRS Chart

EDIT: The chart is fixed when I use a stacked chart instead of a stacked percentage chart, but this still doesn't tell me what is wrong with using the percentage chart. I have a stacked percentage chart which is going from 0 to 10000% instead of 0…
Phillip Copley
  • 4,238
  • 4
  • 21
  • 38
11
votes
1 answer

SSRS- TextBox Border Width property reverting to 1pt after saving expression

I've been working on this for the last couple hours. I placed the following code into the textbox Border Width Property (this applies to a table not a matrix): =IIF(Fields!SortOrder.Value = 2,"3pt","1pt") Once I click OK on the expression editor…
misterManager
  • 1,174
  • 4
  • 12
  • 33
11
votes
3 answers

SSRS fitting Tablix to exported pdf page

I currently have a Matrix within an SSRS report. Usually, the matrix will fix to a standard page in portrait mode, however there are cases where the length of the columns will exceed a page. Is there a way to have SSRS render the report to a PDF…
mservidio
  • 12,817
  • 9
  • 58
  • 84
10
votes
3 answers

SSRS indicator sizing

When adding an indicator to a report as per the image, is it possible to have all the indicators the same size regardless of the cell size (so centre them all rather than stretching to fill the cell)
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
10
votes
6 answers

SSRS: repeat tablix left-most row group value on each row

I have a tablix in an SSRS 2008 report. It has two-level row groupings, and I'd like the value for the left-most grouping to continue to be displayed on each row. Eg, I get this: group1 subgroup1 500.00 subgroup2 250.00 ... but I'd…
BillVienna
  • 335
  • 1
  • 5
  • 13
1 2 3
…
99 100