Section Suppress in main report base on data from subreports?

[JCook23]

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.

 

[crystalreporting]

You can conditionally suppress sections in the main report based on subreports by using shared variables HOWEVER for this to work, the subreports have to be above and ahead of the section you want to conditionally suppress in the main report. So, you could add two subreports to go out and count the orders and the sales (this isn't Macola is it?) and put these ahead of the sections in the main report you want to suppress. Unfortunately, you cannot completely suppress subreports, so they will take space up on your report regardless. If you are running over MS/SQL, I would recommend you create a view of the open and closed orders (with a UNION) statement instead.

Peter Shirley

http://www.linkcorp.com