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
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