Error on report after upgrading to build 16.0.1115.92

Question

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 2024 we upgraded SSRS from 16.0.1115.61 (2024-01-23) to 16.0.1115.92 (2024-05-01) and one report started failing with below error:

The Hidden expression for the tablix 'Details1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (rsProcessingError).

Any help will be much appreciated. Thank you.

Answer 1

UPDATE: Version 16.0.1115.96 (May 20, 2024) seems to have fixed the issue.

Answer 2

@Olaf Helper , apparently others ran into the same issue:
https://learn.microsoft.com/en-us/answers/questions/1689415/errors-on-some-reports-after-upgrading-to16-0-8886 which was introduced by latest upgrade(or update in your terms).

Below expression was causing the error:

=IIF(Fields!COL1.Value = Previous(Fields!COL1.Value), True, False)

The expression was supposed to collapse dataset, so I removed the expression and instead reworked dataset on database side (T-SQL )so that it returns already collapsed dataset. After that the error was gone. The report was running without a hitch for years until said update was applied.