One of the tables of information I have to pull into my report needs to be brought in using a group by command in SQL, otherwise I end up with duplicate lines in the main body of my report. Is there a way to substitute my own query to drive the report? Or is there a way to invoke a group by clause using the built-in functions of Crystal Reports?
Thanks for your help. Jean