Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Choosing your reporter: Crystal Reports or MS Word? __ Keywords: CR vs Word Reports

Posted on 2003-12-08
Medium Priority
Last Modified: 2012-05-04

Our company often develops applications that has the functionality to make print-outs: Planning-overviews, order-overview, stock-overview, ...

Some of out projects make use of Crystal Reports to do this, some use MS Word with DOT's and bookmarks to achieve the same. This decision solely depends on the person who implements the project. None of these decisions are based on good arguments.

Could someone give us some guidelines / criteria why we should choose CR over Word or Word over CR? We know CR is better with handling data. All report logic is stored in the report itself, i.s.o the programming code and some bookmarks. However, a user is very flexible in adding changes after a report is created using MS Word rather than CR. These are some of the basic things we know, but isn't enough to make a thorough decision on what software to use. So, please help!

With kind regards, and thanks in advance,

Luc Derckx
Question by:IThema
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 42

Assisted Solution

frodoman earned 100 total points
ID: 9896337
I would say that Crystal also offers more opportunities for expanding into a bigger role in your company later.  

+ The RDC components allow better control of Crystal through other programming languages.
+ The web page server components allow for publishing of reports on your intranet.
+ Crystal handles a wider variety of data sources better than Word.
+ You can create parameterized reports with Crystal so user's can generate the same report for different parameters.

I don't know much about the capabilities of Word, but above are what I would believe to be some strong points in favor of Crystal.

Hope that helps.

Author Comment

ID: 9896514
Those are strong points indeed. I believe the use of CR or Word depends on what you want to do with them. In my experience, I've seen great international banks use Word as a reporter to generate overviews of mortgages. In that case, the program collects all data and pumps them in Word. The role of Word is that it can help in pre-defining the layout of a report, by using a template. The bank-employee can easily make changes in the report after it has been generated, because it is then 'just another word document'. I believe this is one strong point of Word.

Example: In the code, one would to something like this:

InsertText("MyBookmark1", "Bla")
InsertText("MyBookmark2", "BlaBla")
'Finished, show my word document now so user can Print / Edit / DoWhateverHeWants
objMyWordDocument.Visible = True

Public Function InsertWordText(strBookmark as string, strText as string)
    objWord.ActiveDocument.Selection.GoTo wdBookmark, strBookmark
    objWord.ActiveDocument.TypeText strText
End Function

So, this actually brings me back to my question: When would one use CR over Word or vice versa.
LVL 101

Accepted Solution

mlmcc earned 400 total points
ID: 9896605
I would say a mox is a good idea.

I would use Crystal for heavily data-oriented reports where you want the information formatted and arranged in a certain way but there is limited text not from the database.

I would use Word where the major parts of the report are textual and don't change based on the data.  Word is much better at producing documents especially if the document looks a lot like a form or has a lot of "boiler-plate" information.

I think you used an excellent example of the a bank and the mortgage documents.  Limited data with lots of boilerplate or common information between all reports.  Crystal wouldn't lend itself to that very easily.

As far as allowing users to modify a report after it is generated, I would be concerned that data might get changed.  In that regard Crystal is better for reports where a user shouldn't change the information or the format.  In addition, Crystal Reports can be exported to other formats including RTF which can be read into Word and modified.

We use Crystal for the data-centric reports where the data is the important aspect and for reports we don't want the user to manipulate.  We use Word for documents that need some information from the database but require the user or and analyst to modify or add information to the document.

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

LVL 42

Expert Comment

ID: 9896626
Good point; however Crystal can export into Word format so this has never been a limitation for us in using Crystal.

When we have a situation similar to what you illustrated, the user simply exports the Crystal report to Word and then works with it as 'just another word document.'


Author Comment

ID: 9896661
Thank you both so far. I'll keep this question open for a couple more days in order to give others the oppertunity to give me their view on this.

LVL 101

Expert Comment

ID: 9901844
You might put a low point link to this question in the MS Word forum to get their viewpoint.



Author Comment

ID: 9902458
Good idea, since you people are all so keen on Crystal Reports :p    <-- (that means: this is a joke :D)

I put a link to this thread on in the Word area.

I hope I get some strong arguments from people of the Word area.


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

609 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