Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help with SQL
Message
De
13/11/2008 10:26:57
 
 
À
13/11/2008 10:16:46
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:
01361666
Vues:
15
>>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?

4 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.

Each employee against whose work an invoice has been raised will appear in a column of HIS data.
Some employees may have hours in different invoices.
Some invoices will have hours under more than one employee (eg several employees' work was invoiced for part of the job)
the employee names will appear only at the top of the column dealing with all the work (invoices) charged against them.

I hope this explains, but I really need to go now (dentist appt.) :-(

Cheers Ed.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform