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?
 
Éric MoreauConnect With a Mentor Senior .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
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
É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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.