RpReport:SQLGroupBy Access/Assign

<< Click to Display Table of Contents >>

Navigation:  RpReport Class >

RpReport:SQLGroupBy Access/Assign

Previous pageReturn to chapter overviewNext page
Type        String

Purpose

To get/set the GROUP BY clause in a rpSQLQuery's SQL SELECT statement.  This assign allows you to set the grouping performed by the SQL server.  Do not confuse this assign with ReportPro's grouping.  ReportPro performs it's grouping locally independent of any grouping performed by the SQL server.

Note:        This access/assign maps directly to the first table object in the primary section.  It only applies if the first table object is a rpSQLQuery.