OK, shared variables are just the most useful thing in Crystal, I use them all the time.
In the formula to strip off the 001/002 (I am assuming that this states if it is the first estimate or one of the 'other') at the top add a line:
Shared BooleanVar bVisible := false; //since it is always false except
Where you are stripping off the ending, check if it is 001, then set the flag, something like:
if mid({field}, instr({field}, "/"))="/001" then
bVisible := true;
Then in your suppression formula add at the top:
Shared BooleanVar bVisible;
and add onto the end formula 'or bVisible = false' or whatever logic is needed.
But something like that. This can of course to be modified to look at a value, if that is needed, I would 'create' my own running total in formulae and reference the amount in the record vs my variable. Once you get used to shared variable, there is so much that you can do in a report.
Hope this helps
IP Logged
