jbernat Posted September 8, 2007 Share Posted September 8, 2007 How do I create a report that gets its data from a MS Sql Server stored procedure? I have only been able to build select statements with what I've found so far. Thanks,JimPost edited by: jbernat, at: 2007/09/08 03:02 Link to comment Share on other sites More sharing options...
jbernat Posted September 9, 2007 Author Share Posted September 9, 2007 Never mind. I figured out that if you hand-key the exec statement, it works. The "builder" apparently only works with tables and views. Thanks for looking. Jim Link to comment Share on other sites More sharing options...
sagarnikam123 Posted January 28, 2013 Share Posted January 28, 2013 @jbernat , Can You explain in Details,because I can run stored procedure,but can't get required field from Resultset.e.g. select FieldName from (call my_procedure) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now