SQL Server Reporting Services

Highlight cell or row in SSRS Tablix

Hello, I have a Tablix with multiple temperatures values for a patient taken in a day. Was wondering if I can highlight the row/cell with the highest temperature, in this case 101.5 Let me know if this can achieve via expression. Thanks, Ali.

Upgrading SQL Server having multiple instances

Our SQL is of 2014 RTM. Planned to upgrade it to 2014 SP3 in the first place later to 2022. And our SQL Server do have extra 2 instances as being used for replication DBs. I saw rolling upgrade as solution to HA environment. But nowhere could I see…

Need to filter data in Tablix

I have created a tablix where I need to filter the data, I have used the following expression in the Tablix properties and I am not getting the expected results   IIf(IsNothing(field1.Value) OR IsNothing(field2.Value), 1, 0) The above formula is…

Finding SQL Server 2022 Web Edition License Key for SSRS

I am presently licensing SQL Server 2022 Web Edition on an SPLA license on a hosted cloud server. The hosting partner does not presently offer a cloud server image for SQL Server 2022 which includes Reporting Services. I understand that a SSRS license…

Hey team, I am using uaa login url for custom authentication while accessing web reports.

The problem is that when I am using windows authentication, I am able to see the cookie for the ServiceState API, but if I configure it to use the custom authentication which is by using uaa as mode of authentication mechanism I am not able to see the…

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…

SRSS REST API get the content of the Report

Hello, I am new to SRSS and we were introduced REST API being available. I am confused about the swagger/OpenAPI document with regards to this endpoint /Reports({{Id}})/Content/$value Here are my questions: What does this return? Is this the content…

Issue installing MSSql server on Ubuntu 22.04

While trying to install mssql server on my Ubuntu VPS following Microsoft documentation, i'm encountering error 504 running the command below. root@eloquent-engelbart:~# curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list…

SSRS: Subscription

I'm working on configuring the the Microsoft Subscription. I cannot seem to find the error. I found errors 37 and 42. 2024-06-06 10:04:26.3373|ERROR|54|OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown…

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

No Rows Message in Report Builder is not turning Red color in exported .pdf file

Hi All, I have developed on main report which contains many subreports in Report Builder. I have set the No Rows Message in Main report as well as Sub Report. No Rows message color made to Red Color. But problem is that, While run the main report and…

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?

Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 100009. Maximum rows: 65536

Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 100009. Maximum rows: 65536

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…

How do I hide subreport option from the Reportin g Services screen?

I am a SSRS newbie, so pardon simple questions. I created two main reports. One report has hidden reports within. The other report has sub-reports. When I deployed the programs to Reporting Services, the sub-reports appear as selection options. How do I…

SSRS UnhandledReportRenderingException

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). When we…

Create Dynamic Rows based on column data

New SSRS and need to find a way to add rows to a matrix based on a number of a column and input specific item based on the qty. The first table is dynamic based on the backend dataset values. For example, the first line in the top table has "3"…

SSRS Error: Object reference not set to an instance of an object

Hi Guys I'm stablishing SQL Server 2019 with SSRS, I'm new in this. As I installed report server, I opened the Report Server Configuration Manager, and I applied the default setting which seemed ok. The SQL Server Reporting Services is up and running…

Unable to install SQL server

Adding Rectangle to Table Cell to prevent Indicator Stretching Cause Filtering Problem

Hi, Unfortunately, I found myself having to use Microsoft product (SSRS) that seems to be in freeze mode in terms of development , bug fixes and enhancements to find myself facing a bug that fits criteria of what to expect out of Microsoft. My issue I…