Selection criteria question

[RobbOrt]

I am using CRXI pulling data from MSSQL2005.

I am joining 2 tables (TPABLS & CLASSES) joined on their Key.
Using the parameter: {?Date Range}
The Select Expert:
@Date_Paid = {?Date Range} start & end
,TPABLS.voidcode (is not one of) D,V
,CLASSES.clocode (is equal to) C

Printed on report:
C.Control_nbr
T.bus_name
T.comp_addr
C.class
C.descript
C.amtoftax

Here is my problem???
Each business have a distinct C.Control_nbr can have multiple Classes (each with their own distinct Description).
If I do not set Select_Expert with a class, I get them all within that date range (good data) but not as narrowed as I require.
I need only the data for businesses that have collected payments for Class 011111, but heres the kicker - associated with this payment should also be Class 993000 (admin_fee), some may have been forgotten in error and do not have this Class payment collected.
SO... If I add the Select_Expert:
CLASSES.class = "011111" I get only the data with this class.
CLASSES.class = "011111"+"993000" I get all the admin_fee colected from all the other classes as well.

What I need to get is:

CONTROL# BUSN_NAME CLASS DESCRIPTION AMOUNT
123456 BAC Home Loans 011111 Forclosure fee $115.00
12 Palm Ave 993000 Admin fee $ 10.00
Total $125.00

235986 Scotts Mortgage 011111 Forclosure fee $115.00
3512 Smith St. Total $115.00

536894 5/3rd Bank 011111 Forclosure fee $115.00
no local addres 993000 Admin fee $ 10.00
Total $125.00

689542 AmScott 011111 Forclosure fee $115.00
36985 Elm St 993000 Admin fee $ 10.00
Total $125.00

NOT:

CONTROL# BUSN_NAME CLASS DESCRIPTION AMOUNT
002365 General Store 993000 Admin fee $10.00
996 A st.
Total $10.00

123456 BAC Home Loans 011111 Forclosure fee $115.00
12 Palm Ave 993000 Admin fee $ 10.00
Total $125.00

235986 Scotts Mortgage 011111 Forclosure fee $115.00
3512 Smith St.
Total $115.00

536894 5/3rd Bank 011111 Forclosure fee $115.00
no local address 993000 Admin fee $ 10.00
Total $125.00

556369 Dr.Smith 993000 Admin fee $ 10.00
5555 12th st.
Total $ 10.00

689542 AmScott 011111 Forclosure fee $115.00
36985 Elm St 993000 Admin fee $ 10.00
Total $125.00

698356 Corner Bar 993000 Admin fee $ 10.00
1 your st.
Total $ 10.00

778596 Bobs Business 993000 Admin fee $ 10.00
33 His st.
Total $ 10.00


**** SEE ATTACHED ****
So, I need help either in the Select_Expert or creating a Formula_field that can select on CLASSES.class where CLASSES.class in ("011111" + "993000") or ("011111").

Thank you in advance...

 

[lbass]

Use a record selection formula like this:

{CLASSES.class} in ["011111","993000"]

Insert a group on {table.control#} and then to go to report->selection formula->GROUP and add:

minimum({CLASSES.class},{table.control#}) = "011111"

-LB