issue with cangrow

[Former Member]

hi forum

i have problem with cangrow?. i have two fields like Vehicle id and CUSIP. Vehicle ID is having multiple lines of data(can grow filed) where as CUSIP has only one line. when i export this report into excel,. Cusip column contains rows accoroding to the VehicleID. how to set increase the height of cusip according to the CanGrow field.

please tell me

[Former Member · Accepted solution]

Set the field to not grow so you only get one line. The data will still be there when you export it to excell and you will be able to see it by expanding the cell and/or wrapping the text in the cell.

[former_member260594]

Hello rahulbo,

Have you tried exporting to MS Excel (97-2003) Data Only? This should place the Vehicle ID into 1 row.