
Change SELECT to SELECT DISTINCT?
Create a view using Select Distinct, and write your report based on that
view instead of the underlying base table.
Alternatively, set SQLQuery property to the select distinct in VB code.
Quote:
> I'm trying to change from 'Select' to 'Select Distinct' on an existing
> report. I've tried changing it in the SQL Query dialog box, but it never
> saves the change. The same question was posted previously by someone else
> but there were no replies. So, how can I make the change?
> Using CR 8.5
> TIA
> --
> JohnM