Group Selection Formula 1

[tkschief]

I'm using Crystal Reports 11 and have a report grouped by number. Each group may have several charge modifiers. I'd like my report to display each group that contains a certain charge modifier (for example 123.11). I've tried using a group selection formula of {V_SSRS_CHARGE.CHARGE_MODIFIERS} in ["123.11"] but this just brings back the number that contains 123.11 and doesn't display the other charge modifiers for that group.

Example grouped by V_SSRS_CHARGE>CASE_NUM without any selection formula:
TS-2004-01514 1 aid and abet
TS-2004-01514 2
TS-2004-01514 3 123.11; aid and abet
TS-2004-01514 4 Aid and Abet
TS-2004-01514 5 Attempt

With group selection formula of {V_SSRS_CHARGE.CHARGE_MODIFIERS} in ["123.11"] I get:

TS-2004-01514 3 123.11

I am obviously doing something wrong - any help would be appreciated. Thanks!

 

[lbass]

Create a formula {@has123}:

if {V_SSRS_CHARGE.CHARGE_MODIFIERS} = "123.11" then
1

Then in the group selection area, use the following:

sum({@has123},{V_SSRS_CHARGE.CASE_NUM}) > 0

-LB

 

[tkschief]

Thanks - it works!