Solved

Benefits of Crystal Reports over Access

Posted on 2006-06-19
3
314 Views
Last Modified: 2012-06-27
what are the benefits of using crystal reports versus access?  i am a CR 8.5 user, and have been reading up on Access because i've never used it.
0
Comment
Question by:zephyr_hex (Megan)
3 Comments
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 150 total points
ID: 16936861
It has been explained to me that Access Reports is about 80% Crystal Reports, so if you have an Access project you might as well use Access Reports, otherwise if you are using something else (say VB) and need to choose, Crystal Reports is the reporting engine of choice, as you can deploy it without the overhead/requirement of reporting within the Access container.

Hope this helps.
-Jim
0
 
LVL 42

Author Comment

by:zephyr_hex (Megan)
ID: 16936900
when i write a CR report, i do it directly in CR.  we do use an application which uses CR reports, so of course i would have to use CR to write or edit a report for that application.
but i am also writing other reports in CR that are independent of that application... so that's when i wonder why CR instead of Access.

i guess anyone who wants to run an Access report must have Access installed... right now everyone has CR installed, and we also are working on a web interface for CR reports...
so there are some differences in regard to use.  but are there things CR can do that Access can not?  or performance differences?
0
 
LVL 13

Accepted Solution

by:
TommyTupa earned 350 total points
ID: 16937184
I've done complex reporting in MS Access and  Crystal Reports (among others) and IMHO MS Access is about 20% of what Crystal Reports can provide.  Imagine driving a 1970s VW your whole life than being given a brand new M series BMW. The VW works just fine.  Gets you from here to there.  But get in the BMW and you experience a whole new level of driving possibility.

One example is database connection options.  On this surface it may appear that they both can connect to any database.  However when you go deeper you see that Crystal allows far greater flexibility.  Forget about the fact that Access can connect via linked tables or pass through queries.  Crystal goes eons past this.  You can use udl's , command objects, direct SQL, ttx files, text files, native connectivity, and on....  Now take the database connection options example to any other feature; conditional formatting; exporting, ranking, sorting, grouping, headers and footers. aestheticically pleasing reporting.  Access can do all this but Crystal goes far far deeper.  You can't know how deep until you actually use the tool.  

This link may help for a start:
http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21888487.html
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

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 …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

806 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