Hello all,
With the advice and guidance from everyone, I’ve managed to restore the final report to the expected format.
But in all that I’ve got a question about how the report was originally designed (I don’t think it’s the most efficient method).
The final report contains 10 reports in the details as sub reports and does not display the report if there are no projects of that type.
The 10 reports differ only in headers. Each report represents a project type that has its own project funding budget.
Each report is based on a query for the year and that project type or year and current project and funding budget.
Like I mention – it works fine – but is a pain to modify all 10 reports when there is a small format change to be made (change a text forecolor to red) AND the Access program is ~4M
What I was wondering is, can the final report be created without all the sub-reports, but still broken out by project type (with project type header) with a subtotal for that project type and the budget for that project type? The project type header would repeat on the next page if the matches span 2 pages
Simplified example result:
Report header
Page header (with column names)
Project type 1 header
Project type 1 matches
Subtotal Project 1 costs
Project 1 Budget
Empty line
Project type 2 header
Project type 2 matches
Subtotal Project 2 costs
Project 2 Budget
Empty line
Project type 3 header
Project type 3 matches
Subtotal Project 3 costs
Project 3 Budget
Etc…
Page footer
Report footer
Note: if there is no project 2 types, then printout would be project 1 stuff, empty line, project 3 stuff
If I can get a push in the right direction of how to do the grouping and the query, I should be able to experiment and complete it myself.
PLEASE let me know if the current method is the best.
Thanks,
B
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar