Hello everyone,

 

I have a report that exports images and data from Crystal to Excel.

 

Any time there is more than one line of text in a field’s value, an extra row is added to Excel.  This only happens when exporting from Crystal to Excel with images.

 

Thus, for this report to work, I have to make the width of the fields very wide, and the font very small, and not check Can Grow.  Not an ideal solution J.

 

Does anybody have a fix for this?  To prevent the extra rows from appearing in Excel?  I know this report would work well in SSRS, however we’re in TMS 2012 and not SSRS compatible, yet.

 

Thanks,

Rob Morgan

Smithsonian Institution

Office of the Chief Information Officer

IT Specialist in Data Management and Systems Administration