Skip to Content
Former Member
Oct 06, 2009 at 10:10 PM

Join Field Added to Select?



I'm have a report which joins three tables based on criteria passed in. One of the parameters is included in a WHERE clause to identify records in a specific date range. Crystal Report automatically adds the fields in the WHERE clause to my SELECT, causing duplicates to appear in the recordset. Is this expected? Is thre anyway around this?

I don't use the date field in the report at all, just in the SQL. I already tried the DISTINCT option. It removed some records but not all. Any suggestions would be greatly, greatly, appreciated!