Okay. I work at a medical practice where all visits are logged in the database and will have CPT codes attached. Sometimes a visit will only have one code, sometimes it will have multiple codes.

For visits that have one specific visit code, I want to select only those visits that also have other codes as well.

For instance if
visit number 8133 has codes 99211 and 98036
visit number 8136 only has code 99211
visit number 8140 only has code 99212

I do not want to select visit number 8136 because it only has code 99211, but I want the other two visits to be selected.

I hope that makes sense. Please feel free to ask me for more clarification. I so appreciate your help as I've been struggling with this one for weeks.

Thanks,
Melissa

group on CPT code

in group select expert try
(if CPT ="99211" then count(CPT,CPT)>1 else
1=1)

How are your SQL skills? I think the only way you're going to be able to do this is to write a Command, which is just a SQL select statement. Since I don't know your table structures, I can just give you some general logic for this:
[code]
Select distinct <all the fields you need for the report>
from <joined tables>
where <selection criteria>
and (CPT_CODE <> '99211' or
    exists (
      Select 1
      From <table with CPT codes>
      where <link to patient>
        and CPT_CODE != '99211')

Your best bet may be to start with the SQL that Crystal has already generated.

Also, DO NOT use the Select Expert to filter your data - put your filters in the Where clause of the Command. Otherwise Crystal will pull ALL of the data into memory and filter it there. If you have any parameters in your selection criteria, delete them from the main report and recreate them in the Command Editor - the Command Editor can't "see" parameters from the report.

-Dell

Thanks everyone.

I think I have a great starting point now so I will play around with it a bit and see if I can get it to work.

Thank you for mentioning that the group selection expert happens after summarizations. This is actually a report I need to use summaries for, so I will have to modify the way I am doing it.