RangeParametersSettings.StartParameter Property

A range parameter’s nested start parameter.

Namespace: DevExpress.XtraReports.Parameters

Assembly: DevExpress.Printing.v19.2.Core.dll

Declaration

C#

public RangeStartParameter StartParameter { get; }

VB.NET

Public ReadOnly Property StartParameter As RangeStartParameter

Property Value

Type	Description
RangeStartParameter	A range parameter’s start value.

Remarks

Note

If the parameter’s Visible property is set to true, users are requested to select the start and end dates before the report is generated. The selected start and end dates include the 12:00:00 AM time.

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 apply the parameter's value that is specified in code.
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
' ...
Private report As New XtraReport1()
' Create a date range parameter.
Private 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 apply the parameter's value that is specified in code.
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)"