Antwerp
Posts: 24
|
| Posted: 05/18/2005, 11:10 AM |
|
How can I add Group By to my sql statement and have records grouped under each item.
|
 |
 |
peterr
Posts: 5971
|
| Posted: 05/18/2005, 11:30 AM |
|
You can just add GROUP BY to your SQL statement whenever you want to use it. But you probably cannot use GROUP BY to group records under each item since grouping means that there will be no items/detail.
The "Simple Reporting" section of CCS Help file explains how to implement a grid with simple grouping.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
