I am not seeing the option to select the Stored Procedure in the SQL DataSource Configuration.
Hello,
I am just checking about the progress of this issue. Let me know If you need my further assistance on this issue?
Thank you for using Infragistics Components.
Hello ,
I have researched your issue very deeply and it seems that this is an issue in the documentation, since we don’t have native support for stored procedures. You could invoke a stored procedure via SELECT statement, and these kinds of queries are valid in Reporting, instead to directly select it from “Data Source Configuration Wizard”. However this documentation issue was addressed (I’ve logged two internal issues 154759 and 154760 ), so soon this will be corrected.
Please let me know if you have any further questions.
In the below URL I see the option to select the table or view or Stored Procedure in the 5th image..(in the datasource configuration wizard)..?
http://ko.infragistics.com/help/topic/461a1a9a-5f15-4a64-8986-997bcadf1202
You could create Object Data Source based on the result of a stored procedure, that object Data Source can be then used to populate an Infragistics report. On the following link you will find simple tutorial of “How to Create an Object Data Source Using Stored Procedures”
http://help.infragistics.com/Help/NetAdvantage/Reporting/2013.1/CLR4.0/html/How_to_Create_an_Object_Data_Source_Using_Stored_Procedures.html
Also I recommend you to review the topics in How To work With Stored Procedure:
http://help.infragistics.com/Help/NetAdvantage/Reporting/2013.1/CLR4.0/html/How_to_Work_with_Stored_Procedures.html
Please let me know if you have any further questions