export excel blank space 1

[Durango122]

hello
CR XI
sql databse
i have a report and my data is fine when preview in cr
but when i select export to
Microsoft Excel 97-2000-data only(xls)
my data has some blank rows between some of my records
example
1 3 5
2 5 3
4
5
6 8 9
7 1 3
8
9 4 5
what could be the cause????????????


Durango122
Remember to used all fingers when waving to policemen

 

[lbass]

Try selecting all of the row fields->format->make same size->height. It also helps to have the fields snapped to horizontal and vertical gridlines.

-LB