The report only has one table, INLocation. I want a parameter linked to LocationCD to be a lookup. I cannot get that to work. Here is my setup:
What are the rules for adding a lookup parameter to a report?
Best answer by Naveen Boga
View originalThe report only has one table, INLocation. I want a parameter linked to LocationCD to be a lookup. I cannot get that to work. Here is my setup:
What are the rules for adding a lookup parameter to a report?
Best answer by Naveen Boga
View originalHi
=Report.GetFieldSchema('ARPayment.CustomerLocationID,StatementCustomerId')
Instead of LocationCD below, try with LocationID
=Report.GetFieldSchema('INLocation.LocationID,Warehouse')
Tried that - no luck.
Hi
Please find the attached report and screenshot. Hope this helps!!
Thank you. That worked. I didn’t need to add the table to the report. I just added the table reference in the view field.
Any other solutions for this? We were using the INLocationStatus table which was working fine until we upgraded to 21 R2. Now we’re not getting any records on the Selector popup.
I’m having the same issue. Cannot get Location selector to populate. Used same setup as the on provided in the solution and no luck.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.