How to remove space between two rows

[anwarzamal25]

 iReport i create 4 fields;-

 

EmployeeId                                                             $F{EmployeeId}

EmployeeFirstName                                            $F{EmployeeFrstName}

EmployeeSecondName                                     $F{EmployeeSecondName}

EmployeeEmployeeAddress                              $F{EmployeeEmployeeAddress}

EmployeeAge                                                       $F{EmployeeAge}

 

 

In MYSQL Database i have 4 column,But in EmployeeAddress no values is there ok.............

 

EmployeeId             EmployeeFirstName           EmployeeSecondName            EmployeeAddress           EmployeeAge

102                                     Peter                                                    K                                                                                34

103                                       Joy                                                       N                                                                               45

104                                william                                                         K                                                                          38

105                                    Sanny                                                  V                                                                               24

 

 

when i execute query:--         select * from Employee where EmployeeId=102

then it  generate the report its comming like that,    space is comming  between EmployeeSecondName and EmployeeAge i want to reduce that space...............

 

 

EmployeeId                                    102                                                                       

EmployeeFirstName                    Peter                                   

EmployeeSecondName               K

 

 

EmployeeAge                               34

 

 

I  want to generate report like this as i shown below....i want to reduce my space

 

 

EmployeeId                                                    102

 EmployeeFirstName                                    Peter                                   

EmployeeSecondName                               k                                

EmployeeAge                                               34

 

 

in text fields properties i do this things;-

I make all fields as isRemoveLinewhenblank ='true'

position Type='float'

stretch type='Relative to tallest object'

Blank when null='true'

 

how can i accomplised this pls help any body.

thanks in Advanced