Topic: show parameter selective date Posted: 09 Sep 2009 at 11:15pm
hi. i make a 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
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.
Joined: 02 Feb 2009
Location: United Kingdom
Online Status: Offline
Posts: 8
Posted: 25 Sep 2009 at 1:40am
Hi
I have the same problem with regards to displaying dates, relating to time recording, where there is no dates. I was quite relieved to see someone else had the same problem as I am not a particularly able user of Crystal.
Would you be able to help by providing more information on the stored procedure that could be used to 'fill' in the missing dates.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 25 Sep 2009 at 6:08am
you can do an outer join to a table. you could create a temp table that has every date in it, then do an outer join to it. This will then 'fill' the missing dates, or you could create dummy records to fill the missing dates with 0 or Null entries
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