Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help with SQL
Message
De
13/11/2008 10:16:46
 
 
À
13/11/2008 10:08:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01361585
Message ID:
01361657
Vues:
13
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform