I did an experiment and found that the retrieve is not performed if the nested report is not visible on that row.

Hi Roland.

What I tried to do is a little bit strange and may not be a solution for you.

In SQL Anywhere it works.

// Case 1
case
	when 1 = 0 then
		select 100 from dummy
	else
		select 'a' as a1 from dummy where a1 = 'a1'
end;

// Case 2
case
	when 0 = 0 then
		select 100 from dummy
	else
		select 'a' as a1 from dummy where a1 = 'a1'
end;

The idea is to check the value (as an argument) instead of  1 = 0 or 0 = 0... Don't know what database you use so cannot write something that would work for sure.

But the queries I wrote return different value depending of when...

Andreas.

Hi Roland;

   FWIW: just a random thought... What about using a Stored Procedure for that nested DWO's Retrieve() DB source? Then have the SP return a null result set when you get that specific value you were talking about. Food for thought. 

Regards ... Chris