Hello,

I have a simple report pulling data from two tables. I want only distinct records. I am selecting records based on parameters; here is the select formula:

({?Service Name} = "*" or {selsvc.ServiceName} like {?Service Name})and
({?Program Name} = "*" or {selsvc.Selected Service Entry Program Name} like {?Program Name}) and
({?Agency Name} = "*" or {selsvc.Selected Service Entry Agency Name} like {?Agency Name})

The problem comes from the fact that Crystal will add the selsvc fields to the reports SQL select code, which has the effect of duplicating some records that do not have the same values for the selsvc fields. The select formula above is the only place in the report where values from the selsvc field are used, and as you can see they are only used when the user has submitted a matching parameter for them. I can not figure out how to get rid of the duplicates, please help!

Thanks for your time,

Chris