Pass value from MVC 5 action into a parameter of Telerik Reporting

3 posts, 0 answers
  1. Juan
    Juan avatar
    24 posts
    Member since:
    Oct 2016

    Posted 05 Oct Link to this post

    I have a Controller action that receives a value through ajax, and I want to pass that value as parameter to a query I did in the report.
    This is my controller action:

    public ActionResult OrdenCompraReport(int value)

    {

        /Here i want to pass the value into a parameter on Telerik reporting

        return View();

    }

    And this is my query in my sqlDataSource of Telerik Reporting:

    select oc.OrdenCompraNumero, oc.FechaDeEmision, fp.Nombre, a.Nombre, a.Contacto, a.Direccion, a.CorreoElectronico, a.Ruc, a.Telefono

    from OrdenCompras oc 
    join FormasPago fp on oc.FormaPagoCodigo = fp.Codigo
    join Aseguradoras a on oc.AseguradoraCodigo = a.Codigo
    where oc.OrdenCompraNumero = @OrdenNro

    @OrdenNro is the name of the parameter. Any ideas of how can i do this?

  2. Juan
    Juan avatar
    24 posts
    Member since:
    Oct 2016

    Posted 07 Oct Link to this post

    Help please!!
  3. Squall
    Squall avatar
    180 posts
    Member since:
    Feb 2011

    Posted 10 Oct in reply to Juan Link to this post

    How to do this is explained here: https://docs.telerik.com/reporting/mvc-report-viewer-howto-custom-parameters
Back to Top