The information in this article applies to:
- Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a
SYMPTOMS
The sort order selected in Step 4 of the One-to-Many Report Wizard is not
applied correctly in some cases.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
MORE INFORMATION
Steps to Reproduce Behavior
- Run the following code to create the databases and tables needed. This
example uses the existing sample database (TESTDATA.DBC), so you need to
have the samples installed for this example to work.
*
* REPTSET.PRG: Setup code for duplicating problem
*
CLOSE ALL
CREATE DATABASE CUSTVW
CREATE SQL VIEW CUSTVW1 AS SELECT CUST_ID,COMPANY,MAXORDAMT;
FROM C:\VFP\SAMPLES\DATA\TESTDATA!CUSTOMER
OPEN DATABASE C:\VFP\SAMPLES\DATA\TESTDATA
USE ORDERS
COPY TO ORDER.DBF
CLOSE ALL
CREATE DATABASE CUSTOMER
ADD TABLE ORDER
USE ORDER
INDEX ON CUST_ID TAG CUST_ID DESCENDING
CLOSE ALL
- Open the new databases Custvw and Customer.
- Run the One-to-Many Report Wizard. (On the Tools menu, click Wizards,
and then click Report.
- From Custvw.dbc database, choose the Custvw1 view for the parent table
and add all the fields.
- From Customer.dbc database, choose the Order table and several fields
including Cust_Id. For example, choose Order_Id, Cust_Id and Order_Amt.
Cust_Id is the matching field.
- Under Sort Order (step 4 of the Report Wizard), choose Cust_Id -
descending.
- Choose finish and preview. You will see that the report is in Cust_Id
ascending order even though you specified descending order.
|