If group is specified in certain categories, some specified group categories does not appear on the report when it has  0 value.

 

For example, there are three categories saying "A", "B", and "C".

The report should look like this,

       male      female

A      5           10
B      3            8

C      0            0

 

but, the actual CR report looks like,

 

My joins and select statement do not exclude the "C" value.

The problem is the group order(?) is specified as "A", "B", and "C", and each condition type value is 1, 2, and 3 respectively (for example).

say, if there is no 3 type values in DB table then "C" does not show up as mentioned in the qestion.

 

Simply, how would I show "C" on the report even though there is no such "C" related value so that the report look like:

       male   female

A        5          3

B        2          1

C        0          0

 

Thanks

 

 

 

let me give you the detail example,
DB table has
 
FIELD_1
SEX
VALUE
DATE
 
FIELD_1 includes (1, 2, 3) .
Assume that report takes selection and join properly.
The reports takes start and end date parameters.
Given start and end date interval, FIELD_1 includes only (1, 2) not 3.