Search results for query: *

Those 3 attributes are also housed in the Transaction_History table, so this can serve as the look-up table. In addition, the Transaction_History table can be queried for quantity processed daily by noting the daily sub_total change at each stage. Other relevant attributes found in the tables...

Thank you for responding! I am running Crystal Reports XI, using ODBC of course... 1. ORDNUM - lot number - string 2. OPRSEQ - each unique stage number e.g A, B, etc - string 3. QTYREM - number of items remaining in each lot - double All 3 attributes are housed in the same table...

I would like to produce a report that shows the Lots to be processed daily. My environment is as follows: 1. Each Lot goes through all the different stages of production - 5 stages - namely; A, B, C, D and E 2. Each lot contains anywhere from 1 up to 40 items 3. At any given time each stage...

Thanks K, it worked. B

K: Thanks for the tip but I am still unable to resolve this issue as I am new to Crystal syntax. I am not sure how to correctly add your tip within the @TotalValue formula context. @TotalValue is calculated as follows: select {Job_Progress.OPRSEQ_14} case "200": 1 * 1.83 * Sum...

I am trying to obtain the sum of a field object, @TotalValue, but have been running into some problems. My report contains one group only: i) Group header is blank. ii) Details section is suppressed. iii) Group footer shows fields, sum of Job_Progress.QTYREM_14, @LaborTime...