I have a crystal report that I am trying to see accounts that have balance changes from one date to another date by the Tax ID. On this report I have 4 group levels:
2. Account Type
3. Tax ID
4. Account Number
I have the 1st balance and 2nd balance totals for the Tax ID on GH3 and a formula called @Tim Growth that will calculate the balance change between the totals. I want to now somehow filter the @Tin Growth for the records that are over $100,000 but due to Crystal I cant see this field in the record Expert or group Expert.
I know from reading books that crystal is multi pass and I think this is why I cant get this to work but I am fuzzy on the multi pass process.
Any help would be great!!!