topic Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission in Report Server

Visual Studio SSDT System.Security.Permissions.SecurityPermission

sevenhills — Thu, 17 Sep 2020 17:07:17 GMT

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 the Visual Studio, window: error list, it shows as

[rsRuntimeErrorInExpression] The Value expression for the textrun 'Textbox133.Paragraphs[0].TextRuns[1]' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Note: When I publish this to PBIRS, report works fine. only shows error on my computer's visual studio / ssdt. Also, works on Report Builder when I open ...

Any idea? Thanks

Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission

sevenhills — Thu, 17 Sep 2020 17:06:54 GMT

I submitted the same here also , but seeking help here also

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio&ssr=false#qna

Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission

bradsy — Thu, 17 Sep 2020 17:32:13 GMT

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

Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission

sevenhills — Thu, 17 Sep 2020 18:48:27 GMT

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

Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission

bradsy — Thu, 17 Sep 2020 22:40:26 GMT

Can you post an example of the expression I can run on local data to see if this is systemic or just your instance?

Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission

sevenhills — Fri, 18 Sep 2020 00:27:52 GMT

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

Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission

bradsy — Tue, 22 Sep 2020 19:06:47 GMT

Hi SevenHills,

I could reproduce sporadically. With one dataset, seemed to always work. With 2, I would get the error usually after the first preview. My guess is a threading issue with the preview host. I filed a defect to track the problem, but I don't expect any action unless more customer hit the issue. I don't really have a good workaround, other then trying in Report Builder\SSRS to preview.

Thanks for finding the problem!

Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission

sevenhills — Wed, 23 Sep 2020 00:23:57 GMT

Thank you for your prompt follow-up. Hopefully one day it will get fixed. 🙂

(I submitted here also, FYI ... https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio&ssr=false#qna )

Re: Visual Studio SSDT System.Security.Permissions.SecurityPermission

sevenhills — Wed, 30 Dec 2020 01:56:14 GMT

Today, I encountered one more error

Works: COUNTROWS("DataSet1_WithTextOrNumber")

Works: COUNTROWS("DataSet1_WithOnlyOneDateColumn")

Works: COUNTROWS("DataSet1")

Works: Parameters!FirstDate.Count

Works: JOIN(Parameters!FirstDate.Value," & ")

NOT Works:

a. Select SQL_Col_Date from table1 (Only one date column)

b. Add one more calculated field in report dataset as =Format(Fields!SQL_Col_Date.Value,"Short date")

c. using COUNTROWS("DataSet1_WithOnlyOneDateColumn_CalcColumn") inside an expression ... gives error!

= IIF(COUNTROWS("DataSet1").Equals(Parameters!FirstDate.Count)
,"All",JOIN(Parameters!FirstDate.Value," & "))

[SQL Server as datasource]. Hope microsoft will look into it!

Thanks