Solved

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

Posted on 2003-12-08
7
428 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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

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…
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 …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

762 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

20 Experts available now in Live!

Get 1:1 Help Now