Forum Discussion

Super User

5 years ago

Visual Studio SSDT System.Security.Permissions.SecurityPermission

Hi, I have VS 2019 and SSDT installed local on my computer. I have an expression in the textbox, using "Floor", "Abs". When I try to preview the report on my computer, it gives "#Error" In th...

Microsoft Employee

5 years ago

There is typically a setting to allow certain types of permission for the app domain the expression is running in. This might help: https://stackoverflow.com/questions/32428/how-do-i-resolve-a-system-security-securityexception-with-custom-code-in-ssrs

sevenhills
Super User
5 years ago
Hi Bradsy,

I read the link before posting and I dont have any custom extensions. Inside the report, using ABS, Floor in an expression, in a textbox.

I am having error only my laptop (and not on the server). Even on my laptop, if use the reportbuilder, it wont give any exception i.e., it works fine. On the PBIRS server, it works fine.

Version info: Microsoft Visual Studio Professional 2019 Version 16.7.3 SQL Server Data Tools 16.0.62008.03130 SQL Server Reporting Services 15.0.19124.0 Microsoft SQL Server Reporting Services Designers Version 15.0.19124.0

I am localadmin in case this matters.

Also, on a side topic, if it is asp.net site, we can add references, this is Visual Studio, Reporting Services (SSDT) project ...

Thanks
- bradsy
  Microsoft Employee
  5 years ago
  Can you post an example of the expression I can run on local data to see if this is systemic or just your instance?
  - sevenhills
    Super User
    5 years ago
    =Floor(Abs(SUM(DateDiff("d",Fields!OUT_DT.Value,Fields!EASE_DT.Value),"DS_SA")) /Sum(Fields!S_CNT.Value, "DS_OUTCOME"))
    
    a) OUT_DT, EASE_DT are datetime
    b) S_CNT is int and has 1 or 0
    c) Getting the diff between OUT_DT, EASE_DT as positive integers i.e., ABS and then sum.
    d) sum of count
    Overall, similar to LOS type calculation ...
    
    Thank you Bradsy for looking into it.