Stacking Subreports

[herschelrj]

Question...

I wouls like to display the information from one subreport. But if that report is blank, I wouls likw to display the second subreport. Some of the records have information in both. I want to display the first one only if both contain data. Any ideas?

Display CTY Credentials. If none, display SDCS Credentials.

Thanks

herschelrj

 

[lbass]

In your first subreport, create a shared variable, as in:

whileprintingrecords;
shared stringvar CTY;

if isnull({table.CTYCredentials}) then
CTY := "" else
CTY := {table.CTYCredentials};

Place this on the first subreport instead of the field {table.CTYCredentials}.

In the second subreport, create a formula:

whileprintingrecords;
shared stringvar CTY;

if CTY = "" then {table.SDCSCredentials} else ""

Place this on the subreport instead of {table.SDCSCredentials}.

-LB