Originally posted by Pat Phelan
Assuming that "A" comes before "B" in the sort/group order, then you should just be able to work off of the "A" line numbers. I think that I'm missing something, but I'm not sure what that might be...
I'm sure I didn't describe it as well as i could have.
To be specific, column A is slot machine denomination, column B is the slot machine Type. There are 2058 machines total. Of the 2058, there are over 300 specific Types of machines (column B).
I use a group footer to summarize each type. The report is viewed with the details hidden.
I am using the 'if (remainder(GroupNumber,10)=0) then Silver else NoColor' statement in the Format Formula Editor for the group footer.
This highlights every 10th group footer. I need to restart the count each time the Denomination (column A) changes, but I can't seem to create another group footer by that field without losing all my Types.
I don't know if that helps. I'm a self-tought novice in Crystal. Guess I should take a class .
It has been AGES since I've used Crystal Reports, and of course I don't have any easy access to the documentation, but there is a way to find what you want. Each of the groups (in your case denomination and machine type) should have separate group counters. When a high-order group (denomination) changes, all lower group GroupNumber values should reset to 1. I'm not certain, but I think that Crystal is already doing what you want even if you don't realize it.