Overview

Access It! Universal.NET introduces a newly designed report designer.

The report designer feature is available as an add-on option and may be purchased through an Authorized RS2 Dealer.

Access It! Universal.NET Licensing
The following licensing option must be enabled within the Access It! Universal.NET dongle and is a system wide license.

• Report Designer - Yes

Report Designer

The Report Designer form can be broken into four separate areas as outlined below. 

1. Toolbox Pane
2. Designer Pane
3. Explorer Pane
4. Properties Pane

Toolbox Pane

The toolbox pane contains a collection of static objects. To add a tool to the report designer, simply drag and drop the object from the tools pane to the designer pane. Once added, the object will also be displayed in the explorer pane.

Designer Pane

The designer pane represents how the objects will be printed on the report itself. Objects can be moved by drag and dropped, or aligned via the alignment options available from the toolbar. The designer also supports a zoom feature allowing for zoom up to 400%. This is particularly useful when needing to adjust an object by a very small amount. The script tab allows for custom vb.net scripting to be applied to the designer and should only be used by advanced users.

Explorer Pane

The explorer pane contains all the database fields  currently available to be placed in the designer. In order to generate the database fields, a custom SQL query must be entered by selecting the Edit Data Source link displayed when the report header object is selected in the explorer pane. Once a SQL query has been added, the database fields can be found in the Fields | Bound list. To add a field to the report designer, simply drag and drop the object from the tools pane to the designer pane. When designing a SQL query, a placeholder can be used to substitute values entered when running reports, more information on this below.

Properties Pane

The properties pane allows for control of the properties for the item selected in the designer pane. To adjust overall report properties, such as the SQL data source, the report header object must be selected within the explorer pane. While most properties are self-explanatory, detailed descriptions can be requested from RS2 Technical Support.

Search Criteria 

When running the report, the search criteria prompted is based on the report category. Report categories can be changed from the File | Report |Category list. When designing a custom SQL script, a placeholder can be utilized to substitute the search criteria entered when running the report. This placeholder will also take into account the permission the logged in user has and will not display any unauthorized data. It is recommended a stock report be edited in order to obtain a better understanding of how these placeholders work within the SQL query.

• Access Levels
  When running an Access Level report and specifying search criteria, the criteria will be inserted where the following placeholder is located.
  • <%AccessLevelIDsByUser%>
• Card Groups
  When running a Card Group report and specifying search criteria, the criteria will be inserted where the following placeholder is located.
  • <%CardGroupIDsByUser%>
• Cardholders
  When running an Cardholder report and specifying search criteria, the criteria will be inserted where the following placeholder is located.
  • <%CardholderIDsByUser%>
• Cards
  When running an Card report and specifying search criteria, the criteria will be inserted where the following placeholder is located.
  • <%CardIDsByUser%>
• Company
  When running an Company report and specifying search criteria, the criteria will be inserted where the following placeholder is located.
  • <%CompanyIDsByUser%>
• Floor Codes
  When running an Floor Code report and specifying search criteria, the criteria will be inserted where the following placeholder is located.
  • <%AccessLevelIDsByUser%>
• Holidays
  When running an Holiday report and specifying search criteria, the criteria will be inserted where the following placeholder is located. 
  • <%HolidayIDsByUser%>
• Inputs
  When running an Input report and specifying search criteria, the criteria will be inserted where the following placeholder is located. 
  • <%InputIDsByUser%>
• Intervals
  When running an Interval report and specifying search criteria, the criteria will be inserted where the following placeholder is located. 
  • <%IntervalIDsByUser%>
• IP Locksets
  When running an IP Lockset report and specifying search criteria, the criteria will be inserted where the following placeholder is located. 
  • <%LocksetIDsByUser%>
• Macros
  When running an Macro report and specifying search criteria, the criteria will be inserted where the following placeholder is located. 
  • <%MacroIDsByUser%>
• Outputs
  When running an Output report and specifying search criteria, the criteria will be inserted where the following placeholder is located. 
  • <%OutputIDsByUser%>
• Readers
  When running an Reader report and specifying search criteria, the criteria will be inserted where the following placeholder is located. 
  • <%ReaderIDsByUser%>
• Recipients
  When running an Recipient report and specifying search criteria, the criteria will be inserted where the following placeholder is located. 
  • <%RecipientIDsByUser%>
• Timezone
  When running an Timezone report and specifying search criteria, the criteria will be inserted where the following placeholder is located.
  • <%TimezoneIDsByUser%>
• User Groups
  When running an User Group  report and specifying search criteria, the criteria will be inserted where the following placeholder is located.
  • <%UserGroupIDsByUser%>

Custom Search Variables

Beginning in Access It! Universal.NET 7.3 the ability to add in customized search parameters has been added. The variables are made up of three components separated by a pipe. The first component is the variable name and control type, the second is the static text that will be displayed when running report, and the third is the default value for the parameter.

• Date
  To add a customized date field the following needs to be added into the reports SQL query:
  • <%BeginDate;D|Enter Beginning Date:|12/22/2018%>
• DateTime
  To add a customized datetime field the following needs to be added into the reports SQL query:
  • <%BeginDateTime;DT|Enter begin date/time:|2019-05-17 12:00:00%>
• Time
  To add a customized time field the following needs to be added into the reports SQL query:
  • <%BeginTime;T|Enter begin time:|12:00:00%>
• Text
  To add a customized text field the following needs to be added into the reports SQL query:
  • <%LastName;S|Enter last name:|Sulek%>
• Numeric
  To add a customized numeric field the following needs to be added into the reports SQL query:
  • <%UnusedDays;N|Enter Unused Days:|30%>
• Checkbox
  To add a customized checkbox field the following needs to be added into the reports SQL query:
  • <%APBExempt;B|Include APB Exempt:|1%>