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.... :-)

manjusree

Hi,

Please check if both 'Tax Type' and 'Document no.' are included in active key of Detailed Tax entry.

Regards,
Manjusree

mohana_cse06

manjusree wrote:

Hi,

Please check if both 'Tax Type' and 'Document no.' are included in primary key of Detailed Tax entry.

Regards,
Manjusree

Primary Key? :-k

Chinmoy

Hi!

As Mohana quoted in viewtopic.php?f=23&t=53501 post, "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", no grouping (in any technology) will not work if the key / index / order is not on the fields on which you group..

Chn