Solved

MS access VS Crystal Report

Posted on 2008-10-21
5
1,072 Views
Last Modified: 2013-11-29
Hi All,

I want to develop an application, this application will process information stored in database, these process includes inserting and retrieving data  from the database, print result in tables and  doing some calculation, also printing  these data in predefined  reports template, but also I want to give the user the ability to modify these report templates as he wants.

I have seen similar application developed in MS access but the user can't change the report format or structure, I thought may be crystal report can  assist me doing it, I thought also doing it through a VB application and make it integrated with crystal report through its VB controls.

so what do you think and what you recommend me..shall I go to crystal report and develop a VB application on top of it? or shall I stick to MS access?


0
Comment
Question by:I-Can
5 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 22769230
This all depends on the size and compexity of your database, number of users, number of reports, etc.

If your database is to serve just a few users, mantain your database in Access, put some forms to help the users select the data they want on the reports, make some custom reports for each user.

If on the other end, the database is used by a lot of users, has big amounts of information, you could invest in some VB application using Cristal Reports for better reporting experience.  You should in this case, migrate the database to SQL. Don't forget, for you to have a good VB application, you need to invest some time/money on it.

jppinto
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 75 total points
ID: 22770200
So long as they have Access on their machine and you don't lock the database from them, they should be able to make changes to the reports.

Allowing the user to change a Crystal report would require them to have a full blown copy of Crystal.

If you expect to be maintaining the database and the reports for them then you have a synchronization issue so that you get all the changes they make.

mlmcc
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22770843
Always a tough choice.

At the low to medium levels (Sort, Group, Filter (Select), Formatting, Printing, Parameters) they are pretty much the same, AFAIC.
At the higher levels (More complex reporting) crystal reports starts to pull ahead.

In my company we use both.
For the Access databases I develope, I use the Reports in Access.

However, we have a lot of Apps that are not Access based.
Great Plains, Abra, and some proprietary stuff,... they all use Crystal, because Crystal can handle almost any data source you throw at it.

So if you are going to be using Access primarilly, then use Access reports.

As soon as you start using disparate programs that require Reporting, start thinking about Crystal.

JeffCoachman

0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 50 total points
ID: 22775724
You can do a bit with Access reports, but you cannot change the "layout" (i.e. move this field .5 mm to the left, etc). You can change Recordsources, Groupings, Sortings, etc etc etc ... you can show/hide controls and subreports, alter the report's Headings ... etc etc.

So as others have said - it depends entirely on what you're looking to do. If all you want is for endusers to be able to change filters, headings etc then Access should work fine. Otherwise it's on to Crystal (or some other reporting engine).
0
 

Author Closing Comment

by:I-Can
ID: 31508371
thanks a lot.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

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 …
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

786 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