>Is it possible with the foxpro native report writer Nest detail bands, or create 2 detail bands?
The best you can do is to simulate 2 or more detail bands using some condition for the "print when". You would need to "combine" the data for the multiple detail bands into one cursor for the report, identifying the different "detail bands" in the cursor.
Table1 has field1 & field2
Table2 has field3 & field4
SELECT '1' AS BAND, ;
field1, ;
field2, ;
field3 AS SPACE(whatever), ;
field4 AS SPACE(whatever) ;
FROM table1 ;
UNION (SELECT '2' AS BAND ;
field1 AS SPACE(whatever), ;
field2 AS SPACE(whatever), ;
field3, ;
field4 ;
FROM table2) ;
INTO CURSOR reportdata
Now use the cursor field BAND in the "print when" conditions.