Using crystal reports with MySQL ADO connector

[Chukkalove]

I am a developer with limited database and zero crystal report experience. I
am very confused.

We wanted the ability to switch database providers easily, so I selected to
use ADO components with our application.
The database we're developing with is MySQL. I downloaded their MySQL
Connector/NET components which are ADO compliant. Using .NET connectors, if
we want to switch to another provider, there should be minimal code changes
necessary to make it run.
It all works fine so far. I connect to the remote database at run time using
a connection string read from stored configuration information.

Now I need to add reporting capabilities to the application, using Crystal
reports, and this is where Im confused.
http://support.businessobjects.com/communitycs/technicalpapers/rtm_reportingoffadonetdatasets.pdf
This example shows preparing data for use in a web project. Ours is a
desktop application.

So far I've tried to keep all of this as generic and configurable from
config files as possible.
The example in the above link uses a wizard to link to OLE DB provider
registered on the local pc. This immediately ruins the portability as it's
done through a wizard.
Is OLE DB the "same" as ADO?
Do I need to download and install OLE DB drivers from mySQL's site?
I wondered if once you've used this wizard, at later dates you can
programmatically change server information. Is that possible?

thanks

 

[William \(Bill\) Vaughn]

Ah, why use Crystal Reports when the VS 2005 supports the RDL-based
ReportViewer control that's free, a lot easier to use and more heavily
documented? This control can accept a DataTable so you can use your MySQL
database as a Data Source to populate the DataTable. I wish you could get a
copy of my new book as it discusses this in detail.

The book will be available November 6th and I'm offering a substantial
discount off the online retail price for those that sign up on the support
site www.hitchhikerguides.net between now and when it's on the street.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Cor Ligthert [MVP]]

Maybe will this sample help you,

http://www.vb-tips.com/dbPages.aspx?ID=68888abf-f137-45d1-8a81-e779bfb411c5

Cor

 

[Chukkalove]

Ah, why use Crystal Reports when the VS 2005 supports the RDL-based
ReportViewer control that's free, a lot easier to use and more heavily

Because Im using VS 2003 thank you anyway

 

[William \(Bill\) Vaughn]

Okay, so use SS 2000 Reporting Services--it's also a free upgrade to the
Standard Edition. When you migrate to SQL SErver 2005 (if ever), it's
available on all editions--even the Express Edition.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
_________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)


INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________