Report 16539 - Sales Book VAT

Stivan_dsouza21

Report 16539 - Sales Book VAT

Not able to group as per Document No.

1) Set up the DataItem Property for Detailed Tax Entry 0f GroupTotalFields as Tax Type,Document No.
2) written the below code on Detailed Tax Entry group Footer

Detailed Tax Entry, GroupFooter (6) - OnPreSection()
IF PrintToExcel THEN BEGIN
IF CurrReport.TOTALSCAUSEDBY = FIELDNO("Detailed Tax Entry"."Document No.") THEN
MakeDataExcelForGrpFooter
ELSE IF CurrReport.TOTALSCAUSEDBY = FIELDNO("Detailed Tax Entry"."Tax Type") THEN
MakeDataExcelFooter;

END;

Its getting Grouped as per Tax Type and Printing the Footer but not able to print as per Document No.

Can Somebody help me.... :-)

mohana_cse06

What about the Key set in DataItemTableView property?

Stivan_dsouza21

Key is : Export or Deemed Export,Tax Type

mohana_cse06

Stivan_dsouza21 wrote:

Key is : Export or Deemed Export,Tax Type

You should know the basic concept how Grouping works

The GroupTotalFields is used with the TotalFields Property to maintain totals for one or more fields. Both group totals and the grand totals can be output by using the appropriate sections. Enter this property value as a comma-separated list of field names. The fields can be selected by using the AssistEdit button from the Value field of the property. Fields in the list must also be fields in the active key of the underlying table. If not, the report displaying the data items will not run