Just to add that we have difficulty with this too-
For us, the extra lines appear when exporting images, and also where we have multiple entries for a single dimension type.
We can clean the data for dimensions to address the later, but when exporting a report with images to Excel we have so far not been able to export without seeing the additional lines. It is fairly straight forward to strip out the empty rows a batch at a time and address the count for the objects manually, but not ideal as this can be timely depending on the size of a report. We do however have something we can work with.
Jennifer Hicks
Assistant Registrar
[https://www.henry-moore.org/images/HMFverdigris.gif]<http://www.henry-moore.org>
Henry Moore Foundation
Dane Tree House
Perry Green, Much Hadham
Hertfordshire SG10 6EE
United Kingdom
+44 (0)1279 843333 ext 206
[log in to unmask]
www.henry-moore.org<http://www.henry-moore.org/>
This message is confidential. If you have received this message in error, please contact the sender immediately by returning the e-mail or by telephoning +44 (0) 1279 84 3333. Please then delete the e-mail and do not disclose its contents to any person, to do so could be a breach of confidence. The Henry Moore Foundation does not accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software. The Henry Moore Foundation is a limited company registered in England (No.01255762), registered charity (No. 271370), registered office as above. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of The Henry Moore Foundation.
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Munro, Jeremy T.
Sent: 27 July 2018 19:06
To: [log in to unmask]
Subject: Re: Exporting Images from Crystal to Excel
Hey Rob,
Believe it or not I’ve had some success with setting the font of fields to extremely small font sizes (like 1pt) so that longer fields like medium etc. take up only one line instead of two. Once in excel you just set the font of all cells to something readable.
It’s not perfect by any stretch of the imagination, but it sometimes gets you over the edge toward something usable. I don’t know if it would work with images though.
Jeremy Munro
Database Administrator
National Museum of African Art
Smithsonian Institution
[log in to unmask]<mailto:[log in to unmask]>
202.633.4784
From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Morgan, Rob
Sent: Friday, July 27, 2018 2:02 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Exporting Images from Crystal to Excel
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 ☺.
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]<mailto:[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.
To unsubscribe, send an email to [log in to unmask]<mailto:[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.
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.
|
