Print Page | Close Window

Fromat Corss Tab Field With Condition

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
Printed Date: 13 Aug 2020 at 3:45pm

Topic: Fromat Corss Tab Field With Condition
Posted By: samehsenosi
Subject: Fromat Corss Tab Field With Condition
Date 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 ...

Posted By: comatt1
Date Posted: 25 Oct 2012 at 8:06am
try goign to format editor,

and in border, check backround, and setup the formula there

Print Page | Close Window