I've just found out an interesting thing about divisions in an SSRS report. Nothing fancy but you have to pay attention:
My expression is something like this:
=IIF(Parameters!ReportType.Value="UsedMerchandiseInStore",
(1.0 * Fields!inventTransCostValue_RO.Value)\(1.0 * Fields!Qty.Value),
Fields!CostPrice.Value)
I admit: i was desperate and added those * 1.0 but that didn't solved it.
Instead, i was a lucky wanderer and read Paul Miner's answer on this post:
http://arstechnica.com/civis/viewtopic.php?t=168308
This is so nice, how a few words can help over the years.
So i reiterate his suggestion, to change the "\" to "/". It seems that the former is integer division.
That did it.
Niciun comentariu:
Trimiteți un comentariu