Hi all,
I have created one query in AOT and setting the range field for the same.
for e.g. Created query in AOT name 'AX_Query' data source is Vendtable table and set the range for 'AX_Query" ranges are Vendor Account, Currency see below screen shot,
Now, when using this query into Report the report parameter form having select button to set the ranges in report inquiry form.
like below screen shot.
after that, when clicking a vendor account field criteria to display all type of vendor in lookup,
In Standard scenario:
vendor account criteria lookup value:
Accnum - group
A001 10
A002 20
A00 30
but, my requirement is when clicking a vendor account field criteria to display only particular type of vendor in lookup.
My requirement vendor account criteria lookup value :(only vendor group 10)
Accnum - group
A001 10
if this is possible in query inquiry form please let me know. I have struggling how to do it.
*This post is locked for comments
This is a simple way to get range for report, but in some case you can put fields above to parm and write lookup method for it
Hi ivan,
I have using query and write some coding init method using query filter class but how we get lookup based one query range field from another.
if u know anything abt query related filter criteria pla let me know......
Well, as I said, it's software, so anything is possible. So yes, you can achieve through customization of larger scale.
But I'd suggest that you add a field for specifying the vendor account directly on the report dialog. This way, you'll be able to easily override the lookup for it.
Upd. Oops, took my bloody time replying :) You already have the same reply above...
As Ivan already said, it would be possible with some customizations. But don't do that - instead, add a normal field to the report dialog.
Hi ivan,
if this scenario simply possible or not?
Without a number of customizations - you can't filter the looking values displayed in SysQueryForm.
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,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156