Post reply

Very high numbers show up as #Error's

  • April 11, 2011 at 2:57 pm

    #237593

    =(SUM(Fields!Missing.Value) +

    SUM(Fields!Submitted.Value) +

    SUM(Fields!Killed.Value) +

    SUM(Fields!Changed.Value) +

    SUM(Fields!Kill_Pending.Value) +

    SUM(Fields!Change_Pending.Value) +

    SUM(Fields!Processed.Value))

    I have this expression in my SSRS report. If the sum is more than 300,000 then it displays as #Error. If it is around 10,000 it displays the number. Very high numbers show up as #Error's. Why is that so. I tried to use cstr, formatstring,customnumber formatting but nothing worked. Whats wrong with my SSRS.

  • April 11, 2011 at 6:53 pm

    #1310177

    I'm stumped, I've never encountered this, and I've shown numbers up to hundreds of millions.

    I think the way to deal with it is through elimination.

    - Run the query in SSMS and see if there's anything odd in one of those fields.

    - Make SSMS do the SUM and see what it comes up with.

    - Back in SSRS remove any formatting from the textbox, and make a new expression with a single SUM field, then add the SUMs back in one by one until it goes awry.

    Post back when you find what happened.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply