How to connect Crystal Reports with MySQL Stored Procedure?

I have a stored procedure in a MySQL database. I want to know:

(1) How to set the Data Source of my Crystal Report to this stored procedure?
(2) Alternatively, I want to link my Crystal Reports to show all records of a table in my MySQL Database. How to link Crystal Reports with that table?
LVL 8
rpkhareAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Éric MoreauSenior .Net ConsultantCommented:
you can always provide a report a dataset you already have opened whatever source it comes from. see http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
0
rpkhareAuthor Commented:
emoreau:

I have noticed in previous reports that setting up the DataSource to XML schema is very slow.

0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Éric MoreauSenior .Net ConsultantCommented:
if you don't have a very large volume, you won't notice the overhead
0
rpkhareAuthor Commented:
No, I am noticing very slow performance even when there is 1 record in the database.
0
mlmccCommented:
Was the report built against the stored procedure or are you trying to build a new report against a stored procedure?

To get stored procedures to display in the list you need to change the OPTIONS
Open Crystal
Click FILE --> OPTIONS
CLick the DATABASE tab
Make sure STORED PROCEDURES is checked in the VIEW block

mlmcc
0
rpkhareAuthor Commented:
I tried the other way. I prepared the XSD file at run-time and set it as a data source.
0
Éric MoreauSenior .Net ConsultantCommented:
>>I prepared the XSD file at run-time

The XSD should not be prepared at run time. It is a file that you create while developping your application and then keep as is unless your database schema changes.
0
rpkhareAuthor Commented:
But it is taking time to even re-fill the XSD with the latest records.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.