The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [ssrs]

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

148 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
2k views

SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime

I wrote a report that is executed by a few hundred users each day and the underlying stored procedure for the data set only takes milliseconds to execute. According to the ReportServer.dbo....
3
votes
0answers
1k views

Users can create SSRS subscriptions but can't edit them

I'm using SSRS 2016. Users can successfully create subscriptions to reports but if they go back to update a parameter (change a date range for example), it throws a "delivery error has occurred" ...
3
votes
1answer
369 views

Creating Report Subscriptions on report that are using a Shared data source that uses Windows Integrated Security

We've recently deployed a new SSRS Server 2012, that can use Windows Integrated Security. We configured the servers to properly use Kerberos authentication and we solved the double hop issue. Now, ...
3
votes
0answers
587 views

Weird SSRS reports error while Depolying reports

I have created the reports by using SSRS 2016 and Visual Studio 2015. When I build the reports it shows success, then deploying the report to the Target server URL I get the following error: ...
3
votes
0answers
694 views

User can create in SSRS, but can't manage objects

We have a user who can create, but is unable to manage objects in SSRS, even though he has content manager permissions and another user who has same permissions who is able to. It is SSRS 2008 R2, ...
3
votes
0answers
1k 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 ...
2
votes
0answers
120 views

Sporadic SSRS Report Performance

I have an SSRS instance with a dashboard report that frequently runs 100-200 times per minute throughout the organization. Most of the time, the report runs quickly with consistent times for data ...
2
votes
0answers
180 views

Enabling Kerberos for Microsoft SQL Server Reporting Services

I am trying to enable Kerberos for MS SQL Server Reporting Services. I am fairly familiar with Windows security and how it works. However, I am new to Scale Out Deployment and Clustering of Windows ...
2
votes
0answers
13 views

SSRS Web Reference Service Not Found

I'm attempting to add a Web Reference to my Visual Studio Web API to link my existing SSRS server to said API. I'm on the Add Web Reference page and I enter the proper URL and the webpage appears in ...
2
votes
0answers
664 views

Investigating Failures of a Subreport in SSRS 2016

I have a SSRS report, MainReport, that basically just calls a series of sub-reports to compile everything into a nice and tidy Excel Document (users love their Excel reports), with each sub-report ...
2
votes
0answers
168 views

Reporting Services Printing Issue

Whenever we apply a patch (recently with CU5), end users need are prompted for administrator credentials to print. In googling, I see many different suggestions, but nothing seems to work. I have ...
2
votes
0answers
637 views

Change the value of a cell based on the hidden value of another cell

On a 2012 SSRS report I have the following: You can see that "Site", 0098110, has a total of 13 "tests" associated with it. This is what I want to show while the group is in the collapsed state. ...
2
votes
0answers
324 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 ...
2
votes
1answer
495 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 ...
2
votes
1answer
2k views

Use Group Managed Service Account for SSRS

We have a production environment running SQL Reporting Services 2014. The service is running as a group managed service account domain\SSRSProdSvc$ We are now trying to change our test environment to ...
2
votes
1answer
303 views

Security implications of running SSRS and an OLTP database on the same server

I am in the process of building a new environment for my company's Customer Relationship Management (CRM) system. This system is a commercially available product which uses SQL Server as its back end ...
2
votes
1answer
257 views

SSRS ReportServer_XXX.log is giving incorrect CPU count

I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the ...
2
votes
0answers
304 views

Is it possible to configure Reporting Services to emit browser compatibility headers?

We have a dashboard that hosts some Reporting Services (2008) reports within frames. The dashboard runs in the browser's standards compliance mode, but this is causing some of the reporting services ...
2
votes
0answers
129 views

Troubleshoot Microsoft SQL Server Reporting Services unexpected error

I have an error implementing reports on reporting services from Visual Studio 2005 but I can do it from the Reports Manager Microsoft SQL Server Reporting Services Versión 10.0.5500.0. The ...
1
vote
0answers
46 views

Ambiguous Error Message when running report

I have a database that is used to track container contents as they are shipped in and out of a facility. I am attempting to create a report off of the table containing all of the cylinders. At ...
1
vote
0answers
19 views

SSRS managed shared subscriptions data from from database

While running an ETL process we need to pause the shared managed SSRS subscriptions and then enable them and run them accordingly when our ETL has progressed. In order to do that we take a backup of ...
1
vote
1answer
95 views

SSRS 2016 report is failing with 'EXCELOPENXML' render format error

Few reports are failing with 'ExcelOpenXML' render format error after rs migration from 2014 to 2016. I made following change to the RS config file so I can use old excel format however some of the ...
1
vote
1answer
37 views

How can I configure a connection string in SSRS 2012 using named pipes?

I have SQL Sever 2012 and I want to create a data source that uses named pipes rather than TCP. This is when I have tried: Data Source=np:\\.\pipe\MSSQL$MSSQLSERVER02\sql\query;Initial Catalog=...
1
vote
0answers
20 views

SSRS: Oracle Data Sources Breaking After Server Updates\Restart

Our SSRS instance has several Shared Data Sources that hit Oracle databases. Whenever we do patching or the server restarts, these Data Sources seem to break. Any reports hitting them come up with the ...
1
vote
1answer
18 views

Unable to connect to the Reporting Services instance through SSMS with windows authentication

I am trying to connect to Reporting Services instance SSRS with SSMS so that I can update some of the parameters on display of remote errors and retention of execution log statistics. I receive the ...
1
vote
1answer
32 views

Is there any special configuration for SQL Server implementing Routing List in a heterogeneous enviroment (Client and Server in different domains)?

I had implemented successfully SQL Server Routing List Feature many times... but I have a very special scenario where our Reporting Services Node is located in a different Domain than SQL Server Nodes....
1
vote
0answers
31 views

Proc For SSRS Report shows a high number of executions ExecutionLog shows low Execution count for Report

So, I am using SolarWinds DPA tool to monitor DB activity and obv do things based on that information. I found a stored procedure that is being used for a SSRS report that has a high number of ...
1
vote
0answers
22 views

After SSRS to PowerBI Reporting Server migration, parameters are rendering goofy when trying to enter data

We just successfully migrated a SSRS 2016 instance to PBIRS. Users are reporting weird behavior when trying to enter data in a multi value parameter. When they click on a parameter to enter in data, ...
1
vote
0answers
93 views

SSRS Azure SQL Database Active Directory - Universal with MFA

Does anyone know when support for Active Directory - Universal with MFA will be included in Reporting Services? It's available in SSMS. Visual Studio 2017 Data Source Properties Reporting Server ...
1
vote
0answers
45 views

SSRS default URL not being referenced from Windows application

I have installed and configured SSRS and when I check the URL via HTTP it works fine (I haven't configured SSL). When I try to run a report from the Windows application, I get the following error ...
1
vote
0answers
191 views

How to improve performance of SSRS report using Cubes as data source?

I am trying to build an SSRS report with SSAS as the data source. It has 4 cascading parameters. I used the SSRS Query designer to generate MDX because I am not very familiar with Cubes/MDX. It works ...
1
vote
1answer
126 views

SSRS Reports Blank on Zebra Printer

I need assistance getting labels to print from SSRS 2014 to a Zebra GK420D direct thermal label printer. The labels show up when running the report but when I print them to the label printer, all that ...
1
vote
0answers
27 views

SSRS Export Pop-Up Warning

I'm building a new reporting server using SSRS 2016 and have been given one specification I'm not sure is even possible. My supervisor wants a pop-up message whenever someone exports a report that ...
1
vote
0answers
50 views

How to make gauge label stretch across full width of gauge panel?

I have a gauge panel (grey) onto which I am trying to put a gauge label (green) that should stretch across the entire panel. However, when I put 100 into the Width property, it doesn't actually ...
1
vote
1answer
65 views

Averaging 2 values based on an ID in SSRS

I am hoping I might be able to get some help with a problem I am having. I am currently trying to build a report in SSRS to replace an excel spreadsheet we use for data analysis so the report can be ...
1
vote
0answers
321 views

Collation Conflict when patching SSRS

We recently upgraded our test database servers from SQL 2014 SP2 CU3 to 2014 SP2 CU10. Most of the servers are fine, but on 2 of them we are getting the following error when connecting to the ...
1
vote
1answer
214 views

Report Builder Indicator showing incorrect symbol

I have a report on which I am using about a dozen indicators as a check boxes. The data source for the report is a SharePoint list. About half of the check boxes are displaying correctly. The other ...
1
vote
1answer
52 views

Block SSRS Developers from embedding SQL Statements in Report

Is there any way I can automatically block SSRS reports with embedded SQL from accessing my Databases? I want to force a standard practice of using Stored Procedures, so the DBAs can take back ...
1
vote
0answers
189 views

Catch SqlException on SSRS report

I am trying to catch a SqlException on a SSRS report and display it on a pop-up. So far I have not been able to find this configuration on Report Builder and I thought maybe adding some code on the ...
1
vote
0answers
259 views

Patching SSRS on Always On Availability Groups

I have SSRS 2016 installed on Always On Availability Groups. I have patched my secondary servers with SQL Server patches. When I failover SSRS will not connect to the databases, it has an error ...
1
vote
0answers
116 views

CC/BCC and comments section is missing in the SSRS subscription page

We're using SSRS 2012. We tried to limit the permission level of users, and assigned them "Manage Individual subscriptions" role, instead of "Content Manager" or "Subscription Manager", however, now ...
1
vote
0answers
96 views

SSRS Scale Out Deployment URLs

I have successfully setup a scale out deployment of 2 2016 Enterprise Edition SSRS servers connecting to a single shared database. So far, I have not setup a URL for the servers (they are each using ...
1
vote
0answers
72 views

ssrs Horizontal range chart label

I'm working in ssrs 2008 R2. I need to plot the series label on the top of horizontal range bar. But the label is displayed on the left side of the bar. I tried CustomAttribute Property Label ...
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
655 views

Data driven subscription query parameters in SSRS

I am looking at customizing my data driven subscription query in SSRS so that depending on the results of the original query it will notify the correct department. For example the query returns: ID ...
1
vote
0answers
591 views

SSRS 2016 Connect to SQL Server with Force Encryption Enabled

I have 2 Windows 2012 R2 servers in different VLANs. One is an IIS app with SSRS 2016 installed and the other is running SQL Server 2016. I can successfully open the SSRS site on the app server side ...
1
vote
0answers
695 views

SSRS reports broke after upgrading from 2014 to 2016

One of my team members upgraded the SSRS and SQL servers from 2014 to 2016. Now, rather than doing an upgrade i.e. use existing databases - they uninstalled 2014 and did a fresh install of 2016 for ...
1
vote
0answers
40 views

An SQL update query works fine unless it is invoked by an SSRS subscription. Why?

A stored procedure that updates data in production data tables was written by a very talented staff member (with developer-only rights) and works fine when executed in SSMS. However, the same SP does ...
1
vote
1answer
1k views

Protecting Virtualized SSIS and SSRS servers

I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them ...
1
vote
0answers
126 views

SSRS - Embed Rich Text (including images) in report

An application my organization is developing includes a rich text editor. The content from this editor (text, tables, images, etc.) is HTML5 and is saved to the database. I'd like to find a way of ...