1. In the Report Explorer, right-click the Data Sources node and select Add Data Source. The Report Data Source dialog appears, open to the General page.
2. On the General page, drop down the Type list and select Microsoft OleDb Provider.
3. Under Connection, on the Connection Properties tab, drop down the OLE DB Provider list and select Microsoft.Jet.OLEDB.4.0.
4. In the Server or file name box, enter the path and file name to your Access database, for example,
   C:\Users\YourUserName\Documents\GrapeCity Samples\ActiveReports 10\Data\NWIND.MDB.
5. Click the Accept button. The new data source is added to the Data Sources node. To use fields from the data source, add a data set.

1. In the Report Explorer, expand the DataSources node, right-click the node for the data source that you want to share, and select Share Data Source. The Save Shared Data Source File dialog appears.
2. Navigate to the folder where you want to save the file, enter a name for the file, and click Save.
3. The type of data source as well as the connection string are saved to a file of type RDSX that you can use in other reports.

1. In the Report Explorer, expand the DataSources node, right-click the node for the data source that you want to use, and select Add DataSet. The DataSet dialog appears.
2. In the list to the left, select Query to show the Query page.
3. In the Query box to the right, enter a SQL query to pull the data you want for your report.

   Example Query	Copy Code
   SELECT * FROM Customers

4. Click the Accept button to create the data set. The data fields appear in the data set node.

1. In the Report Explorer, expand the DataSources node, then the node for the data source, then the DataSet that you want to use.
2. From the DataSet node, click the DataSet field that you want to bind to a TextBox control, drag it onto the report surface or onto a data region and drop it.
3. A TextBox control is created and bound to the field with the proper expression in the Value property. For example, if you drag the City field onto the report, the Value property of the TextBox contains the expression =Fields!City.Value.

In ActiveReports, you can create and access data sets that are hosted on ActiveReports Server. Server shared data sets retrieve data from server shared data sources to provide data to multiple reports. ActiveReports allows you to use only one type of data set for your report, either local or shared. 

A server shared data set  that you add to your report is an instance of data set hosted on ActiveReports Server. If you make any changes to the data sets that are added to your report, the changes are not reflected on the server.

You can override the following server shared data set settings in ActiveReports.

• Create additional calculated fields
• Create additional filters
• Override data set options
• Override parameter options and values

Use the following steps to add a Server Data Set to your report.

1. Connect your Stand-Alone Designer to ActiveReports Server if you are not already connected to the server. See Connecting to ActiveReports Server for further information.
2. In the Report Explorer, right-click the Server Data Sets node, and then select Add Data Set or select Shared Data Set from the Add button. The Add Server Data Set dialog appears.
3. In the Add Server Data Set dialog that appears, select a data set from the list.
   
4. Click OK to add the data set. The Server Data Sets node is populated with fields returned by the query.
   Once you add a server shared data set to your report, ActiveReports automatically marks the report as a remote report. Remote reports are executed on ActiveReports Server.
   Note: Users should at least have Read permission to access the Server Shared Data Set. For more information, see Managing Data Sets.

1. In the Report Explorer, right-click the Parameters node and select Add Parameter. The Report Parameters dialog appears.
2. On the General tab of the dialog, enter text for prompting users for a value.
3. On the Available Values tab, you can select values from a DataSet to populate a list from which users can select a value.
4. On the Default Values tab, you can provide default values to use if the user does not select a value.
5. Click Accept to save the parameter. The new parameter appears in the Report Explorer under the Parameters node.
6. From the Report Explorer, drag the parameter to report design area to create a TextBox that is bound to the parameter. When you run the report, the value that the user supplies in the prompt dialog displays in the bound TextBox on the report.