Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want Sort Order For Child table, But need fields from Ma
Message
 
To
01/12/1998 11:16:19
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00162751
Message ID:
00162805
Views:
21
Create the cursor from wherever you call the report. Say for example you have a myreportbutton on a form for running this report, you might have something like this in the .Click:

SELECT .......... INTO CURSOR cMyReport
REPORT FORM PREVIEW

You would reference fields from cMyReport in your report.

>Thanks for the quick reply to my problem. I don't know how to place SQL in my properties, but, I will try dragging the relationship from the child to the master in the data environment. Thank you so much! (PS Where would I look to learn how to create the SQL and WHERE to put it) I do know how to view, cut, and paste SQL that has been generated, but have no clue how to use it in the properties.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform