Search results for query: *

LB, you are the best! Well, there might be a different way to solve this issue. May be write some PLSQl or something, but I am not well versed with oracle. Let me try explaining:A Company buys bonds for its employees.In order to do that, a deduction amount set by an employee(which has no...

@number: numberVar amntReached; Select {table.deduction} Case "$50" : if NextIsNull ({table.DED_AMT}) then if {@Balance} = 50 then amntReached:= 50 else amntReached:= 0 else if next({table.DED_AMT}) + {@Balance} >=...

The problem all through out has been that {@calc} <> previous({@calc}) will give @calc does not have previous or next value.

What if I want to perform something on first occurence of each number: @linenumber @calc @number @variable ----------------------------------------- 1 0 0 25 2 0 50 3 1 0 25 4 1 50 5 2 0...

LB, Thank you so much for all your help. I think I will have to play with this some more. Your suggestions have been extremely helpful.

I would have suggested group in 'specified order' and then first show only records from Jan-Dec and a second group showing only records from Q1...Q4. In your first group from Jan- Dec, go to 'Others' tab which gets enabled when you select 'specified order' and select the option: Put all others...

You are absolutely correct. I got the picture. Basically, remainder = balance and we need to determine the possible values. This will not work: Case "50" : if remainder(amtx,50) = 0 then 50 else 0 since if you notice my example above, Type= 50 worked for...

Thank you LB for all your help. It seems to be there, but still not there yet! We will have to refine the logic further since i am using the same logic as u suggested to build 3 cases: whileprintingrecords; numbervar amtx := amtx + {PAYDEDUCTN.DED_AMT}; Select {pay_type} Case "25" : if...

Is there a way that I can force the balance calculation to complete first, so that I could use previous(balance). I did try : EvaluateAfter({@Balance}); if {@amountreached}+previous({@Balance})>= 25 then x:= 25 else x:= 0; x; but it throws an error that @balance: "This field has no...

please try the following: whileprintingrecords; numbervar x = 0; if month in ["Jan","Feb","Mar","Apr","May",....,"Dec"] then x:= x + sales else x:= x+ 0

Thank you LB. It works :)

LB: I did try your suggestion namely: if amount + {@Balvar} >= 25 then amntReached:= 25 else amntReached:= 0; and here is the output: 1 10 10 0 01/01/2001 1 10 20 25 02/01/2001 1 10 5 0 03/01/2001 1 10 15 25 04/01/2001 1 10 0 0...

Thank you Lbass and rob11nj for replying. Lbass: I can't use current amount and current balance to perform calculation because if I implement your logic, then I would obtain 25 in line 2 and not line 3, as depicted in the example. rob11nj: You are exactly right. This is exactly what I have...

I have a calculation (formula) in the details section, whose output looks like the following: @count -------------- 0 0 1 2 2 1 What I would like to do is perform a calculation such that if there is a first occurence of '2' then perform a calculation, else if it is a...

Can any one help me. Thanks

Sorry for not being clear in my earlier post. Crystal version: Crystal 10 Database/version/connectivity: Oracle 9 Example data (not examples of something in the report that you DON'T want) For eg, an employee set a benefit account = $10 So, every month, company would deduct $10 from...

I have a formula which is displaying 'A' or 'B' based on some criteria. But, I noticed that the output is getting displayed by 1 row. For example @form1, 1 A 2 B 3 A 4 B 5 B Output should have been @form2: 1 B 2 A 3 B 4 B 5 A Is there some way where I can force it to show in the next row...

I have been trying to achieve the following. Considering Feb as the beginning of fiscal year, For i:= 1 to 12 do // i= month 1 - 12 if month=Feb then %age = Number of employees terminated % Total Headcount of employees for Feb else %age = current month %age +...

HoHoHo, Hearty congratulation for passing 201. How was the test like? What material did you use to prepare for the exam? thank u

please don't bother. I got this sorted out. Thanks Tek-Tips