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

Report and subreport printing

Status
Not open for further replies.

tektipdjango

IS-IT--Management
Jan 28, 2004
188
I'm a newbie in CR!
Main Report :
for each item which has customer orders
detail qty of customer orders
ItemXXX
order o1 qty q
order o2 qty q2 ...

Subreport
detail of inventory (qty location)
ItemXXX
loc1 qty qInv1
loc2 qty qInv2 ...

How can I print only the Items where total inventory < total orders whith both (inventory and orders) detailed information?
 
Using data from a subreport to suppress the main report is impossible.

The only way you can do it is to run the subreport twice, once in the gropu header with all sections hidden. Use shaed variables to capture the totals of inventory.

Use this variable to then either suppres the group and subreport or allow to run.

I believe there are various FAQs on this site about this subject, or on the CD/BO Knowledge base.

Ian
 
A solution that works for Crystal 8.5 is found at thread782-477236

There could be some new method in Crystal 9. It's always worth saying which version you have, because extra capabilities keep getting added.

Madawc Williams
East Anglia, Great Britain
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top