Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want Sort Order For Child table, But need fields from Ma
Message
From
01/12/1998 16:16:19
 
 
To
01/12/1998 16:12:12
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00162751
Message ID:
00162960
Views:
33
>I will have dozens of different reports. I am not very experienced in the Properties Box. I Would like to be able to find an explaination, the logic behind the relationships and order. There are so many properties and some of them react violently when tampered with. What ever you find, keep me in mind! Thanks!

Robin, it's redundancy to use views for reporting pusposes, especially having separate view for each order setting. The reporting is job for cursors with their WHERE and ORDER clauses compiled programmatically, like this
DO CASE
CASE ...
cOrderstring="name"
CASE ...
cOrderstring="id"
CASE ...
cOrderstring="account_number"
ENDCASE
Select ... From ... Into Cursor tmp Order by &cOrderstring.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform