Business Reporter -Using wildcard in a report parrameter

-- Same answer already given 😀

12Guide_PaulB wrote:

Hi,

 

I normally select ‘%’ as default value in the parameter definition and then apply condition 'LIKE &Parameter’.

 

Best regards, Paul

Cheers Paul, twice you have helped me! Does the like statement still allow for multi values if I enable it in the Parameter area ? 

I had for got to say there could be 3 scenarios

1. single value
2. Multi selected values 
3. everything 

As state above I'd imagine it will work. 

Thanks for all your help! 

Hi,

No, you cannot use multiple values in combination with the like statement. If you use multiple values, you can use the IN condition instead. Combining both conditions (LIKE and IN) would be very useful but  isn’t possible as far as I know.

Cheers, Paul

Ah that’s a shame, Maybe a future feature. Thanks for your help!

Hi!

I think you should be careful with LIKE ‘%’ since LIKE can be very bad from a performance perspective.

BETWEEN can also be bad from a performance perspective. You shoud try to stick with = and IN.

Instead of LIKE &parameter and default value beeing ‘%’ I would use the “ALL” functionality.

The filter would be IN &parameter and the default value for the parameter would be ALL.

When using the “ALL” functionality and value the WHERE statement would not be added to the final SQL -statement. There could be a big difference in the performance when leaving out the WHERE statement for the filter instead of having a WHERE statement with LIKE ‘%’.

/Stefan