Hi Rob! I don't any way to keep the extra row from appearing. Only fix I
have found is to use the "Unmerge Cells" function in Excel, and then sort
by Object Number, which sorts all the empty rows at the bottom, and then
adjust the Row Height to something like 100 so the images don't overlap
each other. Pain to have to do this each time, and I'd love to know if
anyone has a fix for it!
--
*Fatima Mahdi*Collections Information Specialist/TMS
*Virginia Museum of Fine Arts*200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443
[log in to unmask]
On Fri, Jul 27, 2018 at 2:02 PM, Morgan, Rob <[log in to unmask]> wrote:
> 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
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>
--
*Fatima Mahdi*Collections Information Specialist/TMS
*Virginia Museum of Fine Arts *200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443
[log in to unmask]
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
