RangeParametersSettings(RangeStartParameter, RangeEndParameter) Constructor

Initializes a new instance of the RangeParametersSettings class with specified RangeStartParameter and RangeEndParameter values.

Namespace: DevExpress.XtraReports.Parameters

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public RangeParametersSettings(
    RangeStartParameter startParameter,
    RangeEndParameter endParameter
)

VB.NET

Public Sub New(
    startParameter As RangeStartParameter,
    endParameter As RangeEndParameter
)

Parameters

Name	Type	Description
startParameter	RangeStartParameter	A parameter range’s start parameter.
endParameter	RangeEndParameter	A parameter range’s end parameter.

Example

The code sample below uses a RangeParametersSettings class instance to create a date range parameter, set the range value to the last 7 days, and filter report data by this range.

C#

using DevExpress.XtraReports.Parameters;
using DevExpress.XtraReports.Expressions;
// ...
XtraReport1 report = new XtraReport1();
// Create a date range parameter.
Parameter myDateRange = new Parameter();
myDateRange.Name = "myDateRange";
myDateRange.Description = "Date Range:";
// Set the Visible property to true to request the parameter value from users.
// Set this property to false to silently apply the parameter's value.
myDateRange.Visible = false;
myDateRange.Type = typeof(System.DateTime);
RangeParametersSettings myDateRangeSettings = new RangeParametersSettings();
myDateRangeSettings.StartParameter.Name = "MyDateRangeStart";
// Set the range parameter's start date to 7 days ago.
myDateRangeSettings.StartParameter.ExpressionBindings.Add(new BasicExpressionBinding("Value", "AddDays(Today(), -7)"));
myDateRangeSettings.EndParameter.Name = "MyDateRangeEnd";
// Set the range parameter's end date to today.
myDateRangeSettings.EndParameter.ExpressionBindings.Add(new BasicExpressionBinding("Value", "Today()"));
myDateRange.ValueSourceSettings = myDateRangeSettings;
report.Parameters.Add(myDateRange);
// Filter report data by the specified start and end dates.
report.FilterString = "GetDate([OrderDate]) Between(?MyDateRangeStart,?MyDateRangeEnd)";

VB.NET

Imports DevExpress.XtraReports.Parameters
Imports DevExpress.XtraReports.Expressions
' ...
Dim report As New XtraReport1()
' Create a date range parameter.
Dim myDateRange As New Parameter()
myDateRange.Name = "myDateRange"
myDateRange.Description = "Date Range:"
' Set the Visible property to true to request the parameter value from users.
' Set this property to false to silently apply the parameter's value.
myDateRange.Visible = False
myDateRange.Type = GetType(Date)
Dim myDateRangeSettings As New RangeParametersSettings()
myDateRangeSettings.StartParameter.Name = "MyDateRangeStart"
' Set the range parameter's start date to 7 days ago.
myDateRangeSettings.StartParameter.ExpressionBindings.Add(New BasicExpressionBinding("Value", "AddDays(Today(), -7)"))
myDateRangeSettings.EndParameter.Name = "MyDateRangeEnd"
' Set the range parameter's end date to today.
myDateRangeSettings.EndParameter.ExpressionBindings.Add(New BasicExpressionBinding("Value", "Today()"))
myDateRange.ValueSourceSettings = myDateRangeSettings
report.Parameters.Add(myDateRange)
' Filter report data by the specified start and end dates.
report.FilterString = "GetDate([OrderDate]) Between(?MyDateRangeStart,?MyDateRangeEnd)"