data selection 1

[mwmark]

Using crystal 10 and a sql db.
I have a report that re-assembles my sales orders and works great, but i want to only see ENTIRE orders that have a specific sku_id.
Grouping by salesman,customer name,order number, then details (including sku_id), footers.
when i try and select a sku_id in the select expert i only get that sku and not the rest of the order.
any help would be appreciated.

 

[lbass]

Create a formula {@hasskuID} like this:

if {table.sku_id} = <particularskuID here> then
1

Then go to report->selection formula->GROUP and enter:

sum({@hasskuID},{table.orderno}) > 0

Note that if you are doing calculations across groups you will need to use running totals since the more usual inserted summaries will include non-group-selected records.

-LB

 

[mwmark]

what is {table.orderno}

 

[lbass]

It is the field you are grouping on for "order number", your innermost group.

-LB

 

[mwmark]

AWESOME! Worked perfectly
I really appreciate your help; you have saved me tons of time!