Urgent Please :how to call stored Proc?
-
Hallo frends, I want to take result from stored procedure into my Crystal report but cnt see strored procs into my database expert of Crystal Report. I m using vb.net & mysql 5.0 & using ODBC for connection on report which includes DSN that i made already on my machine. But though i m check on "Show Stored procedure" under database exper->options->DataExplorer. But not showing any stored proc yet only tables. How should i call my stored proc in crystal RPt. Please Tell me soon. Thanks. -Regards Priya.
"The Difficult i can do it now... The Impossible will take a little longer."
-
Hallo frends, I want to take result from stored procedure into my Crystal report but cnt see strored procs into my database expert of Crystal Report. I m using vb.net & mysql 5.0 & using ODBC for connection on report which includes DSN that i made already on my machine. But though i m check on "Show Stored procedure" under database exper->options->DataExplorer. But not showing any stored proc yet only tables. How should i call my stored proc in crystal RPt. Please Tell me soon. Thanks. -Regards Priya.
"The Difficult i can do it now... The Impossible will take a little longer."
Hi Priya, Please tell me which version of .Net (2003 or 2005) and Crystal Report version (9 or 10) are you using?? I am currently working .Net 2005 with SQL 2000 as backend. I am not sure the same should work on MySQL. NOTE 1 point: When adding Stored Procedure in Crystal Report, you should have only one SQL Query. For example. CREATE PROCEDURE Sql1 AS BEGIN Select * from Table1 -- Select * from Table2 (Note -- this should be commented) END Hope you are getting the above example. If not, please reply. I will explain in detail. - Harini