Hi all
I am working on telerik reporting and follow the guide: http://www.telerik.com/help/reporting/html5-report-viewer-howto-custom-parameters.html.
In the telerik designer, i create data source that call store procedure with parameter (@BranchId int). I also create a Report Parameter BranchId (int)
so i assign store procedue paramter equals the report paramter.
In java script i pass report parameter as the above tutorial, but when i run the program it just give me: Procedure or function 'GetProductBranch' expects parameter '@BranchId', which was not supplied.
Any advice please let me know
Thanks
I am working on telerik reporting and follow the guide: http://www.telerik.com/help/reporting/html5-report-viewer-howto-custom-parameters.html.
In the telerik designer, i create data source that call store procedure with parameter (@BranchId int). I also create a Report Parameter BranchId (int)
so i assign store procedue paramter equals the report paramter.
In java script i pass report parameter as the above tutorial, but when i run the program it just give me: Procedure or function 'GetProductBranch' expects parameter '@BranchId', which was not supplied.
Any advice please let me know
Thanks
3 Answers, 1 is accepted
0
Phuc
Top achievements
Rank 1
Rank 1
answered on 18 Sep 2014, 08:55 AM
Hi
no body answer the post . I am tried with Telerik now, use html5 cannot call /api/Reports/client not found. When i switch to make report by UriReportSource i cannot how to pass stored procedure parameter to PricingProduct.trdx.
no body answer the post . I am tried with Telerik now, use html5 cannot call /api/Reports/client not found. When i switch to make report by UriReportSource i cannot how to pass stored procedure parameter to PricingProduct.trdx.
0
Hi Phuc,
The HTML5 Report Viewer is a client-side widget served by a running Reporting REST service, which is dedicated to work with the viewer. It is the service that manages the report state and resources. For more details, please check this forum thread.
In the thread I explain how the viewer and the required REST service work.
Before proceeding with setting the viewer and the service, my recommendation is to configure the report use a data source component and a parameterized data retrieval method.
For example, you can use parameterized SQL queries and map the SQL parameters to report parameters. Where report parameters values can be passed though the viewer - How To: Pass values to report parameters. The viewer's reportSource.Parameters collection is mapped by key to the report's ReportParameters collection.
Details how to configure a data source component to use parameterized queries are available in the SqlDataSource Wizard help article.
I hope the above information is helpful.
As a side note, if it is an emergency, please use the support ticketing system to submit your inquiries, which guarantees you an answer by Telerik representative in a time range depending on your support subscription. We try to monitor forums as well, but cannot guarantee you an answer in a timely manner.
Regards,
Stef
Telerik
The HTML5 Report Viewer is a client-side widget served by a running Reporting REST service, which is dedicated to work with the viewer. It is the service that manages the report state and resources. For more details, please check this forum thread.
In the thread I explain how the viewer and the required REST service work.
Before proceeding with setting the viewer and the service, my recommendation is to configure the report use a data source component and a parameterized data retrieval method.
For example, you can use parameterized SQL queries and map the SQL parameters to report parameters. Where report parameters values can be passed though the viewer - How To: Pass values to report parameters. The viewer's reportSource.Parameters collection is mapped by key to the report's ReportParameters collection.
Details how to configure a data source component to use parameterized queries are available in the SqlDataSource Wizard help article.
I hope the above information is helpful.
As a side note, if it is an emergency, please use the support ticketing system to submit your inquiries, which guarantees you an answer by Telerik representative in a time range depending on your support subscription. We try to monitor forums as well, but cannot guarantee you an answer in a timely manner.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Phuc
Top achievements
Rank 1
Rank 1
answered on 22 Sep 2014, 02:53 AM
Thank you for your supportion. I am take a look on all thread.