VB Crystal Report, Change SELECT to SELECT DISTINCT?

Change SELECT to SELECT DISTINCT?

Author	Message
JM #1 / 2	Change SELECT to SELECT DISTINCT? 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
Sun, 13 Feb 2005 00:22:14 GMT

CW #2 / 2	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
Sun, 13 Feb 2005 07:32:45 GMT

Page 1 of 1

[ 2 post ]