SQL Server Reporting Services 2008, a web based reporting tool produced by Microsoft and bundled with SQL Server 2008.
Questions tagged [ssrs-2008]
37 questions
10
votes
3 answers
How to hide rows in SSRS report?
I'm trying to figure out, how I can hide those rows in my report where Total Allocation and Total Cost IN BOTH COLUMNS TOGETHER are 0 in SSRS 2008.
For example:
Total Allocation Total Actual Cost
0 0 <----…
Pawel85
- 451
- 4
- 6
- 10
6
votes
2 answers
SSRS 2008 - How to Total values from an expression
I'm trying to figure out how to total values from a calculated field.
In the example below, I have the following expression:
=IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100,
Fields!actualwork.Value * 77)
Now I want to provide a…
Pawel85
- 451
- 4
- 6
- 10
6
votes
1 answer
Page setup and print layout in SSRS Report
I'm creating a SSRS report using BID 2008 and have a couple of questions:
Why is the page layout on the report different from print set up? For example I have set the page layout of the report in design mode to Landscape but when it is printed, it…
Sky
- 3,744
- 18
- 53
- 68
5
votes
1 answer
Show data point values in the legend section
Is it possible to show the values in the legend section in a chart component of SSRS? I'm using SQLserver 2008.
Something similar to the image below
Carlos Blanco
- 301
- 2
- 10
4
votes
4 answers
SSRS Subscription Error: "Failure sending mail: Report processing has been canceled by the user. Mail will not be resent."
On the report Subscriptions page, under "Status" for Last Run, it has the following error:
Failure sending mail: Report processing has been canceled by the user. Mail will not be resent.
It's a subscription, no person canceled this. Maybe there is…
ShawnMTherrien
- 107
- 1
- 1
- 6
4
votes
1 answer
Renaming the Data Sets in SSRS
What is the easier way to rename the Data Sets in completed SSRS report?
I have created a report in BIDS 2008 and now for some reasons I have to rename the Data Set names, but it seems that renaming the Data Sets in the Report Data pane, does not…
Sky
- 3,744
- 18
- 53
- 68
4
votes
1 answer
Providing an ad-hoc report facility for business users in SQL Server 2008 R2
We are using SQL Server 2008 R2. We need to provide the business users an interactive data exploration facility which they can drag and drop the attributes(columns) they want to create their own ad-hoc report.
I know in SQL Server 2012 it can be…
Sky
- 3,744
- 18
- 53
- 68
4
votes
1 answer
How to query EndDate value from ReportServer..Subscriptions.MatchData
In SQL 2008 R2, I'm putting together some administrative queries on SSRS metadata to check proper configuration, and other sorts of proactive things.
While querying the ReportServer db, I've been successful in checking reports, shared data sources,…
dev_etter
- 762
- 11
- 23
3
votes
1 answer
Which is more efficient, filtering the SSRS dataset or filter using a query parameter
People at my organization use SQL Queries within SSRS reports: for instance
SELECT name, age
FROM egTable
Then, this query is run on the database and then they use a FILTER within SSRS to get rid of unwanted rows. For instance, there is a filter…
LearnByReading
- 711
- 10
- 26
3
votes
2 answers
SSRS 2008 Report toggling between images for various field values
What is the best way for toggling between images on a SSRS report?
On the report I'm creating, there are lots of questions with Yes Or No answers and based on the value I've got for the question, I'd like to show the correct image.
For example we…
Sky
- 3,744
- 18
- 53
- 68
3
votes
1 answer
How to convert execution time to a specific format?
I am working on a report that allows people to print off data for physical signatures. Part of the requirement is to format the exectuion date in the format DDMONYY (27Aug12). I can not find a way to set the format of the date in the report.
How…
DForck42
- 3,068
- 3
- 38
- 67
3
votes
2 answers
can I add a custom SSRS e-mail subscription that forces the "TO" address
I would like to know if it is possible to add a custom delivery extension(?) in SSRS that will enable me to force a value into the "TO" address for particular subscriptions?
Big picture: I am exploring ways to schedule reports that would only permit…
JHFB
- 2,874
- 6
- 39
- 64
3
votes
1 answer
SSRS Scale-Out Deployment: cannot decrypt the symmetric key
I have a single 2008 ssrs instance (#1) up and running and need to add a 2nd server also running ssrs 2008 (#2). The error message on the 2nd server is:
The report server cannot decrypt the symmetric key that is used to
access sensitive or…
Roger
- 133
- 2
2
votes
1 answer
Permissions for executing subscription in SSRS
I'd like to execute an SSRS subscription after some ETL work run by a SSIS package that takes a varying amount of time completes. I'm considering using this method, which basically consists of SSIS calling the same stored procedure that the SQL…
James Lupolt
- 4,278
- 5
- 31
- 46
2
votes
0 answers
Cross-talk with temp tables with SSRS over a shared data source?
I have a data source that is setup to store credentials on the report server and to use them when running reports. Given the following factors, I'm concerned about reports that use temporary tables in the SQL query text (not in a store…
poke
- 527
- 2
- 7
- 16