Hi

I'm trying to use a cross tab.


My data is looks like this:

Customer      Item      Type     Value
-----------------------------------------------
Customer1    ItemA    Qty       5.00
Customer1    ItemA    Amt      12.50
Customer1    ItemB    Qty       3.00
Customer1    ItemB    Amt      6.00
Customer2    ItemA    Qty       4.00
Customer2    ItemA    Amt      10.00


I've got my cross tab looks like this
                        ItemA              ItemB
                     Qty    Amt        Qty    Amt 
Customer1    5.00  12.50     3.00   6.00
Customer2    4.00  10.00     0.00   0.00


So the Column header will be the item list, and every item I have 2 type (one for Qty and one for Amt)

My issue here is i want to show Qty field without decimal point. I already try to do on the formatting screen, but it's not working
I also try the formatting on the normal view (not using cross tab, and it's working).

Format condition for decimal point:

if {DailySummaryRep.TransType} = "Amt" then
2
else
0


Anyone have any ideas about this?

Thanks


Edited by indri - 07 Jan 2010 at 5:48pm