Questions tagged [ssrs]

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

Filter by
Sorted by
Tagged with
78
votes
5answers
25k views

Are SQL Server in-place upgrades as ill advised as they used to be?

I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade. I'm currently upgrading my 2008 R2 DEV and TEST ...
8
votes
1answer
28k views

How to keep the structure of the Tablix when there is no data to show

We have a SSRS report which shows the result of a dataset in a tablix. If the query in the dataset returns no data, the header of the Tablix gets displayed but not the tablix cells below the header. I ...
4
votes
2answers
7k views

Can SSRS used to Update or Modify data tables?

We all know SSRS (SQL Server Reporting Services) is to read data. However, can SSRS be utilized to update rows or insert rows, and should it? I am seeing resources here, where you can take user ...
7
votes
3answers
11k views

SSRS Blocking Processes

We have a busy SSRS Reporting server (SQL Server 2008 R2) on which we see frequent blocking between the below processes: [dbo].[CheckSessionLock] [dbo].[WriteLockSession] We are aware that some ...
3
votes
1answer
1k views

Calculate Difference in Overlapping Time in PostgreSQL / SSRS

I'm using PostgreSQL 9.2 and SSRS 3.0. I'm trying to calculate the difference in non-overlapping time entries in a timesheet. My data looks like this: I would like this to return: I can get the ...
5
votes
3answers
17k 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 ...
4
votes
1answer
1k views

Updating directly from SP1 to SP3

I am considering applying the Service Pack 3 in a SQL Server 2008 with Service Pack 1; however, I was not able to find if there are any drawbacks in this process, specially regarding to Replication ...
4
votes
1answer
4k views

Real Time SQL Server Analysis Services Cube Processing Report

I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services cubes are processing using SQL Server Reporting Services? I would like to be able to run ...
17
votes
1answer
3k views

Will running a large query on a secondary database in an availability group affect transaction performance in the primary database?

I need to provide real-time, or almost real-time, data for SSRS and Tableau reporting. I don't want the production OLTP system to be negatively impacted by long running queries. Will running a large ...
11
votes
2answers
2k views

alert when any job in a job category fails

Is it possible to set up an alert in SQL Server 2008 that will send an e-mail anytime a job in a specific category fails? I am wondering because I would like to set up an e-mail anytime an SSRS ...
10
votes
1answer
23k views

How can I tell which data sources are being used in SSRS?

We have a bunch of SSRS (2008) reports deployed to our web portal. We have edited some of the reports to use a shared data source different than the one with which it was originally deployed. I am ...
5
votes
2answers
8k views

RSExecRole missing

I have multiple servers and 4 of them have reporting services installed with the ReportServer & ReportServerTempDB databases. A few days ago I was setting up security for a new login and I found ...
5
votes
1answer
2k 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 ....
3
votes
0answers
2k views

SSRS slow opening a Datasource

While optimizing a report, I discovered that the time reported by TimeDataRetrieval in ExecutionLog2 was a couple of seconds longer than the query times shown in SQL Server Profiler for that report ...
3
votes
2answers
13k views

Page Break is splitting in the middle of a single row in SSRS

I have an SSRS report for an Invoice and it generally works perfectly but occasionally it will page break in the middle of a row in the main Tablix. The row will split and leave part of the text on ...
2
votes
1answer
260 views

Documenting SSRS and SSIS jobs that are the Job Activity Monitor

We are running a SQL Server 2014 database using SSRS as a reporting tool. We have data coming in via SSIS jobs and linked servers. We have developers creating various SSRS jobs and scheduling them. ...
1
vote
1answer
419 views

drastically different runtimes in BIDS and the SSRS Web Portal

I have a report in a BIDS project that has been deployed to our SSRS Web Portal. On the web, it renders within seconds. In BIDS, it takes upwards of seven minutes. I can see that the query runs ...
1
vote
2answers
1k views

Reporting Services buttons show up one under the other instead of side-by-side

This seems a browser problem to me. When I render a reporting services report in IE11, the "Export", "Refresh" and "Export to Data Feed" buttons show up under each other taking up a lot of extra ...
1
vote
0answers
3k views

SSRS Error : Could not connect to server, ( since the TLS 1.0 was disabled)

Since the recent patch where TLS 1.0 was disabled and 1.1, 1.2 Enabled , we are having issues where the SSRS in the server cannot make connections to the Database server. We had to re-enable TLS1.0 ...
1
vote
1answer
68 views

SSRS 2016 on SQL Server 2014

I have question about using SSRS 2016 on SQL server 2014 First of all, I don't have much experience with Reporting services. Company use SQL server 2014 and they have SQL database on it (DB is ...
0
votes
1answer
2k views

Reporting Services TempDB lock blocking report generation

Two days ago one of our reports in Reporting Services started to take much longer to generate. Its generation time had increased from 4 seconds to 2 minutes. Investigation found: The Stored ...
0
votes
1answer
173 views

I cannot get my data source to connect to an SQL Server named instance using SSRS Report Builder

I have a report in SSRS and I want to update the data source to use a named instance instead of the default instance. The server host will remain the same. I thought this would be easy. I simply ...
0
votes
1answer
121 views

Chart creation in BIDS 2008

Due to low reputation point i am not able to include the picture. I am trying to make u guys understand what i am asking for: I had created a report. And that Report contains these fields and ...
-1
votes
1answer
333 views

Installation/Configuration Error Installing 2012 SSRS Native Mode

I believe I properly installed Reporting Services for SQL Server 2012 Developer edition however I get a HTTP 500 error when attempting to view the report viewer or manager URLs in both IE 10 and ...