Filter on a report for integers values using C/AL

(0) Share

Report

Posted on by Community Member

Hi All,

I am in a scenario where I need to filter data in a report for a specific integer values/Dateformula using C/AL code. The idea is that for a specific item classification and the value which are specified in the if statement should only the report display the result. Thanks in advance.

Here is a snippet of the code

On AfterGetRecord
DiffDate := FirstD - SecondD;
DivDate :=ROUND(DiffDate/30,1,'<');
StrCon :=FORMAT(DivDate)+Text006;
EVALUATE(SLOBWindowsPeriod,FORMAT(StrCon));

IF DivDate >=12 THEN
Item.SETFILTER(Item."Classification Code",'CON')
ELSE IF DivDate >=24 THEN
Item.SETFILTER(Item."Classification Code",'OPS')
ELSE IF DivDate >=48 THEN
Item.SETFILTER(Item."Classification Code",'INS')

// The above code is supposed to filter data for
//the specific Item classification based on the if statement
// but it didnit give the required results

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Mohana Yadav 61,204 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

As per your code, if the DivDate is 50 then also first condition is true (>12) and it will never come to ELSE Part.

you have to also mention < value in conditions

IF DivDate >=12 AND DivDate < 24 THEN

Item.SETFILTER(Item."Classification Code",'CON')

ELSE IF DivDate >=24 AND DivDate < 48 THEN

Item.SETFILTER(Item."Classification Code",'OPS')

ELSE IF DivDate >=48 THEN

Item.SETFILTER(Item."Classification Code",'INS');

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Mohan,

thanks for your reply

I get an error that type conversion is not possible because 1 of the operators contains an invalid type: Integer AND Integer.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,204 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

That is just a code sample. you have fix it as per syntax.

like

IF (DivDate >=12) AND (DivDate < 24) THEN

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Eri,

As Mohana in your code use parenthesis for every condition for example for your above code

IF (DivDate >=12) AND (DivDate < 24) THEN Item.SETFILTER(Item."Classification Code",'CON') ELSE IF (DivDate >=24) AND (DivDate < 48) THEN Item.SETFILTER(Item."Classification Code",'OPS') ELSE IF (DivDate >=48) THEN Item.SETFILTER(Item."Classification Code",'INS');

Was this reply helpful? Yes No