Hi,
In this form how to filter by more than controlls, first filter by given from and to date than filter by site and than filter by warehouse.
filter by fromdate and to date , i did achive that, now i need filter by site and warehouse.
from-to date (inventjournaltran)table,site and warehouse (inventdim) table ,common field is inventdimid.
How to do this.
Add InventDim datasource joined to InventJournalTrans. If you need it only for filtering and you don't need to fetch data from it, use ExistJoin.
Then add query filters for those fields. If you know how to do it for other fields, it shouldn't be a problem.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156