Forum Discussion

sevenhills's avatar
sevenhills
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...
Report
SSDT
Visual Studio
sevenhills's avatar
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's avatar
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's avatar
    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. 

     

     

    • bradsy's avatar
      bradsy
      Microsoft Employee
      5 years ago

      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!