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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Section Suppress based on criteria in subreports

Status
Not open for further replies.

JCook23

Technical User
May 19, 2004
39
US
I have a main report that list all customers. I have a subreport linked that gives all orders for all customers based on a date parameter. If customers do not have an order, then $0.00 listed. This is good. Then, I have a subreport linked that gives all invoiced sales based on a date parameter. If they did not have any sales then it is blank. Sort of okay, but $0.00 would be better. Not all customers are listed on the subreport though, just those with sales.

Can I section suppress the customers on the main report if the Orders total = $0.00 and the Sales total = ''? This way only customers with Orders, Sales, or Orders and Sales will be listed?

CR 10.0
SQL Server

Thanks for any input,
Jeff C.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top