Dataview Connected to StoredProcedure

L

lyndonc

I want to display the results from a stored procedure in
a data view.

I create the connection to stored procedure and am
prompted for a default value for a parameter the stored
procedure takes. this all works fine except The data view
doesn't display any results.

It just says PassThroughDataSet and status is success.

Does any documentation exist of connecting dataviews to
storedprocdures which have input parameters?
 
J

John Jansen \(MSFT\)

That should work. You need to make sure the Server allows for passthrough
queries. These are enabled from within the Server Admin pages.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top