Solved

export to MS Word .doc, copy and paste formatting problem

Posted on 2004-04-25
9
558 Views
Last Modified: 2010-05-18
I have a C# Windows application (MS DevStudio 2003) linked to an MS Access 2002 database.  I export data to a Microsoft Word document (.doc) successfully.  However, when I copy and paste that report to another Microsoft Word document, some of the formatting is lost and some fields and divider lines from the Crystal Report generated MS Word document incorrectly underlay when pasted to the new MS Word document.

I have updated using the weekly hot fix, although I did read something in this article: http://support.businessobjects.com/library/kbase/articles/c2013041.asp
This article stated I need to be using Crystal Reports version 9.2.2.x.  My CR is bundled and I do not see a version number anywhere in the MS DevStudio about box.  I am wondering whether you could point me in the right direction.

I am not certain whether I have a programming error or a CR design error or something else.  Perhaps the question is easy for you, but it has been a sore spot for me.

Ray Salvo
Software Engineer
0
Comment
Question by:raysalvo
9 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 10914394
If you have the version that came with Visual Studio, you have CR.Net which is a subset of CR9.  The hotfix may not be applicable.

Check for hotfixes for CR.Net.  Check whether you have CR.Net or CR.Net 2003.

mlmcc
0
 
LVL 42

Expert Comment

by:frodoman
ID: 10918894
Sounds like you've got the .Net version (with Visual Studio???).  If so you need this hotfix instead: http://support.businessobjects.com/communityCS/FilesAndUpdates/crnet11win_en.zip.asp

0
 

Author Comment

by:raysalvo
ID: 10919948
OK, well I did try downloading and installing the hotfix yesterday afternoon.  It may have fixed some problems but did not fix my formating problem.  I do have a request in with the Crystal Reports group and their representative is going to be sending me a link to download CR 9.2.2.x.  I have not been able to determine the exact version of CR bundled with my VS .NET.

What I am not hearing from you guys is any commentary regarding design formatting tricks, anomalies, or work arounds in the CR design user interface that might cause or affect this problem.  Have you not heard of any either the general public or I should be aware of?

-Ray Salvo
Software Engineer
0
 
LVL 42

Expert Comment

by:frodoman
ID: 10920493
Ray,

>>> when I copy and paste that report to another Microsoft Word document, some of the formatting is lost

You're talking copy from Word to Word, right?  Is is possible that you aren't copying everything - specifically all of the hidden tables etc that are embedded in there?

If you're talking about the export itself, what you're going to find w/ Crystal is that the export to Word or Excel isn't going to be any better than "that's sortof close".  

Most of the experts here will probably tell you that if you plan to export to an MS Office format, you'll probably want to design a report so that the exported fields give you a good result - but this may mean that when viewing the report in Crystal it looks like crap.  Personally if I have a report that I know will be exported I create a "viewable" version and an "exportable" version.  This is an unfortunate side-effect of the fact that crystal's export simply isn't on the money.

>>> I have not been able to determine the exact version of CR bundled with my VS .NET

You can check the properties of one of the Crystal items added to your project.  In VisStudio, in the solution explorer, click on any of the CrystalDecisions.xxx  entries under references.  Then check the properties for the item and the last property should be "version" which will probably show 9.something.


frodoman
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 7

Expert Comment

by:ladylinet
ID: 10922250
Hotfix will not update your crystal from version 9.0 to 9.2 - at least, it didn't do it for me.
 Download .NET version of 9.2 from http://support.businessobjects.com/, I can't find that link right now.

Lady Linet
0
 

Author Comment

by:raysalvo
ID: 10954154
OK, well I downloaded CR version 9.2.2.x after contacting a Business Objects / CR representative.  For some reason, she had to send me a new product key code because mine was no longer valid.  I then ran the latest Service Pack update and I am now in much worse shape than when I started.  When I export the data to an MS Word document, I get an error message which reads as follows:

"Error in File C:\\DOCUME~1\\RAYSAL~1\\LOCALS~1\\Temp\\temp_30c78a2e-7016-48a5-aebc-fb9b5c509fc2.rpt:\nFailed to load database information."

I am working on resolving this issue.  Perhaps when I can create this temporary file and actual file, then I will be able to determine whether I still have a formatting problem.  Right now, I cannot get the exported file at all.

By the way, I did try clicking on fields and sections in my report in order to determine the version.  There was no mention of a version detail listed in any of the properties pages.  However, on the merge modules, I am getting a version number "1.0" for the CR related .msm files.  Frankly, I was expecting to see a 9.x.x.x kind of number.

Here are some questions raised based upon my research.
1) There is a directory "C:\Program Files\Common Files\Crystal Decisions\2.0\bin" which contains a bunch of DLLs.  In order to fix errors of this nature the CR people have suggested copying various dlls to the c:winnt\system32 directory.  Should I be thinking of copying some DLL to that windows directory?  If so, which one?
2) Should I be thinking about resetting the links between the fields in my designed report and the database?  (This seems a bit extreme.)
3) Has anyone out there seen a similar message and resolved this?

-Ray Salvo
Software Engineer
0
 

Author Comment

by:raysalvo
ID: 11028150
OK, well I don't know whether anyone is still following this question.  I have a few answers.  

1) In order to determine what version I was using, I had to navigate in my windows browser to the directory containing the CR files, right click to properties, and then I could determine the precise version number.

2) Even the latest version and hotfixes did not fix my overlay/underlay problems.

3) What I did do to fix the overlay/underlay problems was to open the Section Expert and go to the Group Header and add a "New Page After" in the group preceding my details sections.  Additionally, I had to add a "New Page After" in the Group Footer following my details sections.  Otherwise the text of my report would underlay at the end of the pasted section.  This hocus-pocus seemed a bit strange.  

4) Just to answer the obvious: No underlay option is checked in any section of my CR design.  

5) I have yet to experiment with changing the exported format from .doc to .rtf.  I will be trying that shortly and can report my findings.

6) Perhaps someone knows why I have to insert these New Page directives and how I might be able to avoid doing this and still export, then copy/paste without an underlay side affect.

Hopefully this helps someone else facing a similar problem.

-Ray Salvo
Software Engineer
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11871831
PAQed, with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now