Hi Albert,

in order to get the multiple detail bands to work properly you'll need 3 cursors. One is your main/header cursor and two others which will contain the data you want displayed in your two detail bands. You set relations from the main/header cursor into the two other cursors.

check out this page:

http://msdn.microsoft.com/vfoxpro/default.aspx?pull=/library/en-us/dnfoxgen9/html/VFP9Reports2.asp#vfp9inactn_topic2

for full details.

>Hello Everybody !
>(9.0 greenhorn !!)
>
>I have 2 cursors as results from 2 sql-commands against an server database.
>cursor1 (order by id,year,month,date)
>id,year,month,date(dd-mm-yyyy) ,kz ,worth
>
>1 ,2005,01 ,01-01-2005 ,aa , 1.5
>1 ,2005,01 ,02-01-2005 ,bb , 3.5
>1 ,2005,01 ,03-01-2005 ,aa , 1.5
>1 ,2005,01 ,04-01-2005 ,aa , 2.5
>1 ,2005,01 ,05-01-2005 ,bb , 4.5
>1 ,2005,01 ,06-01-2005 ,cc , 0.5
>
>1 ,2005,02 ,01-02-2005 ,aa , 2.5
>1 ,2005,02 ,02-02-2005 ,bb , 3.0
>1 ,2005,02 ,03-02-2005 ,aa , 4.0
>1 ,2005,02 ,04-02-2005 ,cc , 2.0
>1 ,2005,02 ,05-02-2005 ,bb , 4.0
>1 ,2005,02 ,06-02-2005 ,cc , 1.0
>
>
>2 ,2005,01 ,01-01-2005 ,aa , 1.5
>2 ,2005,01 ,02-01-2005 ,bb , 3.5
>2 ,2005,01 ,03-01-2005 ,aa , 1.5
>2 ,2005,01 ,04-01-2005 ,aa , 2.5
>2 ,2005,01 ,05-01-2005 ,bb , 4.5
>2 ,2005,01 ,06-01-2005 ,cc , 0.5
>...
>
>
>cursor2 contains the totals for each id,year,month,kz combination
>(order by id,year,month,kz)
>
>id,year,month,kz,kzcount,kzworth
>1 ,2005,01 ,aa,3 ,5.5
>1 ,2005,01 ,bb,2 ,8.0
>1 ,2005,01 ,cc,1 ,0.5
>
>1 ,2005,02 ,aa,2 ,6.5
>1 ,2005,02 ,bb,2 ,7.0
>1 ,2005,02 ,cc,2 ,3.0
>
>2 ,2005,01 ,aa,3 ,5.5
>2 ,2005,01 ,bb,2 ,8.0
>2 ,2005,01 ,cc,1 ,0.5
>...
>
>
>I want to print an report looking like this:
>***************************************************
>(top of new page)
>id month year
>
>(detail1 band)
>01-01-2005 ,aa , 1.5
>02-01-2005 ,bb , 3.5
>03-01-2005 ,aa , 1.5
>04-01-2005 ,aa , 2.5
>05-01-2005 ,bb , 4.5
>06-01-2005 ,cc , 0.5
>
>(detail2 band)
>summary for month 01
>aa,3 ,5.5
>bb,2 ,8.0
>cc,1 ,0.5
>
>next page = next month same id or new id
>
>************************************************
>
>i tried with 2 detail bands
>
>
>target alias for detail band 1 = "cursor1"
>target alias for detail band 2=
>
>detail band 1 ok
>detail band 2 only 1 (first of cursor2) record ???
>
>
>Any help welcomed
>Best regards
>Albert