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!

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

Supressing Details Crystal Reports

Status
Not open for further replies.
bslaast

bslaast

MIS
Oct 22, 2009
46
0
0
US
I have a Customer Order group with line items as the details. I want to suppress the details and header if all material for the order has been shipped.

On the Details:
{@RemainM} = ({MATERIAL_COST\.BUCKET_ACCUM_COST}*({CUSTOMER_ORDER_LINE\.BUY_QTY_DUE}-{CUSTOMER_ORDER_LINE\.QTY_SHIPPED}))

{@RemainCheck} is if {@RemainM} = 0.00 then 1

I want to suppress records where the {@RemainCheck} = 1, unless there is one records in the group where {@RemainCheck} = 0 then I want to see all records.

 
Status
Not open for further replies.

Similar threads

wf
  • Locked
  • Question
Passing Parameters with Crystal Reports
Replies
1
Views
32
schoepp
schoepp
wf
  • Locked
  • Question
Passing a query from visual interdev to crystal reports
Replies
0
Views
26
wf
wf
Metka
  • Locked
  • Question
Accessing MS Access reports from ASP page using InterDev
Replies
1
Views
30
MerlinB
MerlinB
wf
  • Locked
  • Question
Passing an SQL Query to a Crystal Report
Replies
0
Views
31
wf
wf
bryant89
  • Locked
  • Question
I need a way of printing reports ba
Replies
0
Views
20
bryant89
bryant89

Part and Inventory Search

Sponsor

Back
Top