Create Access Report actions write the contents
of one or more Table datasets to one or more Microsoft Access database
tables. The Access database is created from a template that may be uploaded
by selecting the Data/Report Templates/Access
Templates folder in the LiveCompare hierarchy.
When a Create Access Report action is run,
a new Access report is generated based upon the template database, and
stored in a folder underneath the LiveCompare user data directory. If
the Create Access Report action’s Fixed parameter is set to ‘false’,
its reports are stored in the following time-stamped directory:
<LiveCompare user data dir>\public\Reports\<Workspace
Name>\<Report Name>_YYYYMMDD_HHMMSS
If the Create Access Report action’s Fixed
parameter is set to ‘true’, its reports are stored in the following directory,
which does not include a time stamp:
<LiveCompare user data dir>\public\Reports\<Workspace
Name>\<Report Name>
Action Property
Description
Fixed
A Boolean
parameter which indicates whether the Create Access Report action
will generate fixed location reports. If this parameter is set to ‘true’,
the action stores its report in the <Report Name> directory; this directory will be removed and then recreated
each time the action is run. If the Fixed parameter is set to ‘false’,
a new report will be generated in its own time-stamped directory each
time the action is run.
Each fixed location report in a workspace should
normally have a different value for its Report Name parameter. This
will ensure that each workflow’s Report URL dataset points to the expected
report.
Report Name
A String parameter
which stores the name used for the generated report. If the Fixed parameter
is set to ‘false’, the generated report name includes a timestamp indicating
when the report was created. The generated Access database is named <Report
Name>.accdb, excluding any characters that are not permitted in for
use in filenames.
Report URL
A String dataset
which is set to contain the directory location of the generated Access
report.
Source to Table Map
A Pair List
parameter which maps the Source1 or Source2 tables to tables in the
Access database. The first item in each pair list should be set to either
‘Source1’ or ‘Source2’. The second item in each pair list should refer
to an empty table with matching column names in the template database.
Source1
A Table dataset
containing a set of source data to be written to the Access database.
Source2
A Table dataset
containing a second set of source data to be written to the Access database.
Template Database
A String parameter
which contains the name of a template Access database stored in the ‘AccessReports’
directory on the LiveCompare server. The databases stored in this directory
may be selected from a drop-down list.
If a mapped table does not already exist in
the template database, a new table is created automatically in the Access
report database. The new table has the same name and column definitions
as the Table dataset associated with the corresponding ‘Source’ action
property.
Generated Access reports may be opened by double-clicking
the Report URL dataset, or choosing ‘View Details’ from the dataset’s
context menu. In order to view each report, your client web browser must
have the following security settings specified for the ‘Internet’ and
‘Local Intranet’ zones. These settings can be found in the ‘Downloads’
section of Internet Explorer’s ‘Security Settings’ dialog:
Setting
Value
Automatic prompting for file downloads
Enable
File download
Enable
Generated Access reports may also be accessed
from a workspace’s Reports folder in the LiveCompare hierarchy. Choose
‘Reload Children’ from the folder’s context menu to list any newly-generated
reports.
Example:
To examine the details
for a Create Access Report action, double-click the action node, or select
‘View Details’ from the node’s context menu. The Details screen displays
the number of records read from each source dataset, the number of records
written to each Access database table and the time taken for the action
to complete.
Create Access Report actions
support the use of the Define
Action Parameters Wizard which allows new ‘Source’ input parameters
to be created with the type ‘Table’. This allows Access reports to be
created from more than two Table datasets.