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 | Other
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 | Other
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
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
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
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
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
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
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
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
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
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
Microsoft 365 and Office | Excel | For business | Windows

Developer technologies | Transact-SQL

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
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
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
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
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

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
"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
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