Nav 2013 : How to only print the checked records

NewNavUser

Hi, i'm new to NAV and i have a question about form and report..

I added a new field in the "page - sales line" in NAV called"print" with data type "boolean".
My goal is to make the records with the checked "print checkbox" appear in the printout, and the other is not printed.

Here's the image of the page


What do i do to print only the selected one ?

BenSydney

Hi,

You can skip the record by putting code on the 'OnAfterGetRecord' trigger of the applicable 'DataItem' in the report.

It will look something like:

IF NOT Print THEN
CurrReport.SKIP;

Cheers,
Ben

JohnHunter

or Report/DataItem Properties/DataItemTableView/TableFilter Print/Constant/Yes

NewNavUser

i've tried both but it won't work

the field "print" (checkbox) is on sales line table, and in the report (Sales line - OnAfterGetRecord()) i tried to put the code

IF NOT Print THEN
CurrReport.SKIP;

even tried to use table filter
Field Type Value
Print CONST Yes

is there another solution ? thx before

clausl

Filter out the row in RowVisibility in the Layout, but then you pass uneccessary rows in the dataset, so better to do it in NAV.
But Row Visibilty is easy to do in Visual Studio ;-)

/Claus Lundstrøm

JohnHunter

All 3 options should work.
Close the page and then ran report ? :-k

NewNavUser

Thank you all for your help, it's working