cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL 5.1 Stored Procs and Views not showing, only tables.

Former Member
0 Kudos

Hi,

I'm having problems getting stored procedures and views to show up in the Data Source Explorer of CR4E 2.0.

I've checked the properties of the connection and the Default Stored Procedure Filter is disabled, so things should show Tables are showing. The user within MySQL that I am using to connect also has rights to view sps and views.

My question is, has any one got views or sps to show within the Data Source Explorer using MySQL 5.1? Am I missing a trick here? Do I need to add anything to the url string of the mysql jdbc driver for the sps and view schemas to show.

Many thanks,

Nick

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I found out that this is not a feature that CR4E 2.0 supports. When I used the 2008 designer I was able to connect to stored procedure schemas within the datasource.

Former Member
0 Kudos

Hi,

As a work around you can use the CR2008 to design your reports based on stored procedures and then import the reports in Crystal Report For Eclipse IDE. You will be able to view the fields/Data coming from the Stored Procedures.

Thanks,

Neeraj