Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Date Range - Entry for each date Post Reply Post New Topic
Author Message
kdj00
Newbie
Newbie


Joined: 20 Aug 2010
Location: Switzerland
Online Status: Offline
Posts: 2
Quote kdj00 Replybullet Topic: Date Range - Entry for each date
    Posted: 20 Aug 2010 at 9:20pm
Hello
I have data exported for a date range. The data is grouped by that date. For some dates there is no data so there is no entry for that day. Is there some way I can create the report to show an entry for each day in the date range, even if there is no data?
 
Something like this.
Monday January 1
Widgets 6  $6.50
 
Tuesday January 2
No entries
 
Wednesday January 3
Widgets 8 $9.80
Bananas 7 $8.30
 
 
Thank you!
kdj00
IP IP Logged
kdj00
Newbie
Newbie


Joined: 20 Aug 2010
Location: Switzerland
Online Status: Offline
Posts: 2
Quote kdj00 Replybullet Posted: 20 Aug 2010 at 9:58pm
Please note that the date range is entered in a query on the original database. I have transferred 2 parameters from that query:
 
startdate
enddate
 
I would need to set up the report to group on that date range i.e. the values from / to the parameters.
 
Any ideas? Thank you!!
kdj00
IP IP Logged
sukhveer
Newbie
Newbie


Joined: 18 Aug 2010
Online Status: Offline
Posts: 22
Quote sukhveer Replybullet Posted: 22 Aug 2010 at 8:11am
you have to write 3 formulae
1 for date....
whileprintingrecords;
if not isnull({Data_.Date}) then
{Data_.Date}
else
{?start date} + recordnumber;
2 for Entry
WhilePrintingRecords;
stringvar ddd;
if not isnull({Data_.Entry}) then
ddd := CStr ({Data_.Entry})
else
ddd := 'No Entries';
ddd;
3 for details section
Go to section expert -> select details -> write a conditional formula for supress
{Data_.Date} < {?start date}
or
{Data_.Date} > {?end date};
 
----let me know if you have any quesions.
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.016 seconds.