Suppress Formula

[nervous2]

I am trying to make a report to list dead stock, I am almost complete, but I am stuck on one area. I have made a formula to list when a batch was last sold and to flag it, but I only want to show the last (most recent time) it was sold.

Eg we make paint, paint is categorized by lot#/batch # and colour when we create a new batch of black that black is categorized by batch number whereby the batch number has by choose the date it was manufactured eg 6l4152, problem is when I try to list when it was last sold I don't get just the last time it was sold I get EVERYTIME it was sold, I won't to list just the most recent time it was sold, and nothing else listed. Does anyone know the command/formula to suppress the value? Once it has been listed once?

This is very hard to explain but I need a suppress formula; the book which I am following doesn't seem to give me a proper formula.

Thanks

 

[synapsevampire]

Group by the lot, then the batch.

Sort fields by the date ascending and then place your fields in the batch group footer, and suppress all othergroup sections and suppress the details section.

You'll be better served in future posts to not use descriptions, instead posting techncial information:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[nervous2]

Thanks man that did the trick; you saved me a lot of time.

Much appreciated.

 

[nervous2]

One more question when I sum the total inventory it's also summing the totals of the surpressed values, which is giving me invalid numbers how can I sum only the visible data?

Thanks

 

[lbass]

You either have to insert a running total that uses a formula in the evaluation section that is the opposite of your suppression criteria (to include only the relevant rows), or change your approach so that instead of suppression, you use group selection. You would go to report->selection formula->GROUP and enter:

{table.date} = maximum({table.date},{table.batch})

You would still have to use running totals placed in the group footer, but you would not have to use an evaluation formula, since the running total would only pick up the group selected records.

-LB

 

[DataDivaJill]

I would have handled it just a little differently.
I would have sorted in the date descending order.
then do a running number field.
forumla the format of the detail section to hide if the running number is >1.
then i think if you total it add in the amount. (i think)
good luck.

 

[nervous2]

I am confused as how the running total can total my stock properly, because I am only interested in totalling the stock for each group, I have made the report available at

ftp://megamix:megamix@houseonline.kicks-ass.net:4321/deadstock.pdf

Thanks for the time I appreciate the help if you look at the report you will see how it is laid out and it may give a better description as to what I have done

 

[nervous2]

please add ftp:// infront of that link for some reason the posting omits the entire link

 

[nervous2]

Sorry I don't have the ability to delete previous post and I hate to be a nuisence but my links are not listing here properly, to properly downlaod my repost please connect these 2 partial links together

ftp://megamix:megamix

(link this to)

@houseonline.kicks-ass.net:4321/deadstock.pdf

 

[lbass]

Can't follow the link. Please explain the problem. If you want the running total to show totals by group, then reset the running total on change of group.

-LB