Print Page | Close Window

Graphs - How to force a group existence

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6949
Printed Date: 29 Apr 2024 at 2:07am


Topic: Graphs - How to force a group existence
Posted By: lfernandesfotos
Subject: Graphs - How to force a group existence
Date Posted: 02 Jul 2009 at 1:42pm
Hi people,
 
I'm working in a report that is causing me some problems. The case is that I'm retrieving some data that sometimes does not have the information of all groups that must exist.
 
For example, my database returns a result that allow me to have the following groups:
 
01/06 - Count 63
02/06 - Count 59
03/06 - Count 15
05/06 - Count 135
 
But I need to have the data of 04/06 with the count receiving the value 0 without the need to change my query.
 
I'll be very thankful if u coud help me!


-------------
Luiz Fernandes
lfernandesfotos@hotmail.com


Replies:
Posted By: DBlank
Date Posted: 07 Jul 2009 at 7:44am
Look around on this site for more info on this. You have to have a data source that has all of the dates, left join your other data to that and use it to group on.

Posted By: lfernandesfotos
Date Posted: 07 Jul 2009 at 7:56am
that was the applied solution. I thought that Crystal could do it without the need for other tables containing all dates.
 
But it Works. Thank You!


-------------
Luiz Fernandes
lfernandesfotos@hotmail.com


Print Page | Close Window