Hi,
I have created a parameter “&Activity” for getting project activity short name. (Figure 1).
And also created function parameter “&Activity_2” because “&Activity” is not mandatory while running the report (Figure 2).
After I checked “multi value” checkbox of “&Activity” and also changed operator to “IN” for holding multi values in filter criteria (Figure 3).
When running report with multiple values its showing blank page
Anyone can help me to solve this problem?
Best answer by Thiwanka Sandaruwan
Hi
It seems my previous suggestion does not work for the activity's multi-values. Sorry for the inconvenience caused.
I suspect that the functional argument’s string value never fetches multi-value parameters as a value when the function id is NVL. Since you have checked the multi-value checkbox for the ‘activity parameter after creating the ‘activity_2’ functional parameter it is showing as above. If you need to verify this please delete both 'activity' and 'activity_2' parameters and try to add both parameters respectively with current properties.
I think you can use the default value for the 'activity' parameter as a workaround instead of creating the function parameter ‘activity_2’.
Best Regards,
Thiwanka
+9Hi
Please change the syntax as the below and try to run the report.
Best Regards,
Thiwanka
+9Hi
It seems my previous suggestion does not work for the activity's multi-values. Sorry for the inconvenience caused.
I suspect that the functional argument’s string value never fetches multi-value parameters as a value when the function id is NVL. Since you have checked the multi-value checkbox for the ‘activity parameter after creating the ‘activity_2’ functional parameter it is showing as above. If you need to verify this please delete both 'activity' and 'activity_2' parameters and try to add both parameters respectively with current properties.
I think you can use the default value for the 'activity' parameter as a workaround instead of creating the function parameter ‘activity_2’.
Best Regards,
Thiwanka
Hi
Thanks for the reply! It pop ups the error ‘Object reference not set to an instance of an object’ when running the report without activity parameter. Anyway I put default value ‘%’ as for this one and now report is working properly
Thanks,
Regards,
Deepal.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
