If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A3 Report layout help
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. |
#2
|
|||
|
|||
A3 Report layout help
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" wrote in message news 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. |
#3
|
|||
|
|||
A3 Report layout help
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" wrote: 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" wrote in message news 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. |
#4
|
|||
|
|||
A3 Report layout help
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/f...ics.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 "Hans" wrote in message ... 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" wrote: 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" wrote in message news 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. |
Thread Tools | |
Display Modes | |
|
|