Recent content by vngpal

I have a table Emp. Each employee is assigned to a manager and each manager is assigned to another manager above the employee. This level may go upto 4 or 5 levels. Some employees may not have a manager assigned to them (for instance test employees and also the department head). The data is...

Thanks for the response. I appreciate your help. Let me think anything else is possible. Have a nice day. Pal

Both. For example: Group1 (GYNANES) Group2 (Date in ascending order) Group3 (Patient Number) Group1 (GYNSURG) Group2 (Date in ascending order) Group3 (Patient Number) This is how the data should be displayed. Thanks, Pal

Thanks for the info. The dates may range from any start date to end date based on the user selection. So I have to add either date range parameter or two parameters as startdate and enddate. But the grouping should be as mentioned in the previous post. Thanks, Pal

LB, One more addition to this. Now my manager wants to get the data for a date range period. Also he wants the group should be as below. The above works fine if I don't have another group. But the situation is different and wants to add another group. Group1 (New Site) Group2 (Date)...

My bet. I made some error. Yours works fine. Thanks a lot. Pal

Thanks for the solution. It works fine but not for the last patient, As per the sample data 327441 has to come under GYNANES but it shows up in GYNSURG. Otherwise your solution works h=great. Any idea? Thanks

LB, I am soory that I could not send the sample in time. Here is the sample. Original group order Group(Site) GYN Pt NODE ST ET 100012 1121 100012 1223 7.00 8.00 267120 1121 5.15 6.45 267120 1223 267345 1121 3.47 8.45 267345 1223 2.32 3.01 289410 1121 2.23 3.51 289410 1223 1.55 2.15...

Hi All, I need to create new groups based on some criteria mentioned as below. I am using CR8.5 and SQL Server database. The database is set as below. Site is the top order and can have Gyn, Neuro, Cardio and so on. Under the Site lot of patients are admitted. Under each pattient...

Thanks. Let me try. Pal

It is an example only. That is nothing to do with the scnario. Since that was not clear enough I have explained the scnario. Thanks. pal

Thanks for the feedback. Here is the scnario. I have a patient_table with patient number for each patient admitted. I also have logged_procedure table with patient number and procedure fields. In the logged_procedure table one patient can have one or multiple procedures. Similarly I have...

Below is the example This formula is created in subreport. //@City Shared StringVar City := ""; City := {table.fieldname} In the main report I have created a formula like this. //@City Shared StringVar City; Let me know if you need any further info. Thanks, pal

Hello, I am using CR8.5 with SQL Server database. I have a main report with subreport. In subreport I have one group and for each group there may be 1 or multiple detail lines. When inserting the subreport into the main report I am able to see one or multiple detail lines as per the group...

Thanks. Let me try.