Telerik reporting cannot pass parameter for sql stored procedure

4 posts, 0 answers
  1. Phuc
    Phuc avatar
    3 posts
    Member since:
    Sep 2014

    Posted 17 Sep 2014 Link to this post

    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
  2. Phuc
    Phuc avatar
    3 posts
    Member since:
    Sep 2014

    Posted 18 Sep 2014 in reply to Phuc Link to this post

    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.
  3. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 19 Sep 2014 Link to this post

    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
     

    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.

     
  4. Phuc
    Phuc avatar
    3 posts
    Member since:
    Sep 2014

    Posted 21 Sep 2014 in reply to Stef Link to this post

    Thank you for your supportion. I am take a look on all thread.
Back to Top