August 9, 2019 at 2:25 pm
Hi,
I have an expression in a cell of a table in SSRS. Whenever I try the preview the report it is coming up with this error: "The Value expression for the textrun ‘Standard.Paragraphs[0].TextRuns[0]’ contains an error: [BC30471] Expression is not an array or a method, and cannot have an argument list."
My expression is this:
=EXP(-POW(Fields!Time.Value-ReportItems!Mean.Value,2)/(2*ReportItems!Var.Value))/(SQRT(2*PI()*ReportItems!Var.Value))
Can you see anything obvious that could be causing this?
August 9, 2019 at 2:49 pm
What is PI() ? I don't see it in the list of math functions. I'm on 2008 thou, maybe it was added in 2016.
--Vadim R.
August 9, 2019 at 2:54 pm
What is PI() ? I don't see it in the list of math functions. I'm on 2008 thou, maybe it was added in 2016.
Ah, that was meant to be Pi (the mathmatic number) I know it is a function in SQL so I hoped it was also in SSRS but obviously it isn't. I have swapped it with Pi to 9 decimal places and it now works 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply