Print Page | Close Window

Advice On Dates / Information

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10432
Printed Date: 27 Apr 2024 at 4:54pm


Topic: Advice On Dates / Information
Posted By: Lord Yorkshire
Subject: Advice On Dates / Information
Date 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
 


Replies:
Posted By: rahulwalawalkar
Date 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


Print Page | Close Window