Formula based on empty or populated sibling suberport

[ChristianWhite]

Assume a main report with subreports 1 and 2. For a given set of parms, if sub 1's stored procedure returns no resultset, I would like to suppress subreport 1 and renumber the text-box caption of sub 2, which can use a formula, as sub 1.

Is there a method available to discover sub 1 is empty?

 

[ChristianWhite]

System specs:
CR XI, Windows XP Professional, SQL Server 8

 

[lbass]

You should be able to create a shared variable in the sub1:

whileprintingrecords;
shared stringvar x;

if isnull({table.field}) then
x := "" else
x := {table.field};

Place this on the subreport.

Then in sub2, use a formula like the following for your caption:

whileprintingrecords;
shared stringvar x;

if x = "" then "Sub 1: Your Caption" else
"Sub 2: Your Caption"

-LB