Fixing guardrail warnings on report definitions
I have a report definition that in filter conditions
- I have to uncheck use null if empty to display results if a value is not passed to a parameter
e.g: In a data type that contains products a column will contain whether the product is banking or insurance. If a value is not passed to this parameter it should display both banking and insurance products.
2. Make a relationship to Contains
e.g: there are some products that will be applicable to banking and insurance. In this case I'm setting the column value to "Banking, Insurance". Therefore depending on if the parameter value is passed as banking or insurance it will display this record as well along with other respective banking or insurance products.
However, the above options are creating guardrail warnings and the client wants to get rid of them. Is there any workarounds that we can do to fix those warnings?
Otherwise what are the recommendations for scenarios like this where the functionality provided raises guardrail warnings, but we need those functionalities?