You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > Access It! Universal.NET > Access It! Universal.NET Features > Access It! Universal.NET Report Designer
Access It! Universal.NET Report Designer

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. 

Access It!® ReportDesigner

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

Feedback
0 out of 0 found this helpful

scroll to top icon