?
Solved

Benefits of Crystal Reports over Access

Posted on 2006-06-19
3
Medium Priority
?
322 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

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