reporting services - jasper reports - passing empty parameter values from one subreport to the next -

i creating nested sub-report passing parameters below:

main report --> subreport1 --> subreport2

main report passes parameter subreport 1 subreport1 passes parameter b subreport 2

if during execution, parameter b has no value (i.e. sql query not return value @ parameter b), report execution stops @ point. if there subsequent values of parameter there non-empty query results parameter b, report not executed.

how ensure report execution continues when parameter b empty? using ireport designer report design.

thanks in advance venkatesh

you need @ least 1 record sub report continue executing suggest modify sql query return empty row if 0 rows matches.

check out question more details on how accomplish this:

https://dba.stackexchange.com/questions/41067/getting-select-to-return-a-constant-value-even-if-zero-rows-match