I have a report written in cr 8.5 which shows open line items on all our open purchase orders. However on open ended orders the lines could run into hundreds. I have been asked to show all lines with quantities outstanding and show three deliveries back on lines that have no quantity, i.e. fully delivered. I am new to crystal and finding it hard going ploughing through the books! Any help would be appreciated.
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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
limiting results
- Thread starter jesmona2
- Start date
Assuming you only want lines that have no quantity, i.e. fully delivered, then adjust the record selection to exclude anything else.
If you group by purchase order, you could then count and suppress detail lines after the first three.
Right-click on a field and choose Insert to get a choice of Running Total, Summary and Grand Total.. Or else use the Field Explorer, the icon that is a grid-like box. You need a summary.
Right-click on the detail section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression.
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK)
If you group by purchase order, you could then count and suppress detail lines after the first three.
Right-click on a field and choose Insert to get a choice of Running Total, Summary and Grand Total.. Or else use the Field Explorer, the icon that is a grid-like box. You need a summary.
Right-click on the detail section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression.
Madawc Williams (East Anglia, UK) - Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question