Data Not Getting Displayed when Given Range

(0) Share

Report

Posted on by jsshivalik

3,027

I have added 1 field on Request Page for selecting G/L account . When i give single Account it works fine. In Range it does not work

G/L Account - OnPreDataItem()
"G/L Account".SETRANGE("G/L Account"."No.",GLAccountNo);

G/L Account - OnAfterGetRecord()
OpgBalance := 0;
Balance := 0;

G/L Account - OnPostDataItem()

G/L Entry - OnPreDataItem()
SETRANGE("Posting Date", 0D, ToDate);

G/L Entry - OnAfterGetRecord()
IF "G/L Entry"."Posting Date" < FrDate THEN BEGIN
  OpgBalance += "G/L Entry".Amount;
  Balance += "G/L Entry".Amount;
END;

IF "G/L Entry"."Posting Date" < FrDate THEN
  CurrReport.SKIP
ELSE
  Balance += "G/L Entry".Amount;

Thanks

*This post is locked for comments

All responses (3)

Answers (1)

Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Data Not Getting Displayed when Given Range

Check this link for better understanding of setrange and setfilter

msdn.microsoft.com/.../dd354955.aspx
jsshivalik 3,027 on at

Like (0)

Report

RE: Data Not Getting Displayed when Given Range

Hi

Why Setfilter , not SetRange

Thanks
Verified answer

mmv 11,465 on at

Like (0)

Report
RE: Data Not Getting Displayed when Given Range

G/L Account - OnPreDataItem() "G/L Account".SETRANGE("G/L Account"."No.",GLAccountNo);

It has to be changed to

G/L Account - OnPreDataItem()

"G/L Account".SETFILTER("G/L Account"."No.",GLAccountNo);