dbtoolsPLUS - Microsoft Access tools: HTML report, database manager


AceHTMLReports is an Microsoft Access Class Module designed to easy create HTML reports in Microsoft Access Database.


Standard MS Access reports are easy to use but have several limitations as you know.
  • Poor set of graphic objects you can use. So the design of standard MS Access reports can look tediously and similar.
  • When you want to export the report instead of printing them. Using the built in MS Access function you can export MS Access to MS Word but you loose all graphics object by this method, the MS Word document contains only text.
  • Third party add-ins which export MS Access report in PDF for example still produce very poorly designed reports.
MS Access reports created using AceHTML Reports are not limited by design or export functions.
AceHTMLReports creates reports in HTML code, so you can immediately send it by email or publish it to a web site.

The example below shows how a report is designed using AceHTMLReports.

Template Example 1
Template example (report design)
(printed from editor and exported to pdf)
Report Example 1
Report example
 

AceHTMLReports creates a report based on an HTML template.
The Process of HTML template creation is very similar to the creation of a standard MS Access report.
Structure of HTML template:
HTML Header
[Report Header]
[Page Header]
[Group 1 Header]
[Group 2 Header]
.
[Group n Header]

Body

[Group n Footer]
.
[Group 2 Footer]
[Group 1 Footer]
[Page Footer]
[Report Footer]
HTML Footer

Examples below illustrate the how to design an HTML template

Alphabetical List of Products
Template Example 2
Template and Report
Employee Sales by Country
Report Example 3
Template and Report
 

Orders by Date
Report Example 4
Template and Report
Alphabetical List of Products
(split to pages for printing)
Template Example 5
Template and Report
 
Products
(split to pages for printing)
Report Example 6
Template and Report
   


We used Notepad++ for creating of HTML templates with user defined language.



AceHTMLReport is distributed in two versions: AceHTMLReports Lite and AceHTMLReports Plus
Tag Lite Plus
sections    
{rptReportHeader} yes yes
{rptReportFooter} yes yes
{rptBody} yes1 yes
{rptField} yes yes
{rptPageHeader}   yes
{rptPageFooter}   yes
{rptGroupHeader}   yes
{rptGroupFooter}   yes
tag function    
{rptIf} [{rptElse}]   yes
functions    
sum yes yes
min yes yes
max yes yes
count yes yes
variables    
record yes yes
records yes yes
body-record   yes
page   yes
pages   yes
rest-of-page   yes
current-section   yes
1 except order-by property
Documentation of implemented tags, functions and variables.
©2003-2007 dbtoolsplus