Bruce Make sure give the sub report component ID a name. On the band where the sub report is located check to see if rows exist. If not then do
SET VAR vRowSRTop INTEGER = 0 SELECT COUNT(*) INTO vRowSRTop INDIC IV1 from SubReportTable WHERE SRTopID = .vSRTopID IF VRowSRTop = 0 THEN PROPERTY SR1componentIDname VISIBLE ‘FALSE’ ELSE PROPERTY SR1componentiDname VISIBLE ‘TRUE’ ENDIF If that don’t work then try putting the sub reports in regions make sure they have component names Just replace SR1componentDname to whatever region 1 component name is. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Wednesday, April 13, 2016 2:27 PM To: [email protected] Subject: [RBASE-L] - Sub-Reports in Region: Shift Relative To ... All: A report Region contains two sub-reports, one stacked vertically below the other. The top sub-report (TopSR) will often have no row entries, at most only one. The bottom sub-report (BottomSR) will always have at least one entry. I would like TopSR to collapse to nothing if empty, with BottomSR filling that vacant line. This is a job for "Shift Relative To ..." in BottomSR, BUT "Shift Relative To ..." is greyed out in BottomSR's properties pop-up (as is "Stretch"). So when TopSR is empty, a line remains vacant above the contents of BottomSR. What to do? Thanks Bruce SafeSectors, Inc. 909.238.9012 mobile -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
