Query about filtering out Closed Periods

engsiong75

Hi

May I know if there is a way to use Setfilter logic to filter out the Closing Periods?

This is the code that I managed to develop so far but it is not exactly very elegant.

PDate :=0D;
PDate := CLOSINGDATE("G/L Entry"."Posting Date");
IF PDate = "G/L Entry"."Posting Date" THEN
CurrReport.SHOWOUTPUT(FALSE)
ELSE
CurrReport.SHOWOUTPUT(TRUE);

Thank you,

Tan Eng Siong

kine

CurrReport.SHOWOUTPUT("G/L Entry"."Posting Date" <> CLOSINGDATE("G/L Entry"."Posting Date"));

;-)

pdj

We can't use SETFILTER to ignore closing dates, unfortunatly. :-(
However, your solution with SHOWOUTPUT might lead to incorrect Totals, so I will strongly suggest using CurrReport.SKIP instead. (And always try to put your code in the OnAfterGetRecord instead of the OnPreSection as I guess you are using now)

PS: Now we are in the business of making short and precise code:
IF "Posting Date" = CLOSINGDATE("Posting Date") THEN
CurrReport.SKIP;
8)

engsiong75

Sigh. This will make the report run slower. Thanks for the info.