Skip to Content
author's profile photo Former Member
Former Member

Newbie - Crystal Reports v MS Access

Post Author: Snowsride

CA Forum: General

I would appreciate any advice/opinions as to what advantages Crystal Reports has over Access.

I am used to developing complex queries and reports etc. in MS Access but a job I have applied for uses Crystal Reports of which I have no knowledge/experience. I've got an evaluation copy of CR and it looks relatively straightforward but if I could use Access I would!

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 06:22 PM

    Post Author: dee7231

    CA Forum: General

    for me Crystal Reports is a lot easier for a newbie than MS Access reports. It has a lot of right click options for formating that are more difficult in access. Also the summary options are pretty much point and click. Access summaries are not really point and click, and you have to build out the formulas. The formats for creating formulas in Crystal were easier for me, also. However I was thrown into reporting. My boss said I need a report, you do it, and that was it. Having a little more knowledge of Access (but not much), I tried it first then Crystal Reports afterwards. What took me 1 1/2 hours in Access, took 15 minutes in Crystal. And that was with no prior training in either application.As for complex queries, summaries, and formats, you can get just as complex with Crystal as you can with Access. Crystal gives you a simple view of Record selection for example, but if it's more complicated, then you can go into the formula view and work it like an SQL query. You can also quickly create parameters that will prompt the user for the information needed in the record selection. Again it's basically point and click, but if you need to get into more detail you can. You have the advantage of knowing Access, but adapting to Crystal shouldn't pose any kind of a problem for you.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.