Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Posted: 08 Feb 2008 at 5:28am
Crystal won't show you that anywhere, because Crystal doesn't actually add it to the SQL at all. It executes the grouping in a slightly different way. Similarly, it executes the selection criteria in a slightly different way.
The tricky bit to recreating the SQL with the grouping included is that the SQL requires you to summarize any fields that are not indicated in the GROUP BY clause. So, in Crystal terms, you would only be returning the data from the group headers and footers, and nothing from the detail sections.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum