SSRS Report Viewer windows forms - The request failed with an empty response
Dear all, we use the following component in our Windows Form (.net 4.7.2 application): Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1620.0 Since we migrated our server on a new domain, we are getting sometimes the following execption in…
"Could not find the Database Engine startup handle" while trying to install SQL server 2022 Express Edition
Hello, I upgraded my computer to Windows 11 and that's why there was a problem in my SQL server. I deleted the SQL Server 2022 application and restarted the computer. Later, I encountered an error while trying to install SQL Server 2022 Express. Unable…
Wire up a shared dataset in SSRS REST API
Using the SSRS REST API , I can deploy a report from PowerShell in an automation pipeline. But how do I use the API to wire it up to our predefined Shared DataSources? The PUT Reports({Id})/DataSources endpoint doesn't seem to be for Shared…
How do I retain SSRS group expansion when an interactive sort is performed on a header?
I have a very simple SSRS report. Data is grouped, and upon initially running the report, the data is collapsed into two groups. I show totals for the group, and have the + sign to expand either. ALL GOOD. When I expand the first group, I see the…
Enterprise Report Server not showing Data Driven Subscriptions
We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…
How to share a report in SQL Server Reporting Services
I need to create a link to share a report that I created in SQL Server Reporting Services with other users. What is the best way to do this?
Creating Dataset in VS2020 using SQL query rather than visual designer
I'm creating .rdlc reports using the extension in Visual Studio 2022, but when creating Datasets, I'm only able to do using the graphical designer and cannot create or edit Datasets by writing my own SQL. What am I missing?
Critical Error for SharePoint_Config Database
Hi, I searched all forums for three days but can't find the answer. These topics won't work : Answer 1 Answer 2 Answer 3 The server returns this critical error: SQL database login for 'SharePoint_Config' on instance 'ServerSql' failed.…
How to pass multiple value for a postgres function in SSRS
I have created a report which is using postgres sql function and there are parameters for start date, end date and physician name. I am trying to pass multiple value for physician name and it is not working for me: This is how I am calling the function…
Power BI Reporting Server on Standard DB Engine
Is it possible for the .pbix files to work correctly when the Power BI reporting server (PBIRS) is installed on a Standard DB Engine? According to the below link, it looks contradictory as while it states that Standard edition is possible, it also…
Performance Monitoring tools used for 4 hrs
Using Performance Monitoring tool to check on the performance of the database server. I cannot extend the duration to more than 1000 secs. What are the other options for performance monitoring so that I can get the data for 4 hrs
unable to connect to our reports from ssrs
We are unable to connect to our Microsoft 2019 reporting server reports after installing certificate. I have try connect with with these option: http://ip/reports http://servername/reports I was also altered rsrepotsser.config file to get things…
How to set title of pdf in report builder
We have an issue with PDF files generated by SSRS for reports created in Report Builder. The files have weird looking names/titles when opened with the built-in PDF viewer in Chrome etc. Some searching returned a thread saying that Chrome displays the…
SSRS - Unable access the Report Server Web portal URL's
We have SQL Server Reporting Services. Nothing has been changed but users are not able to access to Reports Web URL. We are unable to access the URL on the same machine where the Report Server Configuration Manager is running. Checked the SQL connection…
Sql server reporting issue on save and print the data
Hi Team, customer facing weired issue on reporting url that is customer can't save and print the output but customer can able to pull the data. I verified with customer for any errors but I don't see any…
SSRS is restricting excel report to 35 tabs.
SSRS is restricting excel report to 35 tabs (pages). Workingsetmaximum is set to 8 GB. Is there some setting that i can change so that the number of pages is not restricted?
Preview Error Adding Extension Assembly to SSRS RDL Report in VS2022
I am using Visual Studio 2022 with the Microsoft Reporting Services Projects extension. I've created a Reporting Services project and added a simple report. In this report, I included a textbox with the expression =User!Language and successfully…
Is it possible to disable wrap text in SsRs
I have a Ssrs report and I want to download the Ssrs data on excel but the text in any column should not be wrap. Means the text should be visible in a single line.
SQL Server Reporting Services is spewing logs - This may be due to a connection failure, timeout or low disk condition within the database.
On SQL Server Reporting Services, all of a sudden logs are full of : library!WindowsService_0!16e4!04/16/2024-13:52:26:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the…