supress supreport 1

[tnguyen315]

Hello,
I have a main report (crystal report xi) with several subreports on it.
For instance I have a supreport1 and supreport2, is it possible to supress the supreport2 if supress1 HAS DATA, show supreport2 if supreport1 is blank?
Thank you very much for your help.
I'm very appreciated.
Again, thanks.
Twee

 

[lbass]

Please explain in what report sections the subs are located. Are the subs linked to the main report? If so, on what fields?

-LB

 

[tnguyen315]

Sorry,

Group1: OrderNo
Group2: LineNo
supress all group header #1, 2 and group footer #1.

Parameter: OrderNo

data on show on the group footer#2, for example on group footer +2, the result show:

ItemID LotID QtyPicked Manufacturer
125A 958E 15 Watson
125A 7152F 20 EPA

Manufacturer is taken from subreport1 first if has data, if blank then will get data from subreport2

subreport1 link with mainreport by "OrderNo" and "LineNo"
subreport2 link with mainreport by "ItemID" and "LotID"

All manufacturer values on subreports placed in group footer #2 also.

Thanks

 

[lbass]

You need to have sub1 in GF2b, and sub2 in GF2c. You can format GF2b to underlay following sections so that the alignment is correct. Have your other fields in GF2b. In GF2a, add a reset formula (you can suppress GF2a):

whileprintingrecords;
shared numbervar orderno := 0;

In sub1, add a formula to the report footer:

whileprintingrecords;
shared numbervar orderno := {table.orderno};

Then in the main report->section expert->GF2c->suppress->x+2, enter:

whileprintingrecords;
shared numbervar orderno;
orderno <> 0

-LB

 

[tnguyen315]

Thank you so much lbass. It worked.
You saved me...
Again, thanks.
I'm very appreciated for your help.
Twee