Liveware Publishing Support Forum

Is there any way to SELECT DISTINCT in a Instant Report (since the SQL is automatically built)? Or do I just need to convert the Instant Report to a New User-SQL and type in the SQL statement?____Thanks,____John

You would need to create a new User SQL and type in the SELECT.__There is not a way to change the SELECT that an instant report would create.____Kathleen__R&R Support