Search results for query: *

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.

For each patient name(group5) there are multiple times. Since I need the maximum time I have to use the maximum on room time formula for each patient(group5). The delayed minutes are the difference between two times and the result is a number. Here is the logic. Each room will have multiple...

@RoomTime is the Maximum(roomtime, ptname(group5field)) and the {fieldname} is the database field. Yes you are correct. Elapsed time is like dateDiff and calculates the time differece between two times. Any other info needed? Thanks

I am sorry. There is no group 6 or 7. The results are shown in group footer 5 only. Formula. @{@delayed minutes} if Maximum ({@Room_Time}, (group5namefield)) > {fieldname} then elapsedtime({fieldname},Maximum ({@Room_Time}, {group5namefield})) else 0 Thanks

Report version: 8.5 Database: SQL server Hello, I have a report with the following groups and I have data as shown below. Group1 Site Group2 Room Group3 Service Group4 Surgeon Group5 Patient Below is the data I am getting from the database. The values are displayed in Group5 footer as per...

Thanks for all your reply. This is not just beacuse of Word wrap in notepad format or printer setup. When all the data are not word wrapped only the first line of the Group1 is wrapped. If its is because of word wrap format or printer or page setup how the other lines are not wrapped? I feel it...