asked on

Filter out a calculated formula in group header

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:

1. Department
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!!!

Mike McCracken

What is the formula you are using?

Here is a white-paper on the multipass method
http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/204c3492-ab1e-2b10-b683-b5e8fe390d70?QuickLink=index&overridelayout=true

mlmcc

wilpitz

ASKER

The formula is a basic sum of the 2 fields:

Sum ({FDM_1.Bank Share Balance (Account)*}, {FDM_1.Primary Customer TIN})-Sum ({FDM.Bank Share Balance (Account)*}, {FDM_1.Primary Customer TIN})

Mike McCracken

In general formulas using summary fields can't be used in groups or the group selection formula.

You might be able to use conditional suppression with the formula from the Section Expert.

mlmcc

ASKER CERTIFIED SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

James0628

Hmm. I just realized that mlmcc said that that won't work (I hadn't read his last post carefully). I think I've used a group selection formula similar to that before, but I could be wrong. Maybe it won't work. You can always give it a try and see if CR complains about it.

James

Mike McCracken

If you spell it out like you suggest (don't use the formula version) then I believe it can be used.

mlmcc

Mike McCracken

See this Q
https://www.experts-exchange.com/questions/26300368/Hiding-all-contents-of-a-group-and-details-inside-based-on-group-calculated-field.html

mlmcc

James0628

Thanks for that. I was thinking that I'd done something like that, but I couldn't remember the specifics and there was always the chance that I was thinking of something else.

James

wilpitz

ASKER

That worked!!! I did not think about a formua on the group select expert! I dont know which version this feature started in but it really has been a life saver.

James0628

Glad I could help.

James