crystal reports

[Juan]

Hi.

I need to create a report grouped by numbers that can be or not in the database.

Ex.

Table

Code Value
2 100
3 100
6 100

I need group in Code but using all numbers as follows:

Group Code=1
Value=0

Group Code=2
Value=100

Group Code=3
Value=100

Gropu Code=4
Value=0

Group Code=5
Value=0

Group Code=6
Value=100


How Can i do this???


Thanks in advance

[jcfowl]

Is the data all from one table??

[Juan]

Yes.

The data is in one database, but there is no

Code=1
Code=4
Code=5

and i must show that groups with no value.

Thanks.