CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    5

    show parameter selective date

    hi.
    i make a InOut Time report which have 3 parameters (1) employe id # (2) todate (3)fromdate;
    i select employe id "111" , todate(1-sep-2009) and fromdate(09-sep-2009) report show all data of employe of given date like this..
    ATT_DATE ID TIMEIN

    1 Sep 09 111 8:22
    3 Sep 09 111 8:24
    4 Sep 09 111 8:15
    6 Sep 09 111 8:25
    7 Sep 09 111 8:22
    9 Sep 09 111 8:24

    one problem in my report is that 2 sep,5 sep and 8 sep is not shown in my report becouse employe is absent in these days. i want to show all date 1 sep 2009 to 9 sep 2009.

    hope u understand my question


    thanks in advance

    jawad kahtri

  2. #2
    Join Date
    May 2003
    Location
    Islamabad, Pakistan
    Posts
    284

    Re: show parameter selective date

    Seems the report is picking the data from server which has only records when employee is present. It does not contain the records for the days when he or she is absent.

    If this is the case then you have to follow some different approch .....

    e,g. keep the month in mind and show all of its dates and compare if a record for a date is there then mark it as present other wise marke it as absent. You have to do some tricks.
    If this post is helpful, then, Rate this Post.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured