I open my report builder 2.0 to create a report based on a stored procedure. I add a datasource and dataset and cannot see the stored procedure to select in the dataset. Why isnt the datasource connecting to the dbase with the stored procedure. the url is correct and does not send me error (http://[servername]/reportserver

I add a datasource and dataset and cannot see the stored procedure to select in the dataset. Hello, In RB it's possible to select "by checkbox" a table or a view, but not a stored procedure. To use a SP as datasource please switch the type from "Table/View" to "Text" and enter "EXEC dbo.yourStoredProcedure(MaySomeParameterValues...)"Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich http://olafhelper.over-blog.de