Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Crystal Report question that isn't about SQL!

Author  Topic 

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2005-08-30 : 17:01:25
This is so completely off topic that I am certain to be banned. Congress and the European Union will probably order investigations. The United Nations called me and threatened sanctions if I posted this question.

But, I am going to do it anyway. (the UN never follows through anyway!)

Crystal Reports 9. Is there a way to import a Word2000 document and paste it into CR so that it retains the format? I have tried to insert it as an OLE object, but it only copied the first page of a large Word document.

I tried to click and drag the controls over but it wouldn't do it.

I really don't want to embed an OLE object since it won't allow me to update the fields on the form should it change. I just want the flippin' stuff that is on the Word document to show up on the CR form so I can take it from there.

Anyone have any experience doing this? Care to share?

Thanks!

Aj

Hey, it compiles.

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-08-30 : 18:19:51
Old fashioned Copy & Paste won't do the trick? How much/how fancy is the formatting you need to retain?

---------------------------
EmeraldCityDomains.com
Go to Top of Page

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2005-08-31 : 10:44:16
Unfortunately when you try to copy and paste it retains the Word document formatting and inserts it as an OLE object. Doesn't sound like a big deal until you figure out that the OLE object is like taking a snapshot of the form. And because of that, you cannot modify what you have just pasted in.

And it really isn't so much about the format. Rather this is a 6 page document and I just didn't want to try and re-invent the wheel.

Hey, it compiles.
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-08-31 : 11:37:09
If it's mostly the content you want, then I'd save a copy of the Word document as plain text, open that in Notepad and then copy & paste it in, and re-format inside Crystal. A bit of a pain, I know, but probably the best way to assure you don't get any funny/frustrating format issues. I think the formatting codes for Word and Crystal are quite different and would worry that you'd get some odd results instead of a clean translation. I could be wrong, that's just a gut instinct on my part.

---------------------------
EmeraldCityDomains.com
Go to Top of Page

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2005-08-31 : 13:35:37
Like they say, always go with your gut instinct. And what you have described is exactly what I have began doing. It is slow and a pain, but at least I will be able to update the report if fields should change.

Thanks!

Aj

Hey, it compiles.
Go to Top of Page
   

- Advertisement -