Anyone please help me.....Procedure not shown in my report. [modified]
-
I m using vb.net 2005 & crystal report(bundeled version which comes with .net). & using Dsn of mysql 5.0 driver for connection on my report to access data. I wnt to add result from procedure to my report. Procedure is ready & giving result in mysql but as i go into database Expert of Report in my application, i cant see the procedure there. Only add commant & tables of my database shown but how to add procedure to my report . Anyone please help me. Thanx. -- modified at 1:48 Tuesday 20th February, 2007
"The Difficult i can do it now... The Impossible will take a little longer."
-
I m using vb.net 2005 & crystal report(bundeled version which comes with .net). & using Dsn of mysql 5.0 driver for connection on my report to access data. I wnt to add result from procedure to my report. Procedure is ready & giving result in mysql but as i go into database Expert of Report in my application, i cant see the procedure there. Only add commant & tables of my database shown but how to add procedure to my report . Anyone please help me. Thanx. -- modified at 1:48 Tuesday 20th February, 2007
"The Difficult i can do it now... The Impossible will take a little longer."
what are you trying to do is not possible i think so but you can try by database manager property
prem kumar singh
-
what are you trying to do is not possible i think so but you can try by database manager property
prem kumar singh
Thanks for help. But Cant we take stored proedure's result into crystal report? Will u tell me please How should i Try with database manager property. -Regards Priya.
"The Difficult i can do it now... The Impossible will take a little longer."
-
Thanks for help. But Cant we take stored proedure's result into crystal report? Will u tell me please How should i Try with database manager property. -Regards Priya.
"The Difficult i can do it now... The Impossible will take a little longer."
I've not used Crystal for many years - but I seem to remember that there was an option for executing a "pass-through" query that would allow you to use native SQL-Server syntax (ie. "
EXEC MyStoredProc 'ABC'").