Search results for query: *

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...

Hi, I am having a problem in creating a report meeting my criteria: I am using crystal reports 8.5 The tables I am using for the report are: 1. Employee 2. Assignments The primary field in the employee table is ID The primary field in the Assignments table is ID. both are linked. The Data in...

Thank you Anderson, But by creating the formua and counting, will I get the latest record in each group which has a closed date of 1753? Can you show me how to create them and where to place them? and also I need to display the NAME field from the employees table. the report should look like...

Hi, I am having a problem in creating a report meeting my criteria: I am using crystal reports 8.5 The tables I am using for the report are: 1. Employee 2. Assignments The primary field in the employee table is ID The primary field in the Assignments table is ID. both are linked. The Data in...

Thanks a lot synapsevampire and Ido. I got the results i wanted. Thank you very much for your help. pandy

Thank you Ido, but I am not getting my results. I created two formulas: @Id200 :if ({ID}=200) then 1 else 0 @Id201 :if ({ID}=201) then 1 else 0 Then in the group selection: I wrote this: ({@Id200}+{@Id201})<>0 I am getting the records with either function ie., with 200 or 201. I want id's...