1. In the Report Explorer, expand the Fields node.
2. Right-click the Calculated node and select Add.
3. With the field selected in the Properties window, enter a Formula for the calculation (for example, UnitPrice * Discount).

   Note: Do not use an equals sign (=) at the beginning of the formula as you would in the DataField property of a textbox.

4. Drag the calculated field onto the design surface of the report to create a bound textbox.

1. In the Report Explorer, right-click the Parameters node and select Add.
2. With the parameter selected in the Properties window, enter a DefaultValue for the parameter.
3. Select whether to PromptUser for a parameter value, and if so, supply a string for the Prompt.

1. Click the gray report DataSource icon on the Detail section band to open the Report Data Source dialog.
   
2. On the OLE DB tab, next to Connection String, click the Build button.
3. In the Data Link Properties window that appears, select Microsoft Jet 4.0 OLE DB Provider and click the Next button.
4. Click the ellipsis (...) button to browse to your database or the sample Northwind database. Click Open once you have selected the appropriate access path.
5. Click OK to close the window and fill in the Connection String field.
6. In the Query field, enter a SQL query to select the data that you want.
7. Click OK to save the data source and return to the report design surface.

1. Click the gray report DataSource icon on the Detail section band to open the Report Data Source dialog.
   
2. On the SQL tab, next to Connection String, click the Build button.
3. In the Data Link Properties window that appears, select Microsoft OLE DB Provider for SQL Server and click the Next button.
4. Under 1. Select or enter a server name, drop down the box and select your server.
5. Under 2. Enter information to log on to the server, set up your log on information.
6. Under 3. you can select a database on the server or attach a database file.
7. Click OK to close the window and fill in the Connection String field.
8. In the Query field, enter a SQL query to select the data that you want.
9. Click OK to save the data source and return to the report design surface.

1. Click the gray report DataSource icon on the Detail section band to open the Report Data Source dialog.
   
2. On the XML tab, next to File URL, click the .. button.
3. In the Open File window that appears, navigate to your XML data file, select it, and click the Open button (the sample xml data file is located in C:\Program Files\GrapeCity\ActiveReports 6\Data\customer.xml; on a 64-bit Windows operating system the file is located in C:\Program Files (x86)\GrapeCity\ActiveReports 6\Data\customer.xml).
4. In the Recordset Pattern field, enter a valid XPath expression. (for example, //CUSTOMER for the sample xml data file)
5. Click OK to save the data source and return to the report design surface.

1. Double-click in the gray area below the design area of your report to create an event-handling method for the ReportStart event.
2. Add code to:
   • Change the data source at run time
   • Close the data connection
   • Add fields to the report
   • Populate fields in the report

To create a data source in Visual Basic.NET

Dim conn As System.Data.OleDb.OleDbConnection
Dim reader As System.Data.OleDb.OleDbDataReader

Dim dbPath As String = getDatabasePath()
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbPath + "\\NWIND.mdb"
conn = New System.Data.OleDb.OleDbConnection(connString)     
Dim cmdText As String = "SELECT Categories.*, Products.* FROM Products INNER JOIN Categories ON Categories.CategoryID = Products.CategoryID WHERE Products.UnitPrice = 18"
Dim cmd As New System.Data.OleDb.OleDbCommand(cmdText, conn)
conn.Open()
reader = cmd.ExecuteReader()

To create a data source in C#

private static System.Data.OleDb.OleDbConnection conn;
private static System.Data.OleDb.OleDbDataReader reader;

string dbPath = getDatabasePath();
string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbPath + "\\NWIND.mdb";
conn = new System.Data.OleDb.OleDbConnection(connString);
string cmdText = "SELECT Categories.*, Products.* FROM Products INNER JOIN Categories ON Categories.CategoryID = Products.CategoryID WHERE Products.UnitPrice = 18";
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(cmdText, conn);
conn.Open();
reader = cmd.ExecuteReader();

To close the data connection in Visual Basic

reader.Close()
conn.Close()

To close the data connection in C#

reader.Close();
conn.Close();

Warning: Do not access the Fields collection outside the DataInitialize and FetchData events. Accessing the Fields collection outside of these events is not supported, and has unpredictable results.

To add fields in Visual Basic

Fields.Add("CategoryID") 
Fields.Add("CategoryName") 
Fields.Add("ProductName") 
Fields.Add("UnitsInStock") 
Fields.Add("Description") 
Fields.Add("TotalLabel")

To add fields in C#

Fields.Add("CategoryID");
Fields.Add("CategoryName");
Fields.Add("ProductName");
Fields.Add("UnitsInStock");
Fields.Add("Description");
Fields.Add("TotalLabel");

To populate fields in Visual Basic

Try
   reader.Read()
   Me.Fields("CategoryID").Value = reader("categories.CategoryID")
   Me.Fields("CategoryName").Value = reader("CategoryName")
   Me.Fields("ProductName").Value = reader("ProductName")
   Me.Fields("UnitsInStock").Value = reader("UnitsInStock")
   Me.Fields("Description").Value = reader("Description")
   Me.Fields("TotalLabel").Value = "Total Number of " + reader("CategoryName") + ":"
   eArgs.EOF = False
Catch
   eArgs.EOF = True
End Try

To populate fields in C#

try
   {
      reader.Read();
      Fields["CategoryID"].Value = reader["categories.CategoryID"].ToString();
      Fields["CategoryName"].Value = reader["CategoryName"].ToString();
      Fields["ProductName"].Value = reader["ProductName"].ToString();
      Fields["UnitsInStock"].Value = reader["UnitsInStock"].ToString();
      Fields["Description"].Value = reader["Description"].ToString();
      Fields["TotalLabel"].Value = "Total Number of " + reader["CategoryName"].ToString() + ":";
      eArgs.EOF = false;
   }
catch
   {
      eArgs.EOF = true;
   }

1. Double-click in the gray area below the design area of your report to display the code view for the report.
2. Add the following code as shown in the examples below.

   To create a data source in Visual Basic

   Paste INSIDE the class declaration of the report	Copy Code
   Private datasource1 As IEnumerator(Of String) = Nothing Dim list As List(Of String) = Nothing

   Paste INSIDE the class declaration of the report	Copy Code
   Private Function GetIEnumerableData() As IEnumerable(Of String) For i As Integer = 1 To 10 list.Add(String.Format("TestData_{0}", i.ToString())) Next Return list End Function

   To create a data source in C#

   Paste JUST ABOVE the InitializeComponent method	Copy Code
   private IEnumerator<string> datasource = null;

   Paste BELOW the InitializeComponent method	Copy Code
   private IEnumerable<string> GetIEnumerableData() { for (int i = 1; i <= 10; i++) { yield return string.Format("TestData_{0}", i.ToString()); } }

3. Back in design view, click in the gray area below the report to select it.
4. Click the events icon in the Properties window to display available events for the report.
5. Double-click DataInitialize. This creates an event-handling method for the report's DataInitialize event.
6. Add code to the handler to add fields to the report's Fields collection.

   To add fields in Visual Basic

   Paste INSIDE the DataInitialize event	Copy Code
   Me.Fields.Add("TestField") Me.list = New List(Of String) datasource1 = GetIEnumerableData().GetEnumerator()

   To add fields in C#

   Paste INSIDE the DataInitialize event	Copy Code
   this.Fields.Add("TestField"); datasource = GetIEnumerableData().GetEnumerator();

7. Back in design view, click in the gray area below the report to select it.
8. Click the events icon in the Properties window to display available events for the report.
9. Double-click FetchData. This creates an event-handling method for the report's FetchData event.
10. Add code to the handler to retrieve information to populate the report fields.

    To populate fields in Visual Basic

    Paste INSIDE the FetchData event	Copy Code
    If datasource1.MoveNext() Then Me.Fields("TestField").Value = datasource1.Current eArgs.EOF = False Else eArgs.EOF = True End If

    To populate fields in C#

    Paste INSIDE the FetchData event	Copy Code
    if (datasource.MoveNext()) { this.Fields["TestField"].Value = datasource.Current; eArgs.EOF = false; } else eArgs.EOF = true;