[AccessD] Access and Crystal Reports

Shamil,

I just got through with a three day course on what's new in Crystal
Reports 9.0 and I stand by my statement that Access 2002 and CR 9.0 are
almost identical in their feature sets.  I did not say they were equally
easy to learn or use, because that is subject to your background
experience and personal preferences.

I also stand by my assertion that there is no reason to buy CR to
produce reports from an Access database.

If you have C++, C#, VB or some other platform as your front-end to SQL
Server or Sysbase or some other database other than Access, then CR
makes sense.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Shamil Salakhetdinov [mailto:shamil at smsconsulting.spb.ru] 
Sent: Thursday 2003 Mar 06 13:19
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access and Crystal Reports

> Why pay extra for Crystal Reports?
Sorry for my jumping in, Charles,

I used to use Crystal Reports(CR) to build advanced reports with C++
last spring - and I'd say that CR can give 1000 points allowance to MS
Access reports' designer and still win nevertheless this big handicap...
On first glance CR looks for a MS Access developer like a very sprawl
and not as intuitional as MS Access report designer tool but when one
gets the rules of report generation used by CR they understand that CR
allows to create reports, which can't be created in MS Access - and I
think that all of MS Access types of reports can be created by using
CR...

And of course CR reports created to view in MS Access can be (re-)used
in VB, C++, DELPHI, on the Web etc.etc....

Shamil

----- Original Message -----
From: "Wortz, Charles" <CWortz at tea.state.tx.us>
To: <accessd at databaseadvisors.com>; <dba-VB at databaseadvisors.com>
Sent: Thursday, March 06, 2003 9:48 PM
Subject: RE: [AccessD] Access and Crystal Reports


> Richard,
>
> May I inquire why you want to use Crystal Reports with Access?  Access

> 2002 and Crystal Reports 9.0 are almost identical in their feature 
> sets, so why not use Access for your reports?  Why pay extra for 
> Crystal Reports?
>
> Charles Wortz
>
> -----Original Message-----
> From: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk]
> Sent: Thursday 2003 Mar 06 12:09
> To: 'dba-VB at databaseadvisors.com'
> Cc: 'AccessD at databaseadvisors.com'
> Subject: [AccessD] Access and Crystal Reports
>
> Hi
>
> using code how do you run a Crystal Report when the Access Db has 1) a

> password and/or 2) uses a system mdw
>
> Many thanks
>
> Richard