Search results for query: *

Tried that-the one in the header came back zero :(

Never mind I figured it out-thanks anyway

So am I like on the do not help list? Or am I asking stupid or incomplete questions?

Greetings all, CR9, Informix procedure, Unix database. I am attempting to get the loose quantities on a report to calculate correctly and not having much success. I need the report to first figure out what the remainder is per item, then sum that remainder for a total to be printed on the...

Greetings All, CR9, Informix procedure, Unix database. I have a formula that is getting damaged quantities from the same procedure expression as the undamaged quantities This formula is finding the records created in the db that have the hold code of DAMG and selecting the quantity. I am...

I tried the running totals-those are great, but I am having a problem. Unfortunately the way the database is written and records data there can be duplicate quantities-the only way to distinguish them is in the report. Example- we have an order for 43 pieces, 3 pallets are pulled, qty 5, 29 &...

Ok thanks!!!

Cool thanks! That did the trick-I had to add a suppression statement so it would only print the asterisk. I am happy!!!

Will a running totals count them only once if they are duplicate?

Greetings all, CR9, Informix Procedure, Unix database. I am trying to get my report to take the total quantity for a product and divide by the whole pallet quantity and then print an asterisk if it there is a partial pallet for that product. Basically if total qty / by whole pallet = less than...

Greetings all, CR9, no procedure, Unix database I have a report that needs to sum the total of pallet locations in one table (lc_f) but ignore the same info in the joined table (iv_f). I only need certain location types of locations which are stored in the iv_f table. These tables are joined...

Figured it out-I put the counttrailer field into group 5 and it is now counting them correctly. Yay!!!!

Greetings all again, CR9, Informix procedure, Unix database, different report, same CR newbie This report is supposed to total up trailers and give that total at the end of the report. These are the two formulas we have in the report counting trailers: countTrailers: whileprintingrecords...

Thanks! The first one worked-it was too simple, but now I know. Thanks a bunch!!

Greetings all CR9, Informix procedure, Unix database. I am having a recurring problem with getting my crystal report to see an informix datetime year to second as a date/time. Creating the problem of not being able to format the field the way I need but rather the way the expression returns...