SSRS value not reflecting what is in the DB/DataSet

0
votes

I have a situation in an SSRS Report wherein the report is not reflecting what is in the data.

The field in question is company-paid Long Term Disability. The value is calculated in a Stored Procedure as 0.0018 of a person's Gross Wages. The Stored Procedure is run by the report and it populates a table with the data the report will use. The report, then, does a straight "select" of values from that pre-populated table.

Let's use a concrete example:

  • Tom Thumb has a LTD value in the DataSet of 86.3077. I'm looking at it as I type this, so I know that is the value in the source data.
  • Next, I run the query in SSRS Report Designer that populates my report's DataSet, and I see the same value of 86.3077 for the field LTDInsurance. That's the correct value. So far, so good.

  • In the Design View, I can drag the field [LTDInsurance] into the textfield of the report, or I can use an expression. Neither approach works correctly.

    =Fields!LTDInsurance.Value

  • Formatting on the field is #,##0

When I run the report, the value in that field shows 8,631 instead of 86 (Rounded 86.31). I have deleted and recreated the field. I've closed and reopened Visual Studio (VS 2010 can go wonky on you at times.). I've rebooted. I have tried a whole variety of Properties on that textfield.

Why is it showing this incorrect value?

1
reporting-services

1 Answers

1
votes

Delete the data file (rdl.data) from the folder your rdl is in