Dynamics 365 Business Central/NAV User Group

Developers Forum Report Boolean to filter zero value

Dynamics 365 Business Central/NAV User Group requires membership for participation - click to join (it's free)

Thread information

Locked Locked
Replies 20 replies
Subscribers 1277 subscribers
Views 9392 views
Users 0 members are here

Report Boolean to filter zero value

PenGwenInc over 14 years ago

I've added a Boolean to the Request Form in the "Inventory to G/L Reconcile" report. When the Boolean is checked, I would like the report to display only items with a zero "Inventory Value". The InventoryValue field is an existing calced field on the report.

I can't seem to code this properly and the Boolean doesn't filter when checked. It should filter on 0 Inventory Values, but I cant get it to work. Any ideas?

Parents

PenGwenInc over 14 years ago

Thanks guys! It worked.

Thanks for all your help!
Cancel
Up 0 Down

Cancel
Jhosap over 9 years ago in reply to PenGwenInc

Hi,

I am genarating a simple report. In CustTable I am having Boolean(YesNo) type for Car Field. now i want to genarate only "no" type custDetails.

Thanks in Adv
Cancel
Up 0 Down

Cancel

Reply

David Samana over 9 years ago in reply to Jhosap

Well, Jhosap

create a list report using dataitem custTable as you refer it the on the properties of that data item DataItemTableView filter the the 'No' only

i.e SORTING(No.) WHERE(Car=CONST(No))

regards

david
Cancel
Up 0 Down

Cancel

Children

No Data

Related

Recommended