Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Graphs - How to force a group existence Post Reply Post New Topic
Author Message
lfernandesfotos
Newbie
Newbie
Avatar

Joined: 02 Jul 2009
Location: Brazil
Online Status: Offline
Posts: 25
Quote lfernandesfotos Replybullet Topic: Graphs - How to force a group existence
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
lfernandesfotos
Newbie
Newbie
Avatar

Joined: 02 Jul 2009
Location: Brazil
Online Status: Offline
Posts: 25
Quote lfernandesfotos Replybullet 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
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.