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