How to use SETFILTER in report to display variable's values

Business Central/NAV Developers Forum
1

Dear All,

I am creating a report in which i want to show value through variable names “AssVal” so i have set following filter on predataitem Trigger in report. But it is showing zero value in report.

PurchInvLine.RESET;
PurchInvLine.SETFILTER(“Document No.”,“Excise Entry”.“Document No.”);
PurchInvLine.SETFILTER(“No.”,“Excise Entry”.“Item No.”);
AssVal:=PurchInvLine.“Assessable Value”;

Please tell me where i am doing wrong.

Thanx in advance.

Rgds

Neel

2

Write a code on onAftergetrecord on Excise Entry Data Item.

3

Write below code in OnAfterGetRecord trigger of dataitem

PurchInvLine.RESET;
PurchInvLine.SETFILTER(“Document No.”,“Excise Entry”.“Document No.”);
PurchInvLine.SETFILTER(“No.”,“Excise Entry”.“Item No.”);

IF PurchInvLine.FINDFIRST THEN //New Line
AssVal:=PurchInvLine.“Assessable Value”;

Make usre the filters on PurchInvLine are correct…

4

Sir,

I write same code on OnAftergetrecord of Excise Entry Date Item but result is zero.

5

use PurchInvLine.findfirst or PurchInvLine.calcsums (if you want sums)

6

Did you set proper filters?

Set above filters manually and see how many records you get and does the record has Assessable value or not…

7

DONT USE

PurchInvLine.SETFILTER(“Document No.”,“Excise Entry”.“Document No.”);
PurchInvLine.SETFILTER(“No.”,“Excise Entry”.“Item No.”);

USE

SETRANGE(“Document No.”,“Excise Entry”.“Document No.”);

8

May I know the dataitems of report? and in which dataitem Onaftergetrecord did you write the code?