Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Advice On Dates / Information Post Reply Post New Topic
Author Message
Lord Yorkshire
Newbie
Newbie
Avatar

Joined: 04 Jul 2010
Online Status: Offline
Posts: 28
Quote Lord Yorkshire Replybullet Topic: Advice On Dates / Information
    Posted: 05 Jul 2010 at 2:43am
I am fairly new to using crstal reports and this is also my first time on the forum, ( so go easy on me if i look like a numpty )
 
I want to do a report on our deliveries out, sales in and production made. all three operate over a different timespan.
 
This is how i want the report to look
 
               del        sales      prod
01/01     456       459        983
02/01     765                     133
03/01
04/01     456       458
05/01     888       632        123 
06/01
 
so even when there are no figures, i want the date to appear.
 
What would be the best way to achieve this.
 
Regards
David
 


Edited by Lord Yorkshire - 05 Jul 2010 at 2:44am
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 05 Jul 2010 at 3:20am
Hi
 
I would suggest, to
 
*Create a separate Table with Date Entries and ID field.
*The ID should be same which relates to the deliveries out, sales in and production  (common field)
*Then just use that date tables to display values for all the dates, this way you can popluate data for missing dates and rest columns will be null if no data exists for that date.
 
Also please search for the post
 
List individual dates between two date parameters
 
Cheers
Rahul


Edited by rahulwalawalkar - 05 Jul 2010 at 3:26am
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.031 seconds.