Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with SQL
Message
From
13/11/2008 10:26:57
 
 
To
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:
01361666
Views:
14
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform