Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: How to generate all days in a date range Post Reply Post New Topic
Author Message
Najeeb
Newbie
Newbie


Joined: 21 Apr 2008
Location: India
Online Status: Offline
Posts: 6
Quote Najeeb Replybullet Topic: How to generate all days in a date range
     Posted: 11 Dec 2008 at 3:28am
Hi
 
 
I want to display an attendance register for each day in a month (01 thru 31) in a report.
SQL table has only one field of date for which present is registered. (Date for which preson absent is not stored in table)
But  I want to show these absent dates along with  present dates in sequence starting form 1st of month up to last
 
If any one know the trick please help me
Thanks in advance
 
 
IP IP Logged
AntDC
Groupie
Groupie
Avatar

Joined: 23 Dec 2008
Online Status: Offline
Posts: 76
Quote AntDC Replybullet Posted: 05 Jan 2009 at 6:47am
What DB are you using?

You could write a funky query using DUAL if using Oracle
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.