Create Access Report Actions

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