Multiple Table Grouping

Hi,
I have two tables based on the same dataset.
The way the report is setup i have it set up with two tables.
One table shows the latest month and the other table shows a 12 month period
of the same data.
It is also grouped by division number.
What i want to do is show both tables (latest and 12 month) for division A
then a page break and then both tables for division B.
Can this be done.Yes, but AFAIK only with 4 Tables. Two for div a and two for div b.
Another thing would be to put the tables horizontally together (in a
retangle ) and do your page break on a group basis.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Fez" <Fez@.discussions.microsoft.com> schrieb im Newsbeitrag
news:702B1045-289B-41DF-A8D0-83A570389534@.microsoft.com...
> Hi,
> I have two tables based on the same dataset.
> The way the report is setup i have it set up with two tables.
> One table shows the latest month and the other table shows a 12 month
> period
> of the same data.
> It is also grouped by division number.
> What i want to do is show both tables (latest and 12 month) for division A
> then a page break and then both tables for division B.
> Can this be done.|||Well the reason i have two tables is because of the size of the inforamtion.
I have to split the data up into 2 tables.