Using the basic select expert to do this is not really feasible.
A few work arounds:
1. Write a command as your source with the more complex SQL statement instead of using tables and the select expert
2. Write a stored proc or view (or equivalent) using your complex join and use this as the source
3. Use formulas to flag your rows, use an insert summary and then remove groups using the select expert group selection
To explain # 3
First you need a group so group on Account
write a formula to 'flag' rows that are 'good'...
if C.date_of_service >= date(2010,1,1) AND C.patient_type = O AND C.code IN ("93307","93325","93320") then 1 else 0
Insert SUmmary as a SUM of this formula at the Account group level
Go into the Select Expert
Click on SHow Formula
Toggle to Group Selection
Click on Formula editor
Then insert your condition
SUM(@flag,table.Account)>0
This will remove any group that has NULL or zero rows that meet your condition
NOTE the group name will still appear in teh group tree but not in the report canvas.
HTH
Edited by DBlank - 08 Jul 2010 at 5:07am