Stored Procedures

This topic is locked

Stored Procedures	5/17/2011 10:44:24 AM
ASPRunnerPro General questions
K kdabbs author ASPRunnder 6.3/7113. Can I call a stored procedure from MS SQL for a report? I can call it from the SQL tab of the query builder using "Exec[spExample]" and it returns data on the results tab. But it simple errors to a 'cannot display page' when I call the report from the project on-line.


	Sergey Kornilov admin 5/17/2011
	ASPRunnerPro won't be able to run reports based on stored procedures. The best approach is to create a view in SQL Server on the top of this stored procedure call and use this view as a datasource in ASPRunnerPro.