Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: show parameter selective date Post Reply Post New Topic
Author Message
mjawadkhatri
Newbie
Newbie
Avatar

Joined: 09 Sep 2009
Location: Pakistan
Online Status: Offline
Posts: 14
Quote mjawadkhatri Replybullet 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

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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 10 Sep 2009 at 7:03am
If this is all in one table, you can't, not by joining to the table directly...Crystal will not make up data, it will only display what is there.
 
If you use a stored proc, you can 'fill' in the missing dates.
 
HTH
IP IP Logged
Darren
Newbie
Newbie
Avatar

Joined: 02 Feb 2009
Location: United Kingdom
Online Status: Offline
Posts: 8
Quote Darren Replybullet 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.
 
Kind regards,
 
Darren
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet 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
 
HTH
IP IP Logged
Darren
Newbie
Newbie
Avatar

Joined: 02 Feb 2009
Location: United Kingdom
Online Status: Offline
Posts: 8
Quote Darren Replybullet Posted: 25 Sep 2009 at 7:25am

Thanks for your help.

Regards
 
Darren
IP IP Logged
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