How to set parameter from relation?
in report designer for now customer location id showing all data but I want filtering data customer location ID from customer ID.
please help me, im stuck
Best answer by BenjaminCrisman
View originalHow to set parameter from relation?
in report designer for now customer location id showing all data but I want filtering data customer location ID from customer ID.
please help me, im stuck
Best answer by BenjaminCrisman
View originalHi
Please refer to following posts which guides you through the process.
An example could be found on following posts :
Hope this helps,
Regards,
Hi
I've tried and it doesn't work.
I use a table relation between customer, location, address and contact.
can you tell me the right relation to filter data from CustomerID then CustomerLocationID
Hi
In this case I would recommend the following setup for the Location parameter:
=Report.GetFieldSchema('ARPayment.CustomerLocationID,CustomerID')
When set like this, it will display properly:
Let me know if this was helpful, thanks!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.