Skip to Content
0
Former Member
May 20, 2008 at 12:34 PM

How to add "GROUP BY"

63 Views

Post Author: roman.keller

CA Forum: Data Connectivity and SQL

How can i add a "group by" statment to the sql in Crystal Reports?The Problem is that i get multiple unique rows. I checked the get unique rows but i still get multiple rows. If i run the sql direct on the database, the "DISTINCT" and "GROUP BY" works perfect. I tryed to find a solution in the manual and forum. So i hope someone can halp me.