Skip to main content

Hi 

Is it possible to enter a value in a cell and use it as a filter. See attached file.

Regards

 

Jean-Christophe

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 @Havas ,

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