Tips and Tricks
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Tips and Tricks
Message Icon Topic: Formatting data Post Reply Post New Topic
Author Message

Joined: 07 Jan 2010
Online Status: Offline
Posts: 1
Quote indri Replybullet Topic: Formatting data
    Posted: 07 Jan 2010 at 5:47pm

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 Confused
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

Anyone have any ideas about this?

Thanks Smile

Edited by indri - 07 Jan 2010 at 5:48pm
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.