Question

The filter with IN clause

  • 26 April 2024
  • 2 replies
  • 17 views

Userlevel 5
Badge +12

Hi BR experts,

Could you please advise me on the following issue?
When the customer orders the BR report, they get an empty report.
But when I order the same report I get the report with data.
To investigate the problem, I removed filters from the report one by one, until only the company filter remained. 
The filter looks like this: 
DIM_COMPANY.CODE IN &Company
I defined it with a parameter Company with the default value: 8031,8111,8114,8115. 
The report appears empty, but when I change the filter to:
DIM_COMPANY.CODE IN '8031','8111','8114','8115'
with hardcoded values, the report shows data. 
Have you encountered such an issue? Do you know any solution or workaround on how to define a filter with a multi value parameter so that the report displays data?
I would be grateful for any suggestions.
Best regards,
Adam


2 replies

Userlevel 2
Badge +8

Hi @Adam Mazurczak 

Can you check whether you have enabled the multi value option when defining the Company parameter?

 



The filter criteria needs to be added as given below.
 


Thank you

 

Userlevel 5
Badge +12

Hi @shwiclk 

thank you for reply.

The filter looks like this:

For all parameters used in IN clause Multi Value checkbox is checked.

BR,

Adam

Reply