Solved

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

Posted on 2003-12-08
7
429 Views
Last Modified: 2012-05-04
Hello,

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
0
Comment
Question by:IThema
  • 3
  • 2
  • 2
7 Comments
 
LVL 42

Assisted Solution

by:frodoman
frodoman earned 25 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.
0
 
LVL 5

Author Comment

by:IThema
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.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 100 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.

mlmcc
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 42

Expert Comment

by:frodoman
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.'

0
 
LVL 5

Author Comment

by:IThema
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.

Cheers
0
 
LVL 100

Expert Comment

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

http://www.experts-exchange.com/Applications/MS_Office/Word/

mlmcc
0
 
LVL 5

Author Comment

by:IThema
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.
http://www.experts-exchange.com/Applications/MS_Office/Word/Q_20820366.html

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

Cheers!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal suppressing if sub report empty 8 60
Converting int to currency 5 31
Crystal Reports maximum report processing jobs limit error 2 41
Crystal Reports - Trim Data 7 41
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

914 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

23 Experts available now in Live!

Get 1:1 Help Now