Small and medium business | Business Central, N...

How to club Parent and child dataitem's filter to run a report in NAV 2016?

(0) Share

Report

Posted on by Beulah

112

I want to run "Suggest Vendor Payments" report such that filters from "vendor" data item (Parent Data Item) has been used. In order to apply the filters from "Vendor Ledger Entry", I have added this table as a child Data item. But the filters applied from "Vendor Ledger Entry" (Child Dataitem) has been ignored and the filters from Parent DataItem (Vendor) is only applied in the results fetched once the report runs.

Can anyone suggest how to apply the filters from both the tables while running the report ?

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to club Parent and child dataitem's filter to run a report in NAV 2016?

Hi, This Report has only one DataItem (Vendor), so you cannot add filters directly from "Vendor Ledger Entry". Even if you add Child Dataitem, its logic is not to extract data from your Child Dataitem, so it should have no effect.

If you do some customization now, I think you can add the fields you need in "Vendor Ledger Entry" to the Request Page, and then add the filter code in report object.

Hope this helps.

Thanks.

ZHU
Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to club Parent and child dataitem's filter to run a report in NAV 2016?

hello

you should share some more info about your customization

DAniele
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to club Parent and child dataitem's filter to run a report in NAV 2016?

Hi,

Can you please share what you have achieved so far? Including code in Txt format only.

Thanks.