SSRS 2019 Subscription Email Bug. Email Priority setting defaults to "Normal" after saving subscriptions as "Low" and "High" priority.
Hello, I seem to be experiencing a bug when creating an email subscription in SSRS 2019. When I set the email priority to "Low" or "High" and Save, I do indeed receive an email marked as either Low or High priority. The issue occurs…
Stored Procedure from Redshift to Report builder
Am trying to call a stored procedure from AWS Redshift DB to Report builder. But not able to execute the stored procedure when i give the procedure name under stored procedure section in report builder. Let me know how to achieve this.
VS Version 17.11.5 - SSRS report RDLs open BLANK
Hello, Version 17.11.5 - SSRS report RDLs open BLANK I have submitted this from VS but have not received any help. It gets set to Triaged or marked as a duplicate and I have not heard back. I am a tad surprised this is not a widespread issue because…
SSRS upgrade in place 2016 to 2019
I am upgrading in-place, same server, the SQL Server DBMS that supports a third party product that uses SSRS with reports created also. This upgrade is from 2016 to 2019 and warns that reporting services will be uninstalled. I will add that warning…
SSRS interactive sorting - "sort by" dropdown and fx button missing
R-click on Column Header (Priority) Choose Text Box Properties Choose Interactive Sorting Sort By: There is no dropdown and I cannot see the “fx” button – even if I expand the box as far as it will go. I managed to type in an expression but cannot amend…
SSRS email basic authentication replacement
Hi, For sending emails from our SSRS environment we currently use basic authentication to connect SSRS to our Office 365 environment, with this being deprecated in the coming months does anyone have the new settings that will be needed to allow us…
Cannot initialize report- SCOM 2022 UR6, SSRSv16.0.8564.33454
Everything worked until a week ago. No changes made to system. These reports were working fine, so well that I created Scheduled Reports for a few of our customers. I have since disabled/removed them. Reports with issues: Reporting\Microsoft Generic…
when i run SQL server assessment using MAP toolkit on my Azure VM it unable to capture SSRS instance, It can caputre all database details but not SSRS instance. Also i do assesement for 1 system and it shows me inventored 2 machines? plz help
when i run SQL server assessment using MAP toolkit on my Azure VM it unable to capture SSRS instance, It can capture all database details but not SSRS instance. Also i do assessment for 1 system and it shows me inventoried 2 machines? don't understand…
How to fix my shared datasource when I cannot find it?
My shared datasource was set up before I began to work with SSRS. I have reports that run well except when I change them in production they do not accept the current shared datasource any more. What do I do to fix this so I can modify a SSRS report in…
SSRS encryption key issue.
Ive done the deal to move SSRS to a new server. This server serves as both the new SSRS install as well as having SQL installed and houses the SSRS metadata DB's. It should be noted that both SSRS and SQL run under a different service account on the new…
report server service management pages not showing
I'm trying to get SSRS installed. Everything appears to be working, but I cannot browse to the Web Service URL. By contrast, I can access the Web Portal URL (though there are no reports published currently). Am I missing a setting?
Access to the User Computers - SQL Server 2022 Reporting Services (va.gov)
Hello I have a new employee that need access to the SQL Server Reporting Service. She is part of Desktop Support Tier 2
SSRS Atomsvc connection giving 500 error, The size parameter must be between zero and the maximum Int32 value.
I am getting the following error when trying to connect excel to an ATOMSVC file for SSRS. library!ReportServer_0-3!8a54!10/07/2024-08:45:58:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException:…
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607;Error description: could not find the database engine startup handle
I am trying to install sql server 2022 and I keep getting the same error: Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607;Error description: could not find the database engine startup handle This is the error log that I…
CSP header
We are using SSRS via the standard Web Portal URL. The security department is particular about the CSP header. What is the minimum CSP SSRS Web Portal needs to have? Can we remove 'unsafe-inline' 'unsafe-eval' from the CSP header?
rdlc files donot compile or validate in VS 2022
I am trying to upgrade and compile a project in VS 2022 with some rdlc files, it does not show any errors when we try to build or rebuild. It was working on VS2013 before. It showed any compile errors in the files and does not complete the build until…
SSRS report are getting stuck in executing mode
Hi Team, SSRS reports in Microsoft Dynamics AX 2012 are frequently becoming stuck in execution mode. This issue occurs across all reports, not just specific ones. To resolve this, we must manually stop and restart the SSRS Reporting Service on the report…
I have installed Microsoft SQL Server 2022, but I cannot see the SSIS & SSAS packages.
Good day! When I installed SQL Server, I remember having ticked the options that asked me whether I wanted to include SSAS, SSIS & SSRS; I ticked them all since I wanted to have a many features as I possibly could. Now, am studying the book below: I…
Problems during installation of the reporting role in Configuration Manager
Greetings I'm having a problem installing the reporting role SCCM installed on server A SQL and Report service install in Server B But when I start configuring the role, it doesn't show me the name of my reporting role database I read several articles…
In SQL Server Reporting Services how do I add comments to a dataset query?
I am creating a report in SQL Server Reporting Services in Visual Studios 2019. When creating a query within the dataset properties, how do I add a comment line?