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
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!