Skip to Content
0
Former Member
Jul 03, 2009 at 02:12 PM

How to force a group existence

25 Views

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