| Subject | Re: REPORT GROUPING ON FIELDS |
| From | Mervyn Bick <invalid@invalid.invalid> |
| Date | Sat, 24 Jun 2017 12:22:44 +0200 |
| Newsgroups | dbase.getting-started |
On 2017-06-24 11:13 AM, Mustansir Ghor wrote: > Dear all > > I wonder how ag.sum,ag.count and other work on group. There was tutorial report which was group on supplier and from different table it gave it its inventory total in the footer of the group. So how the total was done based on supplier (I understand the tables were joined by masterrowset and masterfields) . Can this be done on the designer or we only need to add as codeblock. With a report open in the designer the Add Groups and Summaries option in the Layout menu will allow you to set groups and apply the aggregating functions to fields in the group. If you select the <grand total> option this will place values on the reportgroup footerband for you. Mervyn. | |