Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Customizing Ms Access reports

Status
Not open for further replies.

kenyajuu

Programmer
Nov 3, 2003
4
KE
Hi forks,
i am having difficulty in designing the following access 97 report.
Let me call the main report master report
A) master report contains a subreport called items
b)At the page footer i have cotrols that have a summary of all the items,mostly subtotal of 1 item if there is only one item or subtotal for all items on the other pages.
My report works fine if there is only one item but for several items i am not getting the correct printout format .How can i a chieve the following
1.Summary section should only appear on( first page footer section)of report & should not appear elsewhere.
2.Page two of the report should contain controls for signing in once report is printed(they are not bound to any table/query).
(in which section of the report should these controls be placed?)
3.page three should have details of the 2nd item only
4.If there is a 3rd item it then it should appear on page 4
i know it has to do with writing code to control how the printout appears but i don't know how and where to start from.I would really appreciate if i can get some sample code.See diagram below.

Page 1
Main report

Detail section
--SubReport…
--ITEM 1 details

Page footer
--Summary
Contains Subtotals of Item1 And all items

Page2

--Dispatch Details
(controls are not
bound to any table) i.e
--Dispatched By………..
--Dispach Date………..


Page3
--Details of Item 2 from subreport

Page4
--Details of Item 3 from subreport


Kind regards
Douglas



 
In order to do this I do either of the following:

1) I'll create one report and put the constant data in the Report Footer section with page breaks to seperate each page.

2) Or I will actually create all the report sections as a seperate report and then bring them together in one blank report. If I need all the data to match then I just have the criteria for each report point to a text box on a form.

Hope that helps?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top