SSRS 2022 - Subscription Error when Scheduling to Run each Month on 10th 20th or 30th (Error: Invalid Days)
Unable to create/modify SSRS 2022 report subscription to run each month on the 10th, 20th or 30th. Example Schedule settings (See screenshot below): Schedule: Month Months: All months selected On calendar day(s): 20 (But is the same result if 10 or…
Create a report in SCCM to query machines without a specific software
I am needing to create a report to all machines WITHOUT Microsoft Edge installed. I am fairly novice with SCCM and not a SQL guy. I'd like to use the creation wizard in SCCM and report builder, but I get lost. Ideally we would like to be able to…
No "Run Now" button in SSRS Subscriptions
Hi, I have SSRS v13.0.5026.0 but do not have a "Run Now" button that I can use when I select a subscription in the list of subscriptions or in the individual report subscription page. There is only New Subscription, Enable, Disable and…
![](https://techprofile.blob.core.windows.net/images/_KR_hQAAAwAAAAAAAAAAAA.png?8D8440)
How to resolve this "Microsoft.ReportingServices.WmiProvider.WMIProviderException:...." error?
I keep getting this error. Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is…
SQL Server Reporting Service Web Service URL not working
I have installed SQL Server 2019 Developer edition on my Windows 11 PC. And I installed Reporting Services also. I got the report server to say it is "Report Service Status: Started". When I try to access the Web Service URL I get an HTTP…
Best Report Tools for Blazor
My company is transitioning from legacy software that makes extensive use of Crystal Reports and we are looking for a tool compatible with Blazor. Many options come up in a Google search, but we don't have enough experience with the platform to make an…
![](https://techprofile.blob.core.windows.net/images/FA0ALqN_QU6SmYMGhVsijw.png?8D97DB)
How to pass multi value parameters in SSRS for the Oracle Database using OLEDB Connection
Hi , We have created a parametrized report that has to take multiple values. Created two data sets ( One for report Data Set and the other for report paramarter dataset) Below is the screenshot for report data set where :id is the parameter. …
How to show hidden row in ssrs report
I need to show hidden row in report. How can i do it?
SQL Server Reporting Services 2019 licensing
Hello Can someone please help clarify the below for me. I know SSRS installed separately, My question is, isn´t SQL Server Reporting Service (SSRS) delivered as a part of the SQL Server Standard and Enterprise editions? Or does it require a…
Unable to install SQL Server 2022 (setup.exe). Exit code (Decimal): -2147467259.The system cannot find the path specified.
Please help me solve this error. Cant install SQL Server 2022: Unable to install SQL Server 2022 (setup.exe). Exit code (Decimal): -2147467259.The system cannot find the path specified.
Matrix's backgroud color
HI, I NEED A HELP I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K. I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX... HOW CAN I DO THIS…
Steps to use Cyber Ark to manage Data Source Credentials with on Prem Power BI report server
Hello, I am getting mixed results when trying to determine if Power BI report Server can use Cyber ARK PVWA for managing Data Source account passwords. Using PVWA enables Web application to connect to a credential managed Vault to retrieve service…
How to show "Design a new Report" in Report Viewer tool in Microsoft Visual Studio 2022. Need help ASAP.
I already search some tutorials in youtube but i cant find anything. In my machine, i cant see the "Design a new Report" in Report viewer tool like i saw in my tutorial video that i follow in youtube. i will paste pictures so you can see it. I…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
how to schedule power bi reports for email delivery?
how to schedule power bi reports for email delivery?
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Cannot connect to SQL Database. Please contact SQL server team for further support
Hi, I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database:…
Place Rounded Border in Reporting Services
I am currently using Report Builder, and I would like to know the way to place a rounded border in the corner of a table or text box Currently it can only be squared and I would like a border like this: is it possible to do this? if possible how would…
Error on report after upgrading to build 16.0.1115.92
Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). In early May…
Errors on some reports after upgrading to16.0.8886.1775 (SQLServerReportingServices_16.0.1115.92.exe dated 5/1)
After upgrading we get this error on multiple (not all) reports "The Hidden expression for the tablix 'table1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0,…
How to upgrade an eval installation of SSRS to full
I have an installation of SQL 2019 and SSRS 2019. The SSRS is an eval installation and has expired. I have the ssrs key from the installation of SQL. I have tried the modify option in Apps And Features but it is greyed out. I used the sql installation…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Setting up SQL Auth for Azure SQL DB via SSRS
Hello, I am referring the below MSFT doc : https://learn.microsoft.com/en-us/sql/reporting-services/report-data/sql-azure-connection-type-ssrs?view=sql-server-ver16 wherein confused with the below statement: SQL Database supports only SQL Server…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)