Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / May 2004

Tip: Looking for answers? Try searching our database.

CrystalRpts Vs. Access; FeatureByFeature?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
darrylqa - 26 May 2004 11:59 GMT
Hi,
I just started a new job and need advice. Where can I
find information on the advantages and disadvantages of
Crystal Reports Vs. Microsoft Access Report Generator
when compared side by side?  Examples of issues I am
interested in are:

(1) User interface when preparing to run a report.  
(There could be many variables such as: Store Numbers,
Dates, SalesPersonID, etc.) (I am proficient with Access
VBA code and can easily create user-forms with drop-down
lists, checkboxes, etc.  How does Crystal compare?  How
easy is it to input variables from another program, such
as C# or VB, into a Crystal Report?) (I am new to Crystal
Reports.)

(2) How well does Access work with a SQLServer back-end?  
SQLServer is our primary back-end software. (I am new to
SQLServer.)

(3) Convertabitlity: What if we eventually go to a Visual
Studio (C#) based information system.  How easy does
Access convert to another report generator?

(4) We do have some Web Based applications.  How does
each work with ASP's? (I am new to this.)

I looked till I was bleary-eyed last night for a good
pro/con, side by side feature article without any luck.  
I'd appreciate any help.  Thanks,
~darrylqa
Larry  Linson - 28 May 2004 23:27 GMT
If my application was Access, I can't imagine using Crystal as the reporting
tool. I've seen some impressive work done with Crystal (by someone who'd put
in his time climbing the learning curve) in a case where it was appropriate
(a web-based application), but the person who did it said he'd choose Access
reports any day, if there were a choice.

You can, likely, drive Access via Com automation from .NET languages to
continue to use your Access' reports. It may take a little planning and
implementation to get printed copies down to the users, but it can be done.

If I were looking at an alternative to Access' reporting, I'd look into
Microsoft's SQL Server Reporting Services (separate product), especially for
the move to .NET.

 Larry Linson
 Microsoft Access MVP

> Hi,
> I just started a new job and need advice. Where can I
[quoted text clipped - 27 lines]
> I'd appreciate any help.  Thanks,
> ~darrylqa
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.