Group footer not showing on first page

[TinaCa]

I have a report (Invoice) with two subreports. The first sub is in the detail section. The second is in the Group Footer for the Company - with a total amount (for the invoice). I finally got everthing working except now when the report prints the group footer amounts show on all the pages except the first.



I have checked the Properties for Page Header, Page Footer, Visible for all sections of the report. they are all set to Always. I have no page breaks indicated in the report. I have resized the sub report section to a smaller height - no luck.

Update - it shows in Report View but not in Print Preview.

Update - that first record is a duplicate. I have tried suppress duplicates but it's not fixing the issue.

any ideas?

[TinaCa]

I solved it. The issue was my data for the report. I had included columns in the query that would repeat consequently the company repeated twice, hence showing a record for each instance of the company id. Since I had keep group together it didn't show a total for the Company until the second instance or the second page.