Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing columns
Message
From
13/06/2006 03:57:15
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01128070
Message ID:
01128604
Views:
21
Hello Cathy !

Sorry, but i have no idea, how to handle your suggestion.

Until now my cursor looks like this:
CREATE CURSOR mylistcursor( nl c(4),pnr c(7),auftragsnr c(6),bezeichnung c(100),name c(36),vorname c(36),schichtplan c(10),;
pauschale n(7,2),fahrtgeld n(7,2),stundensatz n(5,2),eintritt_nl c(8),eintritt_av D,austritt d,;
sum_stunden n(7,2),sum_tage n(7,2),monat n(2,0),jahr n(4,0),farbe c(6),spkz c(1),stauftragsstammid c(10),;
tag1 n(6,2),tagkz1 c(2),farbe1 c(6),datum1 c(2),;
tag2 n(6,2),tagkz2 c(2),farbe2 c(6),datum2 c(2),;
tag3 n(6,2),tagkz3 c(2),farbe3 c(6),datum3 c(2),;
tag4 n(6,2),tagkz4 c(2),farbe4 c(6),datum4 c(2),;
tag5 n(6,2),tagkz5 c(2),farbe5 c(6),datum5 c(2),;
tag6 n(6,2),tagkz6 c(2),farbe6 c(6),datum6 c(2),;
tag7 n(6,2),tagkz7 c(2),farbe7 c(6),datum7 c(2),;
tag8 n(6,2),tagkz8 c(2),farbe8 c(6),datum8 c(2),;
tag9 n(6,2),tagkz9 c(2),farbe9 c(6),datum9 c(2),;
tag10 n(6,2),tagkz10 c(2),farbe10 c(6),datum10 c(2),;
tag11 n(6,2),tagkz11 c(2),farbe11 c(6),datum11 c(2),;
tag12 n(6,2),tagkz12 c(2),farbe12 c(6),datum12 c(2),;
tag13 n(6,2),tagkz13 c(2),farbe13 c(6),datum13 c(2),;
tag14 n(6,2),tagkz14 c(2),farbe14 c(6),datum14 c(2),;
tag15 n(6,2),tagkz15 c(2),farbe15 c(6),datum15 c(2),;
tag16 n(6,2),tagkz16 c(2),farbe16 c(6),datum16 c(2),;
tag17 n(6,2),tagkz17 c(2),farbe17 c(6),datum17 c(2),;
tag18 n(6,2),tagkz18 c(2),farbe18 c(6),datum18 c(2),;
tag19 n(6,2),tagkz19 c(2),farbe19 c(6),datum19 c(2),;
tag20 n(6,2),tagkz20 c(2),farbe20 c(6),datum20 c(2),;
tag21 n(6,2),tagkz21 c(2),farbe21 c(6),datum21 c(2),;
tag22 n(6,2),tagkz22 c(2),farbe22 c(6),datum22 c(2),;
tag23 n(6,2),tagkz23 c(2),farbe23 c(6),datum23 c(2),;
tag24 n(6,2),tagkz24 c(2),farbe24 c(6),datum24 c(2),;
tag25 n(6,2),tagkz25 c(2),farbe25 c(6),datum25 c(2),;
tag26 n(6,2),tagkz26 c(2),farbe26 c(6),datum26 c(2),;
tag27 n(6,2),tagkz27 c(2),farbe27 c(6),datum27 c(2),;
tag28 n(6,2),tagkz28 c(2),farbe28 c(6),datum28 c(2),;
tag29 n(6,2),tagkz29 c(2),farbe29 c(6),datum29 c(2),;
tag30 n(6,2),tagkz30 c(2),farbe30 c(6),datum30 c(2),;
tag31 n(6,2),tagkz31 c(2),farbe31 c(6),datum31 c(2))

Order by auftragsnr,jahr,monat,pnr

I print auftragsnr,jahr,monat ... at top of each page
pnr,name,vorname, tag1-tag31,tagkz1-31,sum(tage),sum(stunden) ... in a detail colom
with 4 coloms fitting on one page.
I use farbe1-farbe31 to do some individual background coloring for tag1-31 and tagkz 1-31(weekends,feasts,...)


How to create a cursor from mylistcursor that holds the information i need in one column ????

Best regards
Albert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform