mysql to crystal report

i have my db at mysql, but i need to link it to crystal report to make a report for my company.
how can i do it?
thanksYou can use ODBC or OLE DB, but you need to install ODBC or OLE DB driver of MySQL.|||how to install odbc or ole in mysql?|||how to install odbc or ole in mysql?
No, not to install ODBC in your MySQL, but in your PC.
After installation finished, then select your data source to ODBC which
using MySQL ODBC driver.|||Download MySql Connector/ODBC (http://dev.mysql.com/downloads/connector/odbc/3.51.html) and after installation.

Go to ODBC Data Source Adminiostration -> System DSN - >Add -> MySQL ODBC 3.5 Driver and set the server information.

Then you can use this connection in the Crystal Report.

MySQL 5.0 Views wont work with crystal reports

I can access my view data through the application, but when i try to create the report in crytal reports and set up the database through an odbc driver 3.51.

If i click on a normal table its fine, but with the views it says

"Error Opening File: There are no fields in the file: "[View name]".Hi,

I've got a similar problem but using a stored proc. (See earlier posting for more info)

After much hair-pulling and soul searching i think that their might be a compatibility problem with MySQL5, MyODBC 3.51 and Crystal.

Have you tried MyODBC 5.0 yet? If it installs and works on yr side that might take yr problem away. And if it does, please let us know what you did cause it dont wanna install here.

Thanks and good luck|||Thanks

I have tried the 5.0 ODBC Connector, but unfortunatly i had no joy. Still the same error.

My Query

Hello!
Can any one help me solve this??
I am using MS SQL 2000 database for developing crystal reports for my company.
Now in this I am doing as follows:
I want to concate "dataset_" string with End_A--which is a column name in one table.(Result is like "dataset_1464")I am storing this result in a variable A.
And,now result of this query (A) is name of one table in same database.
Can I use this result ,i.e. A to get MM, which is a column in A.
Here I want to use A instead of dataset_1464.
Please help me if its possible.
thanks in advance,
chandreshselect @.var1 = 'dataset_'+convert(varchar(30),END_A) from table_A

sp_executesql ('select mm from '+@.var1)|||select @.var1 = 'dataset_'+convert(varchar(30),END_A) from table_A

sp_executesql ('select mm from '+@.var1)

HI Thanks alot for prompt reply...
I used this method but it still gives me error like:
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'select mm from '.

wht colud be the reason???
thanks (again) in advance..
chandresh

My primitive questions

I want to cerate printable reports and they must be in certain format , I don't have any experience in neither "Crystal reports" and "Reporting services" I wanted to make them by "Crystal reports" but it is very confusing ! so some one advice me to use "Reporting services" and I want to make sure that"Reporting services" can give me what I need befor I start to learn it seriously .

My first question is can I use "Reporting services" with a sql server data base on an ordinary web hosting?

Then I need extremely formatted prints of those reports rather in a web based application. Can "Reporting services" give me web based print like something we have in crystal reports ?

And last question is : where to start learning"Reporting services" fast ?

Thank you in advance .

Have a look at the following:

http://msdn2.microsoft.com/en-gb/sql/aa336316.aspx (SQL Server 2005 Reporting Services has many tutorials)|||

Thank you for links despite I saw them before but Dude give me some basic information before make me to read every thingJ

Please somebody answer my question with yes or no

Thank you .

|||

>My first question is can I use "Reporting services" with a sql server data base on an ordinary web hosting?

If you have SQL Server with the reporting services component plus the web viewer control.

>Then I need extremely formatted prints of those reports rather in a web based application. Can "Reporting services" give me web based print like something we have in crystal reports ?
SSRS can output a number of formats including PDF.