stored procedure and crystal reports for VS .Net

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I'm trying to get the results from a stored procedure
into a crystal report in VS .Net. The stored procedure
has one input parameter (date). When ever I create a new
crystal report and set the database datasource to the
stored procedure and then try to add a chart, it gives me
an error about 'Convert' native error: 156. This error I
guess has to do with maybe the Date input parameter not
being specified? I'm not sure. Is there any real step by
step examples of how to create a crystal report in VS .Net
from a stored procedure data source?

On a another note, is it possible to execute and get the
results of a stored procedure (that has one input
parameter) and put it into a dataset? If so how?
Everything that I've ever read doesn't make mention of
doing this.

Thanks in advance!!!!!!
 
I'm not going to go into the workings of Crystal. But yes, you can fill a
DataSet with a SP. I wrote an article on how to do it. See
www.betav.com\articles.htm


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top