Create a cursor that 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),;
dataset N(1), ;
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),;

Instead of having one record that fills fields labeled XXXX1-31, create 7 records with the following:

dataset = 1, XXX1 for 1, XXX2 for 2, XXX3 for 3, XXX4 for 4, XXX5 for 5
dataset = 2, XXX1 for 6, XXX2 for 7, XXX3 for 8, XXX4 for 9, XXX5 for 10
dataset = 3, XXX1 for 11, XXX2 for 12, XXX3 for 13, XXX4 for 14, XXX5 for 15
dataset = 4, XXX1 for 16, XXX2 for 17, XXX3 for 18, XXX4 for 19, XXX5 for 20
dataset = 5, XXX1 for 21, XXX2 for 22, XXX3 for 23, XXX4 for 24, XXX5 for 25
dataset = 6, XXX1 for 26, XXX2 for 27, XXX3 for 28, XXX4 for 29, XXX5 for 30
dataset = 7, XXX1 for 31, the rest empty

Now you can define the report with 1 column, but print XXX1, XXX2, XXX3, XXX4, and XXX5 in the detail band.



>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