Tips and Tricks
 Crystal Reports Forum : Crystal Reports .NET 2003 : Tips and Tricks
Message Icon Topic: Fromat Corss Tab Field With Condition Post Reply Post New Topic
Author Message
samehsenosi
Newbie
Newbie


Joined: 06 Sep 2010
Location: Egypt
Online Status: Offline
Posts: 2
Quote samehsenosi Replybullet Topic: Fromat Corss Tab Field With Condition
    Posted: 08 Sep 2010 at 11:12pm
Hi all,

i have a cross tab that show data about some work process .
and i have in the columns filed [Date-time] field name [WorkingDay] grouped by month to show the values in cells collected by month

and in the row i put a field called branch to view whats happen in every branch by month

and in summarized fields i put 2 fields
Quantity Sold and Quantity Remaining

and i want to highlight on of the Quantity Remaining if its Value is Greater than
the Quantity Sold

to show there's a wrong sale process in this branch this month,

so ... i had used highlighting expert but it takes values not formulas
and try to use this formula but it doesn't work ...


if sum({CRPGetCapacityAllCross;1.ActiveQty},GroupName ({CRPGetCapacityAllCross;1.WorkingDay}, "Monthly"))>
sum({CRPGetCapacityAllCross;1.RemainingQTY},GroupName ({CRPGetCapacityAllCross;1.WorkingDay}, "Monthly"))then crred


any idea

thanks ...






Edited by samehsenosi - 08 Sep 2010 at 11:13pm
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 Oct 2012 at 8:06am
try goign to format editor,

and in border, check backround, and setup the formula there
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.047 seconds.