Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reports showing only......
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01316516
Message ID:
01317150
Views:
9
>No I guess I do not get how to browse a cursor. Also is there some format I should save this cursor statement in? Or is there somewhere in the report properties I should enter this code???

No, not in the report. Try this:
SELECT strain, quantity, location2, userid, date, notes ;
	FROM Veg ;
	ORDER BY strain ASC, date DESC ;
	INTO CURSOR strainreport
SELECT strainreport
BROWSE   && add this temporary line while working on getting the cursor right
REPORT FORM report1cutt.frx  TO PRINTER  PROMPT  PREVIEW
USE   && closes the cursor
SELECT Veg
USE   && closes the table
>And the report is displaying the data in the same order as I entered it into the the table not the date descending order but the report is filled in properly???

Do the fields have an alias like this: veg.strain
or just the plain field name: strain
Randy Bosma
VFP - Because life is too short to code in something else...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform