Group expression not printing the next record

[Titty_Thomas]

 Hi All

 

I am facing a peculiar problem

 

I have following data in DB

 

Code      Month   Country

A1                         01               India

A1                         02                          Pakistan

A1                         04                          Finland

A1                         05                          Japan

B1                       03                              USA

 

Now I want the report as below

 

Code              Jan               Feb                Mar                             Apr          may

A1                   India           Pakistan                                          Finland       Japan

B1                                                                 USA

 

 

Issue is it taking the month as May   and not printing other values

Code              Jan           Feb      Mar      Apr          May

A1                                                                                                                 Japan

 

 

I am currently using the variable condtion as $F{Month}.equals( "05" ) ? $F{Country}:"". I am also using Group expression as Code. Is there any other way to handle the same

 

Thanks

Titty