How to pass parameters to XtraReport in code

https://www.devexpress.com/Support/Center/Question/Details/T254029/how-to-pass-parameters-to-xtrareport-in-code

I have a store procedure and a webform(aspx.net) with ASPxDocumentViewer1 how i can send parametters programmatic to th report.

the report is bind to the store procedure i use vb.net

Hi Francisco,

To accomplish this task, utilize the approach demonstrated in the following help topic:
How to: Silently Pass a Parameter's Value

In short, you need to create a Report instance in the Page.Load event handler, assign the required parameter values, and then pass your Report instance to the ASPxDocumentViewer.Report property:

[C#]

protected void Page_Load(object sender, EventArgs e) { XtraReport1 report = new XtraReport1(); report.Parameters["yourParameter1"].Value = firstValue; report.Parameters["yourParameter2"].Value = secondValue; ASPxDocumentViewer1.Report = report; }

 

https://docs.devexpress.com/XtraReports/DevExpress.XtraReports.UI.XtraReport.Parameters

This document provides general information on query parameters and describes common ways of utilizing parametrized SQL queries to filter data on the data source level.

https://docs.devexpress.com/XtraReports/17387/detailed-guide-to-devexpress-reporting/shape-report-data/use-report-parameters/query-parameters

https://docs.devexpress.com/WindowsForms/3434/controls-and-libraries/printing-exporting/examples/print-preview/how-to-preview-export-and-print-an-xtrareport

https://docs.devexpress.com/XtraReports/2596/create-end-user-reporting-applications/winforms-reporting/print-preview/quick-start/create-a-custom-print-preview

https://docs.devexpress.com/XtraReports/2595/get-started-with-devexpress-reporting/create-a-simple-data-aware-report

https://docs.devexpress.com/WindowsForms/3434/controls-and-libraries/printing-exporting/examples/print-preview/how-to-preview-export-and-print-an-xtrareport