SqlStatement Property

The SQL statement used to obtain the charting data.

[Visual Basic]
Public Property SqlStatement As String

[C#]
public string SqlStatement {get; set;}

Remarks

The first column returned is used for the X values, and the second for the Y values. The first also has special handling if dates are returned as the DateGrouping property can be used for intelligent date handling and grouping. The third column is optional and is used only for SplitBy. When a third column is set it is used automatically to create a unique series based on each unique value in this column.

NOTE: All date values in your SQL statements should be wrapped with the pound symbol: #10/25/2002#, regardless if Access or SQL server is used. Also the #StartDate# and #EndDate# tokens can be used in which case the dates set for these properties will be set in place of the tokens before the SqlStatement is executed.

See Getting Started > Tutorials > Queries for more info.

Example

[C#]

de.Series.SqlStatement = "SELECT OrderDate,Total FROM Orders"; 
  
//If you are doing a SplitBy you would need another field to correspond to your SplitBy value i.e.  
de.Series.SqlStatement = "SELECT OrderDate,Total,Customer FROM Orders";

[Visual Basic]

de.Series.SqlStatement = "SELECT OrderDate,Total FROM Orders"



'If you are doing a SplitBy you would need another field To correspond To your SplitBy value i.e.

de.Series.SqlStatement = "SELECT OrderDate,Total,Customer FROM Orders"

See Also

Language

SqlStatement Property

Remarks

Example

See Also