passig parameters from data page to report definition
Scenario: I have 8 parameters defined in report definition, and used the parameters in filter condition with AND between all. Same parameters are passed from data page to report definition.
data page is called from decision tree. In multiple if conditions of decision tree, can I skip passing parameters to data page(and hence to report definition)? if I skip passing paratmers, how does the AND filter condtiion work in report definition?
will the query search for skipped parameters = NULL when querying database or just wont be included in the query filter conditions?
Accepted Solution
Updated: 19 Nov 2021 7:02 EST
jpmorgan chase
IN
Thank you so much for the reply , Santosh. That definetly helped.
JPMC
IN
If you configured as "Use null if empty" then skipped parameters will be executed as Where ColumnName = NULL if "Use null if empty" is unchecked then execution wont include columns in where clause if passed empty.
Hope this helps and clarifies your doubt.