Error on report after upgrading to build 16.0.1115.92

Alex M 10 Reputation points
2024-06-04T18:20:06.8033333+00:00

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.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,854 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Alex M 10 Reputation points
    2024-06-05T18:57:40.93+00:00

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

    1 person found this answer helpful.

  2. Alex M 10 Reputation points
    2024-06-04T18:40:13.2566667+00:00

    @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.