What can be the reason that Crystal Reports Engine sometimes thinks that a field, that is returned from some stored procedure, that is in fact is of type money, is a varchar 255? Because of that I cannot apply any number formatting.
views:
38answers:
1
+3
A:
Are you sure you have the field cast as money? Did you change the datatype recently, and not select Verify Database in Crystal Reports afterwards? If so, it could just be Crystal Reports being difficult; I've seen it do strange things from time to time with no real expalantion why.
That said, you could always create a Formula Field that contains:
ToNumber({YourTable.YourField})
You can then show this formula field on your report, and apply number formatting to the field. I know it's not the best answer, but it's a viable workaround.
LittleBobbyTables
2010-09-13 14:24:33
Yup, I forgot to cast the result field :) The field that I expected to be money data type was in fact nvarchar(500). Thanks )))
Azat
2010-09-13 14:41:53