Print Page | Close Window

dates missing

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
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=2811
Printed Date: 29 Apr 2024 at 5:53am


Topic: dates missing
Posted By: Yimha
Subject: dates missing
Date Posted: 03 Apr 2008 at 6:46pm

When I am summarizing a record and grouping it by dates, I would like to show ( in the date range selected) the dates without a result. But grouping, just show the dates where were found a record. Could you please give me a clue!

 

{invoice.amount}

{invoice.date}

 

Grouping by March 2008. You will just show the dates where an invoice was made. But,  the others?



-------------
Yimha Yumark


Replies:
Posted By: Zorgov
Date Posted: 11 Jun 2008 at 10:17am
Hi Yimha,
 
I have the same problem as yours. We can say that this problem is "normal" because we use the data grouping. When you group, you group the data you read, so if a date has no data, you won't have a group for it. It's logical.
 
My solution would be to create a new formula for grouping, with variables.
 
It would look like this:
 
For each date, if a record is in this date, datevariable + 1 (or amountvariable + invoice.amount).
 
The problem with this is that you will need a different variable for each day of the month and then do a formula to display each variable... this means a lot of formula...
 
if someone as another solution, please tell us!

Posted By: hilfy
Date Posted: 14 Jul 2008 at 1:02pm
The most common solution to this problem is to add a table to the database that contains just a date field.  Add all of the dates in the year to this table.  Use this in your report with an outer join and use the date field from this table as your group.
 
If your dates have times in them, this becomes a little more problematic.  However, it can be done using a command text that also uses the date table.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window