Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: How to get maximum of each group in crystal report Post Reply Post New Topic
Author Message
farrukh_123
Newbie
Newbie


Joined: 12 May 2010
Location: Pakistan
Online Status: Offline
Posts: 1
Quote farrukh_123 Replybullet Topic: How to get maximum of each group in crystal report
    Posted: 12 May 2010 at 11:54pm
PLEASE HELP ME FRIENDS -- IT IS VERY URGENT.

I have to make an employee attendance sheet in which i have to display only those employees which are present for 9 or more than 9 days continuously. Also here continuous means all those days on which employee is present regardless of that day, i.e whether the day is a holiday or public holiday if employee is present and it is coming in the continuous 10 days chunk then it should be displayed. Now the problem is that i am able to get the maximum working days for each employee as well as the dates from which his/her 10 date continuously present started and the date at which it ended. Now the only problem that i am getting is that i have placed all this information in detail section, and the problem starts here that all the employee records which are coming 10 or more days appears with an unusual format e.gEmpId  EmpName                WorkingDays        DateFrom        DateTo34         Hassan Ali                    10                   8/22/2008     8/31/200835         Muhammad Khalil         10                   8/1/2008       8/10/200835         Muhammad Khalil         11                   8/1/2008       8/11/200835         Muhammad Khalil         12                   8/1/2008       8/12/200835         Muhammad Khalil         10                   8/18/2008     8/27/200835         Muhammad Khalil         11                   8/18/2008     8/28/200835         Muhammad Khalil         12                   8/18/2008     8/29/200835         Muhammad Khalil         13                   8/18/2008     8/30/200835         Muhammad Khalil         14                   8/18/2008     8/31/2008now i only want to retrieve the maximum of these working days for each employee id i.e only the following record should be displayedEmpId   EmpName             WorkingDays       DateFrom       DateTo
34         Hassan Ali                    10                   8/22/2008     8/31/200835         Muhammad Khalil         12                   8/1/2008       8/12/200835         Muhammad Khalil         14                   8/18/2008     8/31/2008Please help me as it is urgent, because it is an assignment given to me by my boss and already the task has gone into a long delay. Please help me
URGENT PLEASE HELP ME FRIENDS -- IT IS VERY URGENT AND IMPORTANT.

Edited by farrukh_123 - 16 May 2010 at 7:23pm
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.