Question
Report Definition Filter conditions
Hi,
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.
Thanks,
Suresh
***Edited by Moderator Marissa to update Platform Capability tags****
as per requirement, we want disable the "use null if empty" check box.
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.
I hope this solves your problem. Good Luck.
"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.
Resolved in Product Version
SR
D47414
Issue
513076
If you are calling the report definition from an activity, I believe you can set property pyUseNullIfEmpty to false on the step page for the report.
Hi
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?