Questions tagged [ssrs-2008]

SQL Server Reporting Services 2008, a web based reporting tool produced by Microsoft and bundled with SQL Server 2008.

Filter by
Sorted by
Tagged with
0
votes
0answers
23 views

How to export the SSRS report in excel

I have 7 pages in my SSRS report and also I'm used page break option. Is there any way available to export all the pages in single excel sheet. Please provide me solutions
0
votes
0answers
9 views

how to set the page break in SSRS report

I achieved the page break for every 8 rows but I have 33 rows in my SSRS report, if 33 rows is divisible by 8 i get 5 pages and I could see there is only one row in 5th page I don't to display in 5th ...
0
votes
0answers
21 views

How do I make an Alert property in SSRS work just like I want it to?

How do I make an Alert property work just like I want it to? What is the capacity of Action properties in SSRS? Ok, so, just like a hyperlink in html, in SSRS, most objects have an Action property ...
0
votes
0answers
47 views

Identify ssis packages that call ssrs reports

We are migrating our SSRS reports server database from SQL SERVER 2008 R2 to SQL SERVER 2014 and as I understand it this means all SSRS reports will receive a new id. Hence any SSIS packages that ...
0
votes
1answer
275 views

SSRS 2008 to 2014 Migration Excel Export error

We are working on migrating our SSRS from SQL Server 2008 to SQL Server 2014. After brining the reports over I have a set of reports that will execute just fine but when I try to perform a standard ...
2
votes
1answer
313 views

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 ...
2
votes
1answer
1k views

Nulling other Date parameters in SSRS on selection of one

I have set up multiple dates as input parameters and in SQL query, I've set up the WHERE clause like: WHERE datecol1 >= @date1 OR (@date1 IS NULL) So that handles dates as optional parameters. I ...
0
votes
0answers
44 views

Is it possible to have SSRS generate report while a parameter is being typed?

I have only been using SSRS for a few weeks now and from what I have seen, I know that we create a dataset, define parameters (I do it by using a paramaterized stored procedure and linking that to a ...
1
vote
0answers
44 views

Report Builder Data Sources Do Not Change in Catalog Table

I am trying to extract the connection string for MS SSRS reports from the Report Server Catalog table. This is straightforward enough but if I change the Data Source in Report Builder, the change is ...
0
votes
1answer
244 views

SSRS 2008 Security - can't run reports

I have SSRS2008 set up and running locally on the server (SRV0100). It is set up to run under the localsystem account for the service account (default). I changed the rsreportserver.config to use ...
0
votes
1answer
2k views

SSRS email Subscription Not Working but local smtp is working

SQL SERVER EDITION- 2008 ENTERPRISE EVALUATION EDITION Operating System- Window Server 2008 R2 I've Created Local Smtp to use gmail id for Subscription of SSRS Report by Email as we don't have an ...
2
votes
1answer
1k views

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 ...
1
vote
1answer
1k views

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 ...
0
votes
1answer
202 views

Split record data in ssrs

Hi all can you please assist me, I would like to split my records into different year and month see below I want figure one to be split into different categories but this must all display on one ...
1
vote
2answers
14k views

SQL Server Reporting services migration (2008 to 2012)

We have a SSRS 2008 (not R2) instance with a few hundred reports, and now, on a new machine we have installed a 2012 instance of SSRS. We need to migrate all the reports, while keeping all their ...
2
votes
0answers
568 views

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 ...
0
votes
1answer
199 views

Report in MSSSRS without Star Schema?

I have to create a single report in MSSSRS to view calculated columns (Salary, Total Compensation, Performance Bonus, 401 (k)) by Employee, Department, Service Line, Geography, Quarter, etc. My ...
0
votes
2answers
720 views

Do I need to have enterprise server in order to have multiple data sources in SSRS

I am currently running a single server setup of SSRS on MSSQL Server 2008 R2 Standard Edition and would like to know if I can have multiple data sources in this type of setup. The reason I ask this ...
3
votes
4answers
21k views

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 ...
9
votes
2answers
75k views

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 ...
4
votes
2answers
31k views

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, ...
2
votes
3answers
3k views

Not getting a result set in SSRS 2008r2 from an iSeries DB2 SQL stored procedure

After reading 'Defining an SQL procedure' section of DB2 UDB for iSeries SQL Programming Concepts V5R2 and 'Returning result sets from stored procedures' section of i5/OS Information Center, Version 5 ...
0
votes
0answers
2k views

SSRS 2008. subreport page breaking issue migrating SSRS 2005 reports over to 2008

I'm moving over several hundred reports that were created in SSRS 2005 over to an SSRS 2008 server, and most run fine when copying the .rpt files over, but the reports that have sub-reports don't page ...
2
votes
1answer
5k views

Reporting Services TempDB keeps going into restoring mode

I am looking into an issue with SQL Server 2008 Reporting Services. It has been working fine until yesterday morning. Now I notice that ReportServerTempDB keeps on going into Restoring... mode. I ...
0
votes
2answers
2k 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
177 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 or ...
1
vote
1answer
95 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 ...
2
votes
4answers
5k 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
1k 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
2k 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 ...
0
votes
1answer
10k 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
0answers
544 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 ...
1
vote
1answer
4k 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 ...
2
votes
1answer
2k 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 ...
4
votes
1answer
2k 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 ...
6
votes
1answer
33k views

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 ...
3
votes
2answers
5k 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, I'...
3
votes
1answer
8k 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 ...
4
votes
1answer
2k 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 ad-...
2
votes
1answer
38 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
5
votes
1answer
182 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
2answers
1k 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 ...
1
vote
1answer
1k 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 ...
4
votes
1answer
1k 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 ...