Crystal XI/Commerce Center - Record Suppression 1

[SassyStacie13]

I have developed a weekly report for my sales reps that works beautifully for their needs except for one little thing.

My problem is this: When I run the booked orders report, if an item has invoiced already - it shows up twice in the order section - once with item cost(invoiced item), once without, and not always in the same order. Is there a way to suppress this no cost occurrence, since it isn't in the same "place" on each order? This is my example:

6004257 3/1/2006 KI-46887-P

Qty Item ID Item Description Item Price Total Sale Item Cost Total Cost GP

1.00 8433 0723 98-D ETV DS7-160-13S $1,900.00 $1,900.00 $0.00 $0.00 1.00

1.00 8433 0723 98-D ETV DS7-160-13S $1,900.00 $1,900.00 $900.00 $900.00 0.53


This also skews the GP on each line item, as that is an important piece of this report for my reps.

Thanks for any feedback. I'm sure it's probably simple, but I can't wrap my brain around this one.

 

[Durango122]

select the format section of the detail and check suppress duplicated

Durango122
Remember to used all fingers when waving to policemen

 

[Durango122]

or
in the suppress x2 insert htis
no cost = 0

Durango122
Remember to used all fingers when waving to policemen

 

[SassyStacie13]

Durango,
I tried that, but if the first line has NO item cost, I want that line suppressed. However, the $0 cost line isn't always the second line item - and, it supresses all the duplicates - qty, costs, etc. I'm trying to write a formula to supress the line if the Item Id is the same, but only if the item cost is $0.

 

[lbass]

If you only want items where the item cost <> 0 then add that to your record selection formula (report->selection formula->record):

{table.itemprice} <> 0

-LB

 

[SassyStacie13]

lbass,
That works, except that if I order a new item and don't have all the cost information, it kicks out items that are valid and not duplicated order line items. I know this is kind of confusing. Any other suggestions that might work?

 

[lbass]

Insert a group on Item ID. You can suppress the group header and footer if you want to, and then go to the section expert->details->suppress->x+2 and enter:

count({table.itemID},{table.itemID}) > 1 and
{table.cost} = 0

If you are doing calculations that cross item IDs, then you would need to take the suppressed items into account in those calculations.

-LB

 

[SassyStacie13]

Thank you. It worked beautifully.