Hi
Is it possible to enter a value in a cell and use it as a filter. See attached file.
Regards
Jean-Christophe
Solved
Business Reporter : using an entered value as filter
Best answer by Bhagya Wickramasinghe
Hi Havas,
You cannot take a cell value to filter records. Hence you can try the following approach.
First you need to create a parameter to represent the value of Code_B.
You need to have a repeater to show the result for each account.
Selecting the same row and navigate to the tab Filter Criteria and add Code_B and from the LOV select the parameter value created.
When you execute the report with the following setup, during the execution a dialog box will popup to get the value for the Code_B.
Best Regards,
Bhagya
This topic has been closed for replies.
Hi Havas,
It’s not possible to use manually entered value in a cell as a filter. As a workaround you can create a report template with an excel filter option, by using the code_b in the repeater.
Or use a sheet repeater, if you can control the multiple input parameter in code_b.
Thanks
L P Reddy
Hi Havas,
You cannot take a cell value to filter records. Hence you can try the following approach.
First you need to create a parameter to represent the value of Code_B.
You need to have a repeater to show the result for each account.
Selecting the same row and navigate to the tab Filter Criteria and add Code_B and from the LOV select the parameter value created.
When you execute the report with the following setup, during the execution a dialog box will popup to get the value for the Code_B.
Best Regards,
Bhagya
Hi
If you think my answer helped to resolve your issue, please mark it as the best answer. So that it will be helpful for other peers.
Thanks!
Bhagya
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.