Deploy reports
Standard reports for the KMDWorkZone product are not included in the standard installation of the KMDWorkZone product and are instead installed as part of the WorkZone installation.
WorkZone standard reports must be installed as a separate installation step as part of the Database Configuration installation step when installing WorkZone. During the installation of standard report templates, the Reports table is created.
If you have created your own report templates for customized reporting requirements in your organization, you can deploy these custom report templates automatically when you set up the Database Configuration during installation of a new version of WorkZone or when updating your existing version.
To do this, you must create a folder called Reports in the same folder where the KMD WorkZone PDF.exe is located. Place all custom report templates that you want deployed during an installation or update in the Reports folder.
When the Database Configuration option is run during the installation process, any reports placed in the Reports folder will be automatically deployed to the WorkZone Client by the installation process.
Custom report templates in the Reports folder will overwrite any standard report templates.
KMDWorkZone supports Microsoft Power BI reports and the WorkZone installation process includes standard WorkZone Power BI (.PBIX) reports. The six standard BI reports are found in the Power BI sub-menu in the Reports menu of the WorkZone Client.
In order to utilize the Power BI reports, the Microsoft Power BI client must be installed on the local machine.
To deploy report templates only, specify these parameters:
| Parameter | Required? | Default value | Meaning |
|---|---|---|---|
|
-dbconfig |
Yes |
|
Deploying templates mode. |
|
-db |
No |
The first defined database (DSN) on the target server. |
Specify database name. |
|
-dbuser |
No |
SJSYSADM |
Specify user name. |
|
-dbpassword |
Yes |
|
Specify password. |
| -odata |
No |
The first defined OData URL on the target server. |
URL to OData application. |
|
-CrawlerClientId |
No |
WZPDF.CRAWLER |
These parameters can be defined as any strings allowed in the WorkZone Content Server OAuth2.
|
|
-CrawlerClientSecret |
Yes |
|
Example:
"KMD WorkZone PDF.exe" -DbConfig -Db:db01 -dbuser:[user] -dbpassword:[password] -OData:"https://db01.lmdom.local/OData"
