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!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11069
Printed Date: 23 Apr 2024 at 4:34pm
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 ...
|
Replies:
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
|
|