I have a report (BothShifts) that contains two sub reports (Shift1 and Shift2). Each sub report is based on a query of the same name.

The layout of BothShifts is such that Shift1 is displayed on the left of the page and Shift2 on the right. Both subreports have the same layout:

Team Leaders
{leader 1}
..
{leader n}

Handlers
{handler 1}
..
{handler n}

Operators
{operator 1}
..
{operator n}

What I'm trying to resolve is the fact that the subreports need to look 'uniform', in spite of the fact that the number of people under each heading may vary. For example, if there are five handlers on Shift1 but only three on Shift2, I still want the next heading (Operators) for Shift1 to line up with the corresponding heading for Shift2. At present, the Operators heading on the Shift2 form will be two rows higher up the page than its Shift1 counterpart.

Any thoughts?

Make sub reports for Team Leaders, Handlers & Operators. ?

Yeah, I thought about that and I've been doing just that, while I waited to hear back from the forum. I was hoping there was just some obvious setting I was missing.

Thanks for the suggestion. I shall post if it works out.

Okay, almost got this one sorted.

I have a page header and footer, containing just the report title, the column headings and the number of pages in the report.

In the report's Details section, there are ten sub reports (five for each shift). All are lined up correctly and it looks fine.

As the user clicks on a button to display the report, the 'Filter' property of each sub report is dynamically set to the appropriate zone name, and each shift's Team Leaders, handlers, etc. are displayed.

I do, however, still have one problem and one 'is it possible' query:

1) I always get one final page displayed, containing just the Page Header and Page Footer. I assumed this was because something in the Details section overlapped onto the next page, but I've made sure this isn't happening. I've tried playing with the Page Header and Page Footer properties of the Report, but I either lose the Header and Footer altogether or get the same results. Any ideas what could be causing it?
2) At the moment, the only way I could think of to dynamically set the Filters was to open each sub report, set the filter, close and save the sub report, then open the main report. This works perfectly, but looks terrible, as the user can see each report flicker on-screen, as it gets reset. Is there a neater way to reset these values?

As usual, any feedback is very much appreciated.

I've managed to sort out or work around all issues, apart from the 'refresh' one.

I have a report that contains up to ten sub reports (depending on the data). I'm dynamically changing the filters on each report, based on criteria selected by the user. This works fine and results in each form opening, having it's filter changed, closing, then being reopened as one of the sub forms. Unfortunately, the user gets to see this happening.

I'm hoping there's a way to refresh the reports without the user seeing it happen?

The only alternative I can think of is to create multiple copies of each report and hard code the filter criteria in each one. This would work but has obvious drawbacks.

Any thoughts?