I have a parametrized Data Page sourced from a report definition which has filters. If no filter is being passed I need to get all the values. However for that I need to uncheck “use null if empty” but that will again add a moderate warning. So I should let it be or create additional report definition and use it as a second source with condition to trigger only if params are empty. There will be no filter in the report definition so no warning, however I will have to create an additional rule.
Ensure that all filters utilizing a parameter without the “Use null if empty” option selected are provided with the necessary parameter. Otherwise, the filter will be excluded entirely, potentially leading to significantly degraded report performance. To avoid this outcome, opt for the “Use null if empty” option if you prefer a different behavior.
Creating another rule only for passing params and keeping the old record without param would still mean the old report will have the warning in both cases, so it makes less sense.