Recent content by pandy1

Thank you Anderson for your help, I tried another method and got the report. I will try this also later. pandy

Ken, At last I figured out the problem. Some record numbers are more than 5 digits. So I added another zero for record number in all the formulas. Then It worked out very well. Thank you very much ken Hammady for your kind help. Pandy

Yes, But I have taken out the table name in the formula. Thanks Pandy

Yes, I copied the exact formulas.

No, I added table names to the original formula. I am unable to understand why it is not picking up all the records. Thanks Pandy

group selection formula: (Maximum ({@NewUnit100}, {ID}) [ 6 to 15 ] = "1753-01-01") and ( (Maximum ({@NewUnit125}, {ID}) [ 6 to 15 ] = "1753-01-01") OR (Maximum ({@NewUnit126}, {ID}) [ 6 to 15 ] = "1753-01-01") or (Maximum ({@NewUnit127}, {ID}) [ 6 to 15 ] = "1753-01-01") or (Maximum...

I think its not picking up all the records because we have only group i.e, ID but we are comparing each unit in that ID group. Because we have group selection formula, so its calculating for the whole ID group instead of each unit. Please help me in this report. thanks pandy

I tested it, its not picking up all the records. for example I have an employee with unit 100, and unit 125, with date closed is 1/1/1753. Its not picking up that record. It has each record for each unit which are latest with date closed is 1/1/1753. there are no records with others units...

Thank you Ken Hammady, Its brilliantly working. I will let you know once I am done with complete testing. once again thank your very much for your help. pandy

sorry, that error is because of brackets...I fixed it..

I added(putting all other units etc.,)the same way you explained, When I save the group selection formula I am getting the error :"A number, currency amount, boolean, date, time, date-time or string is expected here". The data types are: Unitid - smallint recnum - decimal closeddate -...

I have total 6 units to filter for this report. But if I know how to work on, then I may add the other units. thanks pandy

Yes, a Unit can be Open but may not be the last record for that unit. That means it previously open and now its closed. Thanks Pandy

Thank you AndersonCJA. I did not understand completely. I created 3 groups as you said. Then you said create the number fields. what do you mean by that? and also you used RunningTotal1, RunningTotal2 etc., what are those RunningTotals? Can you please explain? thanks pandy

I will explain once again. 01. Employee should have a unit 100 (the latest record should be Open in unit 100, i.e., date should be 1/1/1753, date is significant) and any other unit(125,126)latest record has a closed date of 1/1/1753. The latest record means not for the whole employee record...