I created a BAQ that has a Calculated_Amount. In SSRS I try to Sum it and it gives me an error. Ideas on why?
What’s the error?
It just says Error when I run it on the print out and in the SSRS designer. But IA m not sure waht the Error is referring too. Nor do I know how to track that down.
Oh - the output is #ERROR on the report.
Could be a bunch of things. Try listing out the values in a table and see if anything stands out. Also, check to make sure that the number is actually a number in the dataset and not a string posing as a number.
2 Likes
I keep forgetting to double check the strings vs int on old BAQ’s I created from when i first started. Thanks for the reminder!