Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group header visible depending on status of sub report

Status
Not open for further replies.

jasonmac

Programmer
Nov 14, 2002
175
US
I have a report and a subreport. The report is named rptMain. The subreport is named subProductionJobLines. rptMain is grouped by a sales order number and subProductionJobLines is placed in rptMain's detail section. In some instances there are no lines for a specific sales order. What I mean is that the subreport is empty for some groups.

Now the question. How can I get the groups in which the subreport is empty not to show up when I run my report?
 
I've never done this quite the way you want but...

On the nodata event of the sub-report set the visible property of the main reports group header to false.

good luck
ssecca
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top