Formatting data
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8833
Printed Date: 25 Apr 2024 at 7:33pm
Topic: Formatting data
Posted By: indri
Subject: Formatting data
Date Posted: 07 Jan 2010 at 5:47pm
|
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  |