|
|
Sample Access 2007: Creating Advanced Report
By: Hermawih Hasan
If I tell you that I can create more than one hundred
different combinations of report with only one form and one
report, will you believe me? You better be since I have a
sample for that. At this sample, I demonstrated how to
create flexible reporting by using only one form menu and
one report. This also possible because of the its database
design. Instead of creating six different tables for
different types of transaction, I create only one table
transaction. To be able store six different transaction, I
add one field for transaction type on the table.
You see a lot of coding in the sample. You can change,
update and use it for your application. Make your boss
impress by adopting this advanced Access Reporting technique
for your own application. Do you notice that you can change
the title of the report manually?
Now for a challenge,
- Can you change the fmnuReport so it able to show
all six different roots for all six types of
transaction? You should do this by detecting the
availability of the transactions for that particular
type. For example, if there are two different types of
transactions, Sales and Purchasing then the form are
able to show two roots, Sales and Purchasing.
- Can you change the fmnuReport so it able to
show all transaction for all years without the need to
select a year in a combo box?
This sample is only for learning. With real data with so
many records, this approach is perhaps not applicable.
With real data, creating summary of transactions is good
approach to increase the speed. One last final comment,
If your backend data is separated with the front end
application in different machine then consider creating
local data in XML format.
Download
Sample
|
