Problem In Double grouping in report

Adityesh_Rathore

How can i make double grouping in my report?Like i have a table and i wnt to generate a report with grouping upon Document No. and then grouping upon Operation No. so that i can generate total of quantity under same operation no. with same Document No.Kindly reply as soon as possible.

ajayjain

you can use data item property GroupTotalFields in the report
define both the fields in this property and use group header and footer sections.

If you create more than 1 group header then it will be in the same sequence as you define the property GroupTotalFields.

You can also use
CurrReport.TOTALSCAUSEDBY

Adityesh_Rathore

i hav utilised the Grouptotalfields property and placed the 2 fields Doc. No. and OperNo. in the Group Footer .Also used Createtotal function to calculate total of Quantity(Oper No place and Corresponding total is fine).Bt wat bothers is dat Doc No. is repeated with every entry of OperNo. but i want it to b once for a group of OperNo.
Thanx 4 d reply

ajayjain

If you create the report using wizard, You will know , how can you hide a section, so that it should not repeat. check the coding in all the sections.

PaLPiTaTioN

Adityesh Rathore wrote:

i hav utilised the Grouptotalfields property and placed the 2 fields Doc. No. and OperNo. in the Group Footer .Also used Createtotal function to calculate total of Quantity(Oper No place and Corresponding total is fine).Bt wat bothers is dat Doc No. is repeated with every entry of OperNo. but i want it to b once for a group of OperNo.
Thanx 4 d reply

If you want each GroupTotal to be displayed only for a change with OperNo., you should place this code in the OnPreSection of your GroupFooter:

CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY=FIELDNO("OperNo."));