MySQL Bugs: #61875: Stored procedures not available in Crystal Report 8.5

Bug #61875	Stored procedures not available in Crystal Report 8.5
Submitted:	15 Jul 2011 7:53	Modified:	28 May 2013 14:11
Reporter:	Ashwini Dharmadhikari	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.0.19	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Hello,

I am using MySql 5.0.19 as database for my application.
I have Crystal 8.5 as reporting tool. When I want to design a report using stored procedure as DataSource, I am not able to do that. Reason being I can't see the stored procedres in Crystal Report. 
On Crystal side, I have checked the 'Stored procedure' checkbox but still can't see any procedure in the Datasource.
I have DSN created using Mysql ODBC driver 5.1.8 and I am using the root login which has all permissions to all DB obejctes in my database.

Could you please provide any help on this?

Thanks,
Ashwini

How to repeat:
Open Crystal report 8.5 Design mode.
Have Mysql database with some stored procedures.
Create a ODBC DSN for this database.
use the DSN in Crystal Report to get list of DB objects.
Only Tables and Views are seen. No Stored Procedure is available to select as Report Datasource.

Can you try to use newer version of MySQL server? Current one in 5.0 brunch is 5.0.92.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.