jonah_taxt
June 9th, 2005, 06:02 PM
Hi everyone, I posted the count manually post but, I think that clearing things up could help a lot more.
I have a table (Informix), I have a field called obsolete which contains the product obsolete type (OBSOLETE, NEOOBSOLETE, LINE)
I group my results with 5 fields
FAILURE, MANUFACTURER, PRODUCTLINE, PRODUCT, OBSOLETE
I've been able to get the count number grouped by obsolete, but I need a Running total of manufacturer divided in obsolete.
Ie
I have Manufacturer A .Manufacturer A had 13 failures in product line 3, product 4, 10 were in line and 3 were obsolete products. The manufacturer A had 5 failures in product line 4, 4 were in line and 1 was an obsolete product. So the total for manufacturer A would be 14 failures from "in line" products and 4 obsolete products.
I want to show that in my report but still have had no luck, I've been using Crystal Reports for 5 days now, so as you can see I'm a total Noob.
Could you please help me?
Thanx for any replies
I have a table (Informix), I have a field called obsolete which contains the product obsolete type (OBSOLETE, NEOOBSOLETE, LINE)
I group my results with 5 fields
FAILURE, MANUFACTURER, PRODUCTLINE, PRODUCT, OBSOLETE
I've been able to get the count number grouped by obsolete, but I need a Running total of manufacturer divided in obsolete.
Ie
I have Manufacturer A .Manufacturer A had 13 failures in product line 3, product 4, 10 were in line and 3 were obsolete products. The manufacturer A had 5 failures in product line 4, 4 were in line and 1 was an obsolete product. So the total for manufacturer A would be 14 failures from "in line" products and 4 obsolete products.
I want to show that in my report but still have had no luck, I've been using Crystal Reports for 5 days now, so as you can see I'm a total Noob.
Could you please help me?
Thanx for any replies