MOD2000: DataSource Property Missing in the Data Report Designer (236538)


The information in this article applies to:

  • Microsoft Office 2000 Developer
This article was previously published under Q236538

SYMPTOMS

When you use a Data Environment designer to bind a recordset to a Data Report, the Data Environment does not automatically link its recordset to the Data Report.

RESOLUTION

To bind the Data Environment to the Data Report, create a Command object that is based on a table or query, and then drag it onto a blank report in the Data Report designer. To do so, follow these steps:
  1. Create a Data Environment Command object by right-clicking the Connection objects, and then clicking Add Command.
  2. Right-click the newly created command, and then click Properties.
  3. On the General tab, link the command to a recordset by filling in the Source of Data options.
  4. Open a Data Report designer.
  5. Drag the Command object from the Data Environment designer to the Data Report designer.

MORE INFORMATION

Steps to Reproduce the Behavior:

  1. Start Microsoft Outlook, and then start the Visual Basic Editor by pressing ALT+F11.
  2. On the Insert menu, click Components.
  3. Click the Designers tab, click to select the Data Environment and the Data Report check boxes, and then click OK.
  4. To create a new project, on the File menu, click New Project. In the New Project dialog box, click Empty Project, and then click OK.
  5. On the Insert menu, click Data Environment.
  6. Right-click Connection1, and then click Properties to open the Data Links Properties dialog box.
  7. On the Provider tab, double-click Microsoft Jet 4.0 OLE DB Provider.
  8. Specify the source of data to use the data source name of MS Access Database, and then enter an initial catalog (for example, C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb).
  9. Click OK to close the Data Links Properties dialog box.
  10. On the Insert menu, click Data Report.
Note that the data source is missing from the Data Report properties.
Modification Type:MajorLast Reviewed:12/6/2000
Keywords:kbprb KB236538
©2002 Microsoft Corporation. All rights reserved.