Skip to main content
Solved

Report Designer: Parameter/Filter: Customer Location

  • January 14, 2025
  • 2 replies
  • 66 views

Forum|alt.badge.img

Hi everyone, I was following the suggested solution in the Report Designer Parameter relation customer id and customer location id | Community to create the parameter. I was able to output the Location parameter which is dependent to the Customer. However, it seems that the filter is not working. Output in report is still printing everything. 

 

I tried adding the filter to the table that’s created relationship with. (Note: I cannot output this in the paramater as location the field is SOOrder.CustomerLocationID,CustomerID ) Do I need to create relationship now for the ARPayment? I have attached the report in question. Thanks a lot in advance.

 

Best answer by nhatnghetinh

Hi ​@Crisel 

I have updated your report. Currently the Location selector is working fine.

 

 

 

 

 

 

Best Regards,

NNT

View original
Did this topic help you find an answer to your question?

2 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 555 replies
  • Answer
  • January 15, 2025

Hi ​@Crisel 

I have updated your report. Currently the Location selector is working fine.

 

 

 

 

 

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Freshman II
  • 14 replies
  • January 15, 2025

Thank you so much! I tried following the setup you shared in your screenshots and it solved my concern. 

In my understanding, the correction was the filter should be Location.LocationID to compare to @Location, instead of the SOOrder.CustomerLocationID or other fields I was trying. 

Thanks a lot for your help. Highly appreciate it! πŸ‘πŸ‘πŸ™ŒπŸ™πŸ€


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings