Microsoft KB Archive/236538

= MOD2000: DataSource Property Missing in the Data Report Designer =

Article ID: 236538

Article Last Modified on 12/6/2000

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



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.



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.

Additional query words: prb

Keywords: kbprb KB236538

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.