miercuri, 27 aprilie 2016

SSRS report - division issue

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