Forgot password? | Forgot username? | Register

Exporting to Word with images?

Exporting to Word with images?

Hi folks
I'm trying to put together a report which has field data down the left side, with the relevant image to the right. No problem - in Crystal I have the image right-aligned in a details section which underlays following sections.

The issue is it needs to be edited afterwards, ideally in Word. However when exporting the "underlay following section" doesn't work - the image is displayed on its own row/line.  I guess what I would like to see would be a Word document with columns, text in the left column and image in the right. But I don't know how to do this, if it's possible. Anyone know how to achieve what I'm after?

I might see if I can somehow include a combination of characters in the report, and write a macro in word that will convert them to column breaks - but surely there's a better way?

Another option might be export to HTML, but I can't get the resulting html file to display the images. Any clues?

Mark

Mark Bradley – Assistant Registrar, Documentation (EMu)
National Gallery of Australia

Mark Bradley
Assistant Registrar (EMu Guy)
useravatar
Offline
147 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Exporting to Word with images?

Can you export to the regular Microsoft Word RTF format rather than the Microsoft Word RTF Editable format?  It puts all of the text into text boxes, but I find that it keeps the formatting much better and the text is still editable.
Kara

*************
Kara M. Lewis
Collections Information System Administrator/Analyst
National Museum of the American Indian, Smithsonian Institution

Kara Lewis
CIS Administrator/Analyst
useravatar
Offline
39 Posts
Female  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Exporting to Word with images?

Hi Kara - thanks for the reply, much appreciated.

You are correct, the RTF format does retain the layout, but loses the flexibility of (painlessly) editing afterwards, which is sadly quite important for this particular report.

I've had a go today at putting <startcolumns>, <endcolumns> and <columnbreak> tags in the report so that a macro can be written in word to apply the column formatting where we want it. Sadly the visual Basic part of it is beyond my skills. I've got someone else possibly looking into that, as it will be pretty much perfect if it works. Shame we can't do this through Crystal directly though.

Mark Bradley – Assistant Registrar, Documentation (EMu)
National Gallery of Australia

Mark Bradley
Assistant Registrar (EMu Guy)
useravatar
Offline
147 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Exporting to Word with images?

Made a cool discovery yesterday, thought I'd share. You can convert text boxes in Word to normal text very easily.

Control-Q is the shortcut for "remove paragraph formatting". This turns a selected text box into normal text (not in a text box).
Control-A selects a whole document, including text boxes.

Therefore, export a Crystal Report to MS Word RTF (not editable RTF), then Control-A, Control-Q, and presto, text becomes editable. Any images will be converted to "Behind Text" layout, with "other" as the horizontal alignment, meaning you can simply drag the images areound to reposition them where you want them.

Be warned, this is not a perfect solution. White spaces between the text boxes disappear, and all the text will align to the left margin. Knowing this in advance, for any reports that you know will be exported to word for subsequent editing, design your report with empty text boxes to create the necessary white space in your report. These convert to blank text boxes when you export, which then convert to empty paragraphs/lines when removing the text boxes. You will almost certainly need to do some manual formatting, but at least you will be close. An alternative to editable RTF, anyway.

Hope others find this useful.

Mark Bradley – Assistant Registrar, Documentation (EMu)
National Gallery of Australia

Mark Bradley
Assistant Registrar (EMu Guy)
useravatar
Offline
147 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.
There are 0 guests and 0 other users also viewing this topic

Board Info

Board Stats
 
Total Topics:
601
Total Polls:
0
Total Posts:
1362
User Info
 
Total Users:
827
Newest User:
Marcus Swann (Axiell Melbourne)
Members Online:
2
Guests Online:
152