passig parameters from data page to report definition

General
, ,
1

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?

2

@phanid79

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.

3

Thank you so much for the reply , Santosh. That definetly helped.