Solved

Business Reporter : using an entered value as filter

  • 23 July 2021
  • 3 replies
  • 259 views

Userlevel 1
Badge +3
  • Do Gooder (Employee)
  • 5 replies

Hi 

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

Regards

 

Jean-Christophe

icon

Best answer by Bhagya Wickramasinghe 31 August 2021, 07:29

View original

This topic has been closed for comments

3 replies

Userlevel 5
Badge +13

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

Userlevel 5
Badge +13

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


 

Userlevel 3
Badge +6

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