Reporting in grid format

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top