?
Solved

How to connect Crystal Reports with MySQL Stored Procedure?

Posted on 2008-11-04
9
Medium Priority
?
1,770 Views
Last Modified: 2008-11-11
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?
0
Comment
Question by:rpkhare
9 Comments
 
LVL 26

Accepted Solution

by:
Umesh earned 375 total points
ID: 22874921
0
 
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 375 total points
ID: 22875031
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
 
LVL 8

Author Comment

by:rpkhare
ID: 22878048
emoreau:

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

0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 70

Expert Comment

by:Éric Moreau
ID: 22878156
if you don't have a very large volume, you won't notice the overhead
0
 
LVL 8

Author Comment

by:rpkhare
ID: 22878330
No, I am noticing very slow performance even when there is 1 record in the database.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 22889713
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
 
LVL 8

Author Comment

by:rpkhare
ID: 22892495
I tried the other way. I prepared the XSD file at run-time and set it as a data source.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 22893494
>>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
 
LVL 8

Author Comment

by:rpkhare
ID: 22895776
But it is taking time to even re-fill the XSD with the latest records.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month15 days, 18 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question