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?