Crystal reports
The Crystal tab on the Reports view allows you to upload your own Crystal Report templates created outside FortiNAC. You can also download and edit templates from the Compliance tab, then upload the modified templates on the Crystal tab.
To create your own reports using data from the FortiNAC database you must complete the following tasks:
- Create a User Name and Password for the FortiNAC MySQL database. See Configure a database password.
- Download and install the MySQL ODBC Connector. See Install and configure MySQL ODBC connector.
- Configure the ODBC connection. See Install and configure MySQL ODBC connector.
- Install Crystal Reports on your local host. Only required for users that will create or edit templates. Users running templates that have already been created elsewhere do not need to install Crystal Reports. You must use Crystal Reports 2008.
- Configure the connection between the database and your Crystal Reports installation. Only required for users running Crystal Reports. See Configure the database connection.
Instructions in this document pertaining to Crystal Reports are based on Crystal Reports 2008. |
You must have a copy of the full Crystal Reports software to create new templates or edit existing templates.The Crystal Reports engine is installed on the FortiNAC server.
Upload custom templates
There are no special requirements for uploading templates. Templates uploaded through the Crystal tab are stored in: /bsc/campusMgr/ui/ROOT/user
- Select Logs > Reports.
- Click on the Crystal tab.
- Click the Upload Report button.
- In the pop-up window, click Choose File.
- Browse to the template, select it and click Open.
- Click OK in the pop-up window.
- The report template displays in the Custom Crystal Reports drop-down list.
Run custom templates
There are no special requirements for running templates.
- Select Logs > Reports.
- Click on the Crystal tab.
- Select a report template from the Custom Crystal Reports drop-down list.
- Click Run.
- The report displays in a separate tab in your browser.