?
Solved

Benefits of Crystal Reports over Access

Posted on 2006-06-19
3
Medium Priority
?
329 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)
[X]
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 Comments
 
LVL 66

Assisted Solution

by:Jim Horn
Jim Horn earned 600 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 44

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 1400 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

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…
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…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

650 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