we have a requirement to set the "Use null if empty" Check box in RD filters to false before we are calling the RD from activity. So that if we if we check this check box in RD filters it should be override and it gives the complete list if we didn't pass the parameters. Please see the attachment. we are using 8.1 Version.
***Edited by Moderator Marissa to update Platform Capability tags****
You can uncheck "Use null if empty" in the Report definition itself. I think that would give you all the results when the param is empty. And you can pass "null" as parameter value that would give you empty results as it is null. Why do you want it from the Activity?
A separate report must be created. One without parameters. In your activity setup a when condition that checks if the parameter is null e.g. Param.Value == “” . If null run the new report without parameters and if the parameter has a value use your original report.
So, basically get the activity to check if you are passing values in your parameters before opening up the report in your activity. If null, use a report without params. If values, use report with filtering on those param values.
"Use null if empty" checkbox honored for GetSelectValues
When Report Definition rule uses parameters as a value for filter criteria, a moderate performance warning was generated: ''Some of your filters are using a parameter with the "Use null if empty" option NOT selected. Please ensure that you do pass the parameter. Otherwise, the filter will be dropped entirely and execution of the report will result in very poor performance. If you do not want this behavior, select the "Use null if empty" option.'' When the "Use null if empty" checkbox was selected as suggested, the "Select values" button gave an empty list of possible values. This was traced to refactoring work done on Select Values which changed it to be backed by a Report Definition and Grid instead of a List View: the option was intended to be only temporarily disabled, but was missed. To correct this, the activity pzGetSelectValues has been updated to honor the checkbox and appropriately disable the "Use null if empty" option on the selected filter on the temporary copy of the report definition before it is executed.