Search results for query: *

Thanks Ibass, it works perfect. My example represents data for one day. I have data for more days and are grouping by day. I have tried to reset the maxend value in the Group Header with: @reset whileprintingrecords; numbervar maxend:=0; But the calculation continues with the maximum maxend...

Hi Everyone, I need help CRW 8.5 on SQL Server. I have the following data set: Start End Lane RT_NR Diff (NR) 10,00 17,00 NR 17 14,00 15,00 NR 17 14-17= -3 16,00 19,00 NL 17 18,00 20,00 NR 20 18-17= 1 21,00 24,00 NL 20 23,00 25,00 NR 25 23-20= 3 23,00...

Hi Ngolem The RECIEIPT works ok, but I still have a problem with the ISSUE part. With qty <=7 in line 3, ISSUE part, gives the right result : Lot issue date qty price curbal value A RECEIPT 01-12 7 10 7 70 B RECEIPT 02-12 4...

Thanks a lot Ngolem, I regret my late response, I just got back to the office today. Yes, my problem is to calculate the Value and curbal of products in the storeroom. Yes, date is more important than lot. We will receive not more than one shipment (Lot) per day of each Product ID, so I...

Thanks for your reply dgillz and Madawc My problem is to make a formular to calculate the actual store value on the latest record date (newest)In my example, 5. Dec, where the field Issue = ISSUE. The formula should be something like: If curbal (line 5) <= quant (line 4 ) then curbal (line...

Hi Everyone I want to calculate the store value, based on the “first in - first out principle” for each item. When items are issued the earliest(oldest) items are taken from the store. lot issue date quant price curbal value A RECEIPT 01-12 7 10 7 7*10=70 B RECEIPT 02-12 4...

Just perfect - - Thanks you for your reply basil3legs. Yes, cur_bal is a running total of the quant field. The formula gives the right value on this example, but it is not a god example. Yes, it is unclear what happens if the u_price is 24 of instead of 20 in line 7, and I will try explain...

Hi Everyone, I need help I have the following records in a table and want to calculate the last column “value” The calculation is dependent of the change of ‘issuetype’ RECEIPT. Item issuetype date quant u_price cur_bal value 0001 RECEIPT 01-09 12 20 12 12*20=240 0001...

Thanks Ibass, your assistance has helped me greatly. I did a slight modification to your formula, as the recent rating sometimes is more than one month old: {@sumMar}: if sum({@Mar},{table.GLAcct}) >0 then sum ({@Mar},({table.GLAcct}) else if sum({@Feb},{table.GLAcct})>0 then...

Thanks again Ibass I have tried your proposal which gives the following output: JAN-03 FEB-03 MAR-03 APR-03 MAY-03 JUN-03 JUL-03 (GH1) 1111 ----------------------------------------------------------------------------- 1111 0 0 0 0 0...

Thanks Ibass Ok I’ve made 8 formulas starting with{@Dec}, (data starts in dec) and group on GLAccount and inserted summaries on these formulars {@Dec} if {KLA_RATING.RATINGDATE} in dateadd(&quot;m&quot;, -8, date(year(currentdate),month(currentdate),01)) to...

Report output again! Rating Glaccount JAN-03 FEB-03 MAR-03 APR-03 MAY-03 JUN-03 JUL-03 1111 4 3 3 3 4 4 2 2222 3 3 3 3 2 2 1...

Thanks for your reply synapsevampire. Ups, formatting problem on Report output columns, the rating values have slipped to far to the left side, I will try again: Rating Glaccount JAN FEB-03 MAR-03 APR-03 MAY-03 JUN-03 JUL-03 1111 4 3 3...

Hi Everyone, I need help ! I have the following records in a table: GlAccont Rating Ratingdate 1111 4 22-JAN-2003 1111 3 13-FEB-2003 1111 4 05-MAY-2003 1111 2 06-JUL-2003 2222 3 12-DEC-2002 2222 2 07-MAY-2003 2222 4...