Tips and Tricks
 Crystal Reports Forum : Crystal Reports .NET 2003 : Tips and Tricks
Message Icon Topic: dates missing Post Reply Post New Topic
Author Message

Joined: 13 Feb 2008
Location: El Salvador
Online Status: Offline
Posts: 2
Quote Yimha Replybullet Topic: dates missing
    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!





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

Yimha Yumark
IP IP Logged

Joined: 23 Apr 2008
Location: Canada
Online Status: Offline
Posts: 12
Quote Zorgov Replybullet 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!
IP IP Logged
Admin Group
Admin Group

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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.
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.