General information
Category:
Reports & Report designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only