Data Environment Object Query

[mogura]

I’m developing a database application using a Data Environment object named deMyDatabase. I’ve created a report object named drMyCustomers using the Data Report Designer. In deMyDatabase I’ve set up a Command object named cmdCustomers that contains the following fields:

CustomerID
LastName
PhoneNo

I want drMyCustomers to list customers by last name. Next to the last name fields on the report, I want to display the CustomerID and PhoneNo fields. Should I:

Set the DataSource property for drMyCustomers equal to cmdCustomers and set the DataMember property for drMyCustomers equal to deMyCustomers. Then drag the Lastname, CustomerID and PhoneNo fields from cmdCustomers in the Data Environment to the Group section of drMyCustomers.

Is this right?

 

[zyrag]

interchange them... at design time, try this..

set drMyCustomers.DataSource=deMyCustomers
drMyCustomers.DataMember=cmdCustomers

then, right-click on the report and click 'Retrieve Structure'. You can then do a drag-n-drop... You will know if dragging the field into different section of the report is allowed or not.

If you want to do a Grouping, right-click on the Command object, select Properties, then move to the Grouping tab.

For tutorials, follow "Creating a Simple Data Report" series in your MSDN.

 

[mogura]

Thanks for the advice!