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

learn more… | top users | synonyms (1)

-3
votes
0answers
45 views

What functions should I use to display data like that?

What functions in SQL Server 2012 should I use to achieve the result as shown below?
0
votes
0answers
13 views

Reporting Services Maintenance and Performance Best Practices

I'm simply looking for what most folks do to keep their SSRS servers in top shape. Beyond performing backups of the databases, symmetric key, custom extensions, configuration files, IIS settings, ...
1
vote
0answers
14 views

SSRS: UserName value in Subscriptions table, ExtensionSettings column

SSRS subscription to a Windows File Share. Is there a way to query for all the "credentials used to access the file share" in plain text? It appears that the UserName value in the ExtensionSettings ...
0
votes
0answers
39 views

SQL Server 2008 R2 Reporting Services: “Exception of type System.OutOfMemoryException was thrown”

When I run a report on SSRS reporting services to fetch 600000 row.. I get a error "Exception of type System.OutOfMemoryException was thrown". I read so many blog's for solving this issue but still I ...
1
vote
0answers
20 views

Select where table and column name are from another table

I know I need dynamic sql, but haven't gotten this to work: I want to loop through a table and for each row, return the value of the field that is located by two columns for that row. Master ...
1
vote
0answers
5 views

Missing emails from a scheduled report

I have a scheduled report with a query used to determine the recipients. Every time the report runs, there seems to be a few people who are not receiving the emails. I enabled SMTP logging, and indeed ...
4
votes
2answers
57 views

Get SSRS Datasources from ReportServer

Housekeeping on an old SSRS, this particular server is 2008R2. I have the query below which gets me the name, location, creation and modification overview for all the reports. I would also like to ...
0
votes
1answer
37 views

extract values from different stored procedures and create one report

At the company I work, the third party taking care of the database. So there is giant complex stored procedure that produces the result for one parameter only. When management needs a desirable ...
2
votes
2answers
76 views

Completion of SQL Job triggers start of job on a different SQL Server

I want the completion of a SQL Server agent job to trigger the start of a job on another server. More specifically, I want my SSRS server to email a subscription report whenever an FTP/Import job ...
0
votes
1answer
23 views

How to set SSRS parameter Default to uncheck specific options?

In a multi-select Parameter for SSRS (2008), I want the default state of an input parameter to be such that one option is unchecked while all others are checked. Like in the image that follows: Is ...
0
votes
0answers
17 views

Grab value from the group SSRS

How can I grab a value for a particular month in SSRS if it's in a group? I have all 12 months as a group, in a column outside of the group I need to get the value for March that is in the group?
0
votes
0answers
24 views

Migrate 2008 R2 SSRS DB to 2014?

I am working on upgrading/migrating our SSRS from 2008 R2 on Windows 2008 R2 to SQL 2014 on Windows 2012 R2. I was originally going the route of just recreating side by side. I already have the new ...
2
votes
1answer
54 views

Can mirroring be used to upgrade SSRS?

Can you use mirroring to upgrade SSRS? For instance, I've upgraded from SQL 2005 to SQL 2014 with mirroring. SSRS is running on the same box as my database server. I'm going from SQL 2012 ...
0
votes
0answers
34 views

How to have static and dynamic columns in one table with calculation?

How can I have static rows with 12 months along with dynamic rows and have it look like one table? I don't have column Budget, I created separate helper table with budget amount for whole year. So I ...
1
vote
1answer
51 views

ReportServerTempDB in AlwaysOn Availability group

ReportserverTempdb logfile is 6TB in size and growing and I need help. I am supporting a huge reporting server farm and the client wants reporting services to be in AlawysON Availability group(AAG) ...
0
votes
0answers
48 views

Reporting Services Configuration Manager - error message “Could not connect to server…server was not found..”

I am attempting to install and configure SQL Reporting Services (SSRS). I have a windows 8.1 Pro OS laptop. Running SQL Server 2012 Express with SQL Server 2012 Management Studio. I downloaded and ...
2
votes
3answers
58 views

Cannot create SSRS subscription for a report using SSAS as datasource

My questions is : how should I config SSRS subscription a report, which consumes SSAS datasource. I already googled and lookup stackoverflow a lot and still couldn't make it work. Problems: I ...
0
votes
0answers
8 views

Convert spatial points data to line data for use in Line Layer in SSRS Map

I want to create a SSRS Line map report by creating a line between my booking country and delivery country and vary the line width based on the number of orders. I've added my shape file using ESRI ...
1
vote
1answer
45 views

How to determine if an SSRS data driven subscription job has completed

I have a report that generates PDF's using a data driven subscription process. When the job is started, it shows a success status shortly afterwards, however I believe that this is really ...
0
votes
1answer
35 views

To list the databases and logins

Can anyone tell me the query to list the databases and SSRS reports and different logins in a particular server ?
0
votes
0answers
46 views

Azure SQL Server SSRS Reporting With VM Error

I'm using an Azure VM with SQL Server Standard 2014 installed so I can use it as a Report Server for my separately hosted SQL Server databases. I can make the connection to my database using ...
1
vote
0answers
32 views

What's the deal with transactions in a stored procedure called by an SSRS report?

Consider the following: sp_a contains an sp_executesql call to exec sp_b sp_b begins and commits a transaction, then immediately logs @@TRANCOUNT. When I call sp_a manually from within SSMS, the ...
0
votes
0answers
14 views

Azure SQL SSRS Hybrid Configuration [duplicate]

I would like to migrate my existing Visual Studio SSRS Reports to the cloud while keeping my database on-premise. Any advice on resources for getting started would be greatly appreciated - tutorials, ...
0
votes
0answers
19 views

Azure SQL hybrid SSRS configuration

I would like to migrate my existing Visual Studio SSRS Reports to the cloud while keeping my database on-premise. Any advice on resources for getting started would be greatly appreciated - tutorials, ...
1
vote
1answer
38 views

Adding a new data set in SSRS with nested stored procedures

I have spOne which builds a couple of global temp tables with over 500 lines of code. Normally it would return a single result set but I wanted to leverage the code for building the temp tables ...
4
votes
1answer
133 views

How do I enable both PowerShell Remoting and SPN for SQL Server Reporting?

I'm struggling with remoting servers with SQL Server Reporting Services running. My Reporting Services are running with individual domain-accounts, and I have set up SPNs for them ...
0
votes
0answers
53 views

Place a footer on bottom of last page of report, and have it work with Excel export

I'm helping a client with implementing some electronically-generated shipping forms, and most of them need a footer section on the last page of the report with some summary details, signature section, ...
1
vote
0answers
90 views

SSRS Lookup #Error on some rows

I'm having trouble working out the details with an IIF containing some lookup statements. The setup: Dataset 1: Transactions Fields: itemid, transactionnotes, rdesc Dataset 2: EmployeeInfo Fields: ...
0
votes
0answers
17 views

Setting up SSRS on multiple servers on network

I have a group of virtual machines on the same domain running Windows server 2003 and sql server 2005 standard edition. I already have SSRS set up on one of the virtual machines which is working fine ...
0
votes
0answers
47 views

Date is not sorted in reporting services consecutively and correctly

I am trying to generate a report using the SSRS,but the date is not being sorted as I want when running the query. It is being shown as follow (consecutive months are mixed): 28/05/2014 ...
1
vote
0answers
39 views

Reporting services database was NATIVE, now it's UNKNOWN

After migrating a database from Sql Server 2012 to Sql Server 2014, we found a little problem. It was told me that the reporting server was not used, so I just installed the SQL Server 2014 and ...
1
vote
1answer
49 views

Phantom comparison data in SQL Server Reporting Services - How do I remove it? [closed]

I'm trying to write a query that will allow me to include or exclude a filter in my where statement based on whether a parameter passed in is set to true or false. So far my statement is IF ...
-4
votes
1answer
44 views

SQL Server and msbi relation and difference [closed]

With SQL Server 2008R2, we have analysis services, reporting services, and data moving and manipulation services with SQL Server Management Studio. So why do we need SSIS, SSRS, and SSAS?
0
votes
0answers
14 views

ReportServerTempDB - SessionLock table Locked [duplicate]

When a number of SSRS reports are run in a short period of time, I see a number of locks occur on the ReportServerTempDB. The table locked is dbo.SessionLock. The locks sit there until I restart the ...
1
vote
0answers
21 views

Reporting services setup procedure on present SQL 2008 [closed]

How do you install, configure and setup SSRS SQL 2008 on present SQL "Production server" with 50 databases. I am doing this to save in Licenses but I don't know if there is a better way to implement ...
2
votes
0answers
34 views

SSRS dynamic data retrieved from another dataset

I want to get data(dynamic)according to the data in another dataset and put the result in textbox of the different dataset. Right now, the data I get is static and I tried to use many expressions but ...
1
vote
0answers
44 views

Why won't my subscription parameter value stick?

I've set up an "Aggregate level" parameter on a SSRS report, so that I could easily schedule subscriptions for daily, weekly and monthly aggregates. The parameter has a Text datatype, and doesn't ...
1
vote
1answer
57 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 ...
1
vote
0answers
34 views

What does SSRS technically do when it expires the cache?

Our data is loaded daily. My report can be run, using a parameter, for any number of sites (100 is the total number of sites) and I want it to cache a temporary copy of the report and expire it on a ...
0
votes
0answers
22 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 ...
0
votes
1answer
66 views

How to pass SSRS params into a URL

I have Native SSRS configured on a 2012 instance (11.0.2100). I have two reports with images that act as buttons to toggle between the chart report and the detail report. I want to configure the ...
0
votes
0answers
19 views

SSRS REPORT average

how to calculate average values of two cells vertically in SSRS. I need average of 8.587 and 9.307 in 'Avg TO date' in 'Plant Avg'. I'm very new to SSRS. please help me. I also want to merge two ...
0
votes
1answer
31 views

Permissions granted are insufficient for this operation

I am using Report Builder 3.0 and have been trying to run reports using AdventureWorks 2014 in SQL Server Express 2014. My report Server is http://John-PC/ReportServer_SQLExpress. When I click Run in ...
0
votes
0answers
41 views

SSRS Scrolling Issue

My report column headers are not visible when I scoll down my report in SSRS. The screenshot below shows what is happening. The Tablix properties are set to keep the row and column headers visible ...
0
votes
1answer
35 views

Specify windows account for SSRS data source in SSDT project

In the properties of a data source in SSRS, I can specify a Windows domain account to use, like this: This data source was originally deployed from a SSDT project and I need these settings to be ...
0
votes
0answers
112 views

File size increased X3 with new Microsoft reporting services pdf rendering extension

I have upgraded from SQL server SSRS 2008 to 2014 When I create a PDF using the same code my PDF file sizes have now increased 3 times. The only difference is Microsoft reporting services pdf ...
0
votes
1answer
304 views

Reporting Services service restart fixes slow reports

SQL 2012, the reports are displayed on a WEB page or rendered to PDF I have an ongoing problem with reports suddenly slowing down. The only way to "fix" this problem is to restart the service. This ...
1
vote
0answers
214 views

Can't uninstall SQL Server 2008 R2 SP3

I have encountered the error on SQL Server 2008 R2 where Report Builder 3 fails to load with error Microsoft.ReportingServices.ComponentLibrary.Controls.dll, has a different computed hash than ...
3
votes
1answer
173 views

SSRS report slow on initial query of the day

I am trying to fix an issue where an SSRS report is slow for the initial query of the day. I have tried using the solution described here: Solving issue with first long starting report on SSRS 2008 ...
0
votes
1answer
350 views

SSRS CROSS Domain Reports Server Authentication

I have a pretty complicated situation at hand, let me try to explain. I have a SQL Server and a Web Server in a separate domain (lets call it domain A). SQL Server has the databases for Reporting ...