Group Selection Formula

[tkschief]

Hi,

I don't know how to write a group selection formula with 2 sets of criteria. Here's my situation:

1. Report is grouped by Command.case_number.
2. 60911True formula: If {Command.IS_60911_APPLICABLE}= True then 1 else 0;
3. Current Group Selection formula: sum({@60911True}, {Command.CASE_NUM}) >0
4. DispoDate formula: If {Command.DISPO_DATE} in DateTime (2009, 07, 01, 00, 00, 00) to DateTime (2010, 07, 01, 00, 00, 00) then 1 else 0
5. Need to add to current group selection formula: sum({@DispoDate}, {Command.CASE_NUM}) >0

The group selection formula should display the groups where @60911True and @DispoDate are greater than 0. Or should I be doing this differently?

If you need additional information please let me know. I'm using CR 11. Thanks for your help!

 

[lbass]

You should be able to just connect the two statements with an "and". However, this would just mean that at each criterion is met at least once in the group, but not that they are necessarily the same record. If you need to see groups where at least one record meets BOTH criteria, then have your base formula test for both:

If {Command.IS_60911_APPLICABLE}= True and
{Command.DISPO_DATE} in DateTime (2009, 07, 01, 00, 00, 00) to DateTime (2010, 07, 01, 00, 00, 00) then 1

...and then use the sum of this in your group selection formula.

-LB