The ssrs-2008 tag has no wiki summary.
4
votes
1answer
55 views
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
3
votes
1answer
209 views
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 ...
3
votes
1answer
321 views
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 ...
3
votes
2answers
287 views
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 ...
2
votes
2answers
355 views
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, ...
2
votes
4answers
53 views
Creating a copy of production database for reporting purposes
We previously ran Crystal Reports straight off our production database. This caused a direct impact to the users using the database. We moved to a new (dedicated) server and a new database and ditched ...
2
votes
1answer
150 views
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 ...
2
votes
1answer
30 views
How to set the language of a doc to a DB field
Is there a way to set the language of a document body to a value fetch from the DB in SSRS? I tried with a simple expression and I got this error. I wonder what the best workaround is
2
votes
2answers
102 views
Issue With SSRS Emailing Reports As PDFs
I have a strange issue that I'm unable to find the answer to online or by looking at it myself.
Basically when I set up an email subscription for a report I've created in SSRS Report Builder (2008); ...
2
votes
1answer
257 views
An unknown error occurred while processing the request on the server [closed]
I have an asp.net 4.0 application with a button that opens a SSRS report. This works fine on my development machine and I can open the report directly with report manager but when I try to access the ...
1
vote
1answer
379 views
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 ...
1
vote
1answer
41 views
How to create column
I am new to ssrs report designing can any one help me in this
I have two question
1) How to create a column to input user data and after that I need to perform some operations on data enter by ...
1
vote
1answer
61 views
The best way to log access to SSRS reports
We have a number of SSRS reports created using BIDS 2008 on SQL Server 2008 r2. The business wants us to log access to these reports. For example who and when run the Report A.
What is the best way ...
1
vote
1answer
191 views
Convert spatial points data to line data for use in Line Layer in SQL Server Reporting Services (SSRS)
I have a query that returns the fields Order, Lat, Long, SpatialData, <OtherStuff>. SpatialData is a point.
I want to create a line layer that draws lines between my points based on the order ...
1
vote
1answer
3k views
Page setup and print layout in SSRS Report
I'm creating a SSRS report using BID 2008 and have a couple of questions, your help would be much appreciated.
Why the page layout on the report is different from print set up? For example I have ...
1
vote
1answer
45 views
SSRS 2008 R2 setup issue
I have installed SSRS 2008 R2 on my desktop and server. When I hit the reports link on my desktop
http://mypc/Reports_mypc/Pages/Folder.aspx
all I get to see is this
I cant create a new folder ...
0
votes
1answer
243 views
Can you rename or name Reporting Services jobs?
In Report Manager you can create schedules, either shared or one-of's. When you create these schedules a job is created in SQL Server with names that look like guids. IS it safe to rename these jobs ...
0
votes
1answer
532 views
Tablix cells width issue in SSRS
I have a weird issue in the reports that I have created in SSRS 2008.
On the report I have got a number of tablixes defined, that should be displayed attached together vertically. Imagine they form a ...
0
votes
1answer
34 views
How to add rows/columns to the table in runtime in SSRS 2008
Usually we design the table to have x number of rows and y number of columns in a report. But how can we create a report which adds the rows and columns dynamically at run time based on the result of ...
0
votes
0answers
63 views
SSRS - rsAccessDenied error
I have created one SSRS text report. I have built and deployed it successfully. I am also able to view it from the report manager succesfully. I am a local admin on windows server but not on SQL ...
