Craig,
I don't think you can do it in the group footer. I did something similar by expanding the Detail section to hold both sets of data.

a) Get all the data into a single cursor. It will have the fields for your 35 individual Jobs records AND fields for the 7 DateHeader records. Also you'll need a sorting field (1 char, called 'MySort').

b) Put "0" in the MySort field for the Jobs data (all of the DateHeader fields will be blank).

c) Put "1" in the MySort field for the DateHeader records(all of the Jobs fields will be blank)

d) In your Report Detail area, put the Jobs fields as you have them now, but put a "Print When" that prints only when the MySort field is "0" (Don't forget the labels if any).

e) Add Detail lines for the DateHeader records, with Print When for Mysort = "1".

I hope this will get you started. It's tedious, but I did it for 3 sets of very disparate data and it worked perfectly after a LOT of debugging.

Barbara

>In VFP 5.0 I've been working on trying to make specific needs on a report to work for about a month now unsuccessfully. Rather than tell you all the ways I have tried I'll set up the backbone and what I'm looking to do.
>
>I have a table called "Jobs". 2 of its fields are JobDate and WeeksEnd. When info is entered for the table Jobs from a grid form each record has the appropriate day's date and the end of that week's date entered. Also there is another table called "DateHeader" which has, not only the same 2 fields as above, but other fields specific to that JobDate. In other words, the table Jobs has multiple entries (records) per JobDate and the table DateHeader has only one entry (record) per JobDate. So, as an example, the table Jobs could have 5 entries (records) per JobDate X 7 days for that accosiated WeeksEnd = 35 Jobs' records for that WeeksEnd & the table DateHeader would have 1 entry (record) only for each day of that WeeksEnd = 7 DateHeader's records for that WeeksEnd. What I need to do in the report in question is to first, group by WeeksEnd all of the table Jobs' records for that week (the 35 records as in the above example) -- that's easy. Second, what I'm having trouble with, in
>the group footer for that WeeksEnd show all the table DateHeader's records for that WeeksEnd (the 7 records as in the above example). Then move on to the next WeeksEnd group and so on, and so on...
>
>I have tried everything I can think of including Parent/Child/1-to-many, Views, & even Object Classes with UDFs. I might be making this too difficult and hopfully there's an easy way that I have overlooked.
>
>I'd appreciate any helpfull tips/directions that you might have to offer!!!
>
>Thanks in advance,
>Craig