A3 Report layout help

[Hans]

I currently trying to design a production schedule report for a catering firm
which prepares breakfact, lunches for its clients.

The report will be on a A3 page, split into 5 columns. Columns 1 to 4 will
consist of 2 rows (It will print 8 records only - 4 up and 4 down), the 5th
column being a summary on the right hand side.

Each record will 3 sections:-

Section 1 - header, will contain, date, time, client, customer ref, no. of
people, ref no.
Section 2 - Middle, will list items ordered and quantity.
Section 3 - Footer, will be special instructions & notes.

The summary column will contain running page totals, I would have attached a
word example but don't know how to attach it here.

Can anyone point me in the right direction to create this report or access
to an example report thats similar to the one i'n trying to create.

thanks in advance.

 

[Jeanette Cunningham]

Hi Hans,
your table setup and the relationships in the database will be the key to
doing this report.
You can create several sub reports and put them on the same report to give
you the different bits and pieces you need.
For example use a subreport for the client and customer ref, no of people -
depending on how your tables are set up.
Put this subreport above the detail section of the main report - perhaps in
the page header - experiment to find the best place for this.
Use the detail section of the main report to show the items ordered and
quantity.
Use the report's summary options and group and sorting options to create the
summary section.
Use another subreport for the special instructions and notes and put it
below the detail section of the main report.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Hans]

Hi Jeanette,
Sorry for the delay i comng back, been racking my brains to work on report
problem. I followed your suggestion and come up with:-

table - tblPQHeader
PQID (PK)
ChildID ,customer
ContactID ,contact
BuffetDate ,date of event
BuffetTime ,time
CustRef ,customer ref
NOPeople ,Number of people
RefNo ,Office Id

table - tblPQDetails
PQID (PK)
PQDId (PK)
MenuGroupID ,Menu Group
MenuItemID ,Menu Id
ReportLabel ,report label displayed on report
QuantityReq ,quantity ordered

table - tblPQFooter
PQID (PK)
PQFId (PK)
SIN ,speaical instruction/notes

sorry I got confuesed when you made reference to reports and subreports.

How would I get only 8 records at a time to print on one A3 sheet, that is 4
columns and 2 rows.?

Regards

Hans

 

[Jeanette Cunningham]

Here are some things to try.

You can add running sum text box
Name: txtRunningCount
Control Source: =1
Running Sum: Over All
Visible: No

Add a Page Break control at the bottom of the detail section
Name: PgBrk

Then add some code to the On Format event

Me.PgBrk.Visible = (Me.TxtRunningCount Mod 8 = 0)


Another approach is the sample database here by AD Tejpal

His sample db named Report_FixedRowsPerPgOrGrp. It is available at Rogers
Access Library. Link -
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

The sample is in Access 2000 file format and demonstrates printing of
fixed number of rows per page or group in an access report. For each case,
two alternative methods are shown:

(a) Solution based upon VBA code in report's module. This does not call
for any interference to report's record source.

(b) Solution based upon SQL of report's record source, minimizing the
need for VBA code. (It makes use of a driver table having a single field
populated with sequential numbers from 1 onwards).



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia