Set filter on report requirement

(0) Share

Report

Posted on by Community Member

I have made a custom report which uses the item table. The last thing i need is when clicking the report button when standing on an item to take the item No. and put it in the "where No. is a value". So like on my screenshot, if i stand on AK-001 and press the button for the report it should fill the No. with AK-001.

5824.Untitled.png

What i have tried to make it work:

In the item list page (31) -> page actions -> open C/AL editor for the report OnAction.

<Report Item Barcode> - OnAction()
Item.SETRANGE("No.","No.");
REPORT.RUNMODAL(REPORT::"Item Barcode DMC M PRIS2",TRUE,FALSE,Item);

Nothing is happening with the above i tried.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your report using Item table as the DataItem?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes, my report is using the Item table as DataItem.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Have you tried restarting the NAV application service and checked the output?

Ideally, it should work.

Was this reply helpful? Yes No
RockwithNav 9,113 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hey Christopher007,

In the list page (31) -> page actions -> open C/AL editor for the report OnAction.

Write this Code.

CurrPage.SETSELECTIONFILTER(REC);

REPORT.RUNMODAL(Report,TRUE,FALSE,REC);

It will work for sure.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for the replys.

I just found the problem I had.

On the page action property I had put RunObject on which would overwrite the setfilter i set in the CAL code.

Was this reply helpful? Yes No