Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with SQL
Message
From
13/11/2008 10:16:46
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01361585
Message ID:
01361657
Views:
12
>yes, thanks, Ed.
>
>If the result cursor has more employees in it than there are columns across the (landscape) page to fit on the report then I do the following:
>
>Say there are 10 columns of booked/charged data across the page. Then I go through the cursor and get each set of 10 records into a special cursor i keep just for the report.
> I report form this "batch" of 10 records then get the next 10 from the cursor.
>And so on till all the cursor recs have been printed.
>
>BTW, sorry but I need to leave work in 20 mins, so maybe carry this on tomorrow after that.
>
Sure, there still one issue left. If let's say Inv#1 has employees Bob and John, and next Inv.#2 has Derek and Paul; do you report them in 4 or 2 columns? In other words, each employee has fixed position in the report or you always squeeze them and print employee name in each report line? I suspect that the latter is the case, but still will appreciate if you confirm it. Could you do it now? If yes, then I will give full report querying outline in the next message and you could look at it when you get home.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform