M
Martin
I am using ACCESS(.adp) to pull data from SQL Server.
When it comes to reporting, I have a problem and wonder if
you could help.
The report format contains a grid like format. However,
each report output page is required to have three grids
per page. Each grid has ten rows. The grids(like a
background or watermark) need to be printed out in full
whether there are records or not in it. There is a
subtotal on each grid. Since there are three grids per
page, there will be three subtotal per page. It will be
like the following:
Page 1
GRID_1
COLUMN1 COLUMN2 COLUMN3
COLUMN2 COLUMN2 COLUMN3
..
..
SUBTOTAL
GRID_2
COLUMN1 COLUMN2 COLUMN3
COLUMN2 COLUMN2 COLUMN3
..
..
SUBTOTAL
GRID_3
COLUMN1 COLUMN2 COLUMN3
COLUMN2 COLUMN2 COLUMN3
..
..
SUBTOTAL
then go Page 2
When it comes to reporting, I have a problem and wonder if
you could help.
The report format contains a grid like format. However,
each report output page is required to have three grids
per page. Each grid has ten rows. The grids(like a
background or watermark) need to be printed out in full
whether there are records or not in it. There is a
subtotal on each grid. Since there are three grids per
page, there will be three subtotal per page. It will be
like the following:
Page 1
GRID_1
COLUMN1 COLUMN2 COLUMN3
COLUMN2 COLUMN2 COLUMN3
..
..
SUBTOTAL
GRID_2
COLUMN1 COLUMN2 COLUMN3
COLUMN2 COLUMN2 COLUMN3
..
..
SUBTOTAL
GRID_3
COLUMN1 COLUMN2 COLUMN3
COLUMN2 COLUMN2 COLUMN3
..
..
SUBTOTAL
then go Page 2