3,072 questions with SQL Server Reporting Services tags

Sort by: Updated
1 answer

SSRS CSV export issue

I have a SSRS report with dynamic column and also Column display order is getting handle through parameter "ColumnOrder". Once I generate the report it works fine and based on column order it display columns on report. Once I export it to CSV…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
SQL Server | Other
asked 2023-08-25T13:16:20.0366667+00:00
Arvind Singh Gusain 5 Reputation points
commented 2025-08-05T13:29:53.6333333+00:00
San Panico 0 Reputation points
7 answers

How to download Sql Server Configuration Manager

Hello, BRAND NEW to SQL Server. I was following along with a tutorial and downloaded the SSMS, however, doesn't seem like i have the configuration manager installed properly. I tried entering the credentials first prompted once SSMS was done…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
SQL Server | Other
asked 2022-09-25T07:02:10.793+00:00
Zach Hadjah 26 Reputation points
commented 2025-08-04T19:27:19.6766667+00:00
Valtimwoke 0 Reputation points
1 answer

My company already has access to a third-party SQL server that we currently access via ODBC. How much will it cost to use SMSS and SSRS to access the same server?

My company already has access to a third-party SQL server that we currently access via ODBC. How much will it cost to use SMSS and SSRS to access the same server?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-08-04T15:08:51.5733333+00:00
D H 0 Reputation points
edited an answer 2025-08-04T16:37:43.65+00:00
Bruce (SqlWork.com) 79,101 Reputation points Volunteer Moderator
1 answer

SSRS WriteLockSession holding open transactions

Good morning, We are noticing that on our SQL 2016 SSRS box that we are periodically having some transactions which sit open indefinitely. It appears that the WriteLockSession is opening, but not closing. (See above image). This doesnt…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2021-01-28T11:39:15.237+00:00
32505975 41 Reputation points
commented 2025-07-30T19:06:37.6266667+00:00
Hinz, Michael M 0 Reputation points
1 answer One of the answers was accepted by the question author.

trusted certificate

I have installed sql server from Microsoft but when I try to connect the Management Studio I get an error message saying that my certificate is not from a trusted source. I do not understand - is it saying that Microsoft doesn't trust itself? I'm…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-28T17:15:07.1166667+00:00
Christopher Tankard 20 Reputation points
commented 2025-07-30T06:08:10.7033333+00:00
Christopher Tankard 20 Reputation points
1 answer One of the answers was accepted by the question author.

SSRS report - gauge that looks like donut

I need to create a gauge that looks like this: Any idea how to add actual data to it? I have one row with 4 columns with numeric values. I want it act as a donut chart but wuth text in the center. Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2021-07-17T22:41:17.413+00:00
mark goldin 696 Reputation points
commented 2025-07-28T03:13:15.28+00:00
Arganaraz, Jorge (AU) 0 Reputation points
2 answers

PowerBI - Unable to configure https

SQL Server 2019 on Windows Core 2019 New PowerBI installation No current SSL or port 443 users However, when I try to configure HTTPS in the Report Server Configuration Manager, I get the error: Also not sure why the "url was unexpectedly…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2022-01-13T08:54:14.677+00:00
Peter Bishop 181 Reputation points
answered 2025-07-27T10:40:12.2866667+00:00
Sureshkumar P 0 Reputation points
1 answer

SSRS Reporting Issues--can't change credentials and reports asking for more information to run than before

Hello, A issue we have encountered is that in report builder I can successfully add and connect to a datasource, but I can't add a dataset from it, it says incorrect login. I did notice that the credentials settings in the datasource do not match what…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-25T16:29:40.76+00:00
Jessica Allison 0 Reputation points
answered 2025-07-25T20:19:02.0366667+00:00
Jessica Allison 0 Reputation points
0 answers

SSRS connection pooling between SSRS app and ReportServer database instance

We have an interesting issue. To keep things simple, we have a dedicated database server for the SSRS ReportServer database (SQL Server 2017) and two servers running the SSRS app. No other databases reside on this instance. A while back there were…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-24T14:50:19.04+00:00
Mike Clark 0 Reputation points
13 answers

Try to sending email not working with suscription in Reporting Services

Try to sending email not working with suscription in Reporting Services, the error is : emailextension!WindowsService_29!475c!12/20/2021-07:00:08:: e ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. --->…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2021-12-20T18:02:10.847+00:00
Amin 1 Reputation point
commented 2025-07-24T11:18:54.59+00:00
James 0 Reputation points
0 answers

Inquiry About Performance Impact of PBIRS Scale-Out on Scheduled Data Refresh

Hi, We currently have a large number of Power BI reports published on our on-premises Power BI Report Server. We've observed that many of these reports take a long time to refresh their data during scheduled refreshes triggered from the report server…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-23T10:40:21.2+00:00
Omar Basheer Omar Kamal 0 Reputation points
8 answers One of the answers was accepted by the question author.

Pull values to the Left of a dash

I am trying to pull from a field called "Location" that includes a number of varying lengths after a dash. I only want to pull the value of the field before the dash. My expression below worked with the LTRIM to pull values after the dash but…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
Microsoft 365 and Office | Excel | For business | Windows
Developer technologies | Transact-SQL
asked 2021-05-25T02:32:50.59+00:00
Evan Stroum 21 Reputation points
answered 2025-07-22T04:16:29.9233333+00:00
Ashish Mathur 99,575 Reputation points Volunteer Moderator
2 answers

TF400981: Failed to backup the Reporting Services encryption key.

TF400981: Failed to backup the Reporting Services encryption key. You can try using RSKEYMGMT command to backup the encryption key Completed Verify Backup Encryption Key Operation: Warning

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2022-10-17T11:07:33.09+00:00
Pratik Makwana 1 Reputation point
edited an answer 2025-07-08T05:34:24.4266667+00:00
Pedro Romero 0 Reputation points
2 answers

How to download and install a specific version of report builder?

keep trying to open the report builder from the NAV development environment but I keep getting an error stating that the supported version could not be found. Note that I have the latest version of the report builder (Version 15.0.20073.0).

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2023-09-11T10:38:43.9066667+00:00
Erick Thamara 0 Reputation points
commented 2025-07-01T05:11:24.6833333+00:00
Stefan Kleinhans 0 Reputation points
1 answer

Handling of very long strings

Hi! We are trying to include a (sometimes) very long string into our reports, rendered with SRSS. Due to the nomenclative background of it (ISCN), the string does not contain a lot of spaces, where breaks are able to occur. There are however places we…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-01T13:28:53.6066667+00:00
Visayas 0 Reputation points
commented 2025-07-04T10:05:42.07+00:00
Visayas 0 Reputation points
2 answers

How can I implement impersonation on SSRS without prompting the normal user.

How can I implement impersonation (i.e. domain/user) across a domain for all users to use without prompting for user name and password SSRS. I have been trying to modify the configuration files without success. Besides the security risks please can…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-02T13:42:15.1733333+00:00
Mark Askins 0 Reputation points
answered 2025-07-07T08:16:02.0666667+00:00
Adelle zieme 0 Reputation points
1 answer

Microsoft Report Builder UI Issue

Greetings! I would like to ask about the UI issue that I am facing for Microsoft Report Builder. The fields are not aligned. Seems like I have a UI issue. I have already uninstall and install it back. Currently running Version…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-07T08:48:37.1033333+00:00
Ammar Ibrahim 5 Reputation points
answered 2025-07-07T10:58:25.38+00:00
Olaf Helper 47,541 Reputation points
0 answers

ReportViewer WebForms breaks when certain cultures are used in reports with datetime filtering

We've recently upgraded from standalone Report Viewer 2015 runtime to the NuGet package in our ASP.NET webapp (.NET Framework 4.7.2): https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/ The issue is that using…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-08T12:42:00.13+00:00
MrG 0 Reputation points
edited the question 2025-07-11T13:33:47.2933333+00:00
MrG 0 Reputation points
1 answer

"Failed to Authenticate User by External Browser" error when accessing SSRS (SQL Server Reporting Services)

Trying to connect from SSRS to Snowflake via ODBC -> DSN I have setup the ODBC System DSN via EXTERNALBROWSER on SSRS report server From ReportBuilder able to connect to Snowflake via ODBC and preview the report (popup window appears for SSO…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-09T07:32:20.7866667+00:00
satish krishnamurthy 1 Reputation point
answered 2025-07-18T08:16:07.55+00:00
Ajith G (APTLY TECHNOLOGY CORPORATION) 0 Reputation points Microsoft External Staff
0 answers

How to delete subscriptions in PowerBI RS

Hello, I have a user which has lot of subscription in PowerBI Report server. I want to delete all the subscriptions associate with this user. Please let me know how can i do it? Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,072 questions
asked 2025-07-15T06:59:58.66+00:00
Bilal H. Bhatt 136 Reputation points