How to use Group in Query Print Layout

[Former Member]

Hi All,

I have prepared a query for fetching all purchase details along with tax code, now I have ordered it on tax code and prepared a query Print Layout,

Now within this Query Print Lay Out I want to group the tax code and want to add total of some columns at end of every tax code.

Request to guide how to achieve this.

Thanking you in advance,

Samir Gandhi

[Former Member]

We need to use Sort and Group in combination.

Select the repeatative area and in PLD menu select Sort, then select the column to be sort.

then in Header / Footer of that respective repeatative area select the fields and put in the group no. in the General.