You can also generate report in XML or PDF and send it over email.

We will guide you step by step through the whole installation and configuration process.

Files in your WHMCS directory should look like this.

File is located at 'modules/addons/reportgenerator/license_RENAME.php' . Rename it from 'license_RENAME.php' to 'license.php' .

Enter your licence key between quotation marks as presented on the following screen. You can find your license key at your client area → 'My Products' .

'reports_xml' file is located at 'your_whmcs/modules/addons/reportgenerator/' .

Log in to your WHMCS admin area. Go to 'Setup' → 'Addon Modules' . Afterwards find 'Report Generator' and press 'Activate' button.

To do so click on 'Configure' button, tick 'Full Administrator' and press 'Save Changes' .

You can find them at your module 'Addons' → 'Report Generator' → 'Cron Jobs' .

You can access the module at 'Addons' → 'Report Generator' .

Module has also additional useful features like predefined reports, import/export of reports, generating reports in PDF and ability to send it to admins.

Here you can manage your reports by viewing (1), editing (2), generating report in PDF (3), exporting to XML file (4) and removing (5).

More information about creating new reports will be presented in the next section.

You can display report in a simple or widget format. To switch between them press one of the buttons marked on the screen below.

At every step of creating report you can add new sections.
Below we will show you how to set up single section.
Start from entering report name and description.

Afterwards, tick all records from tables you want to display.
If you decide to display aditional column, you can define them in 'Additional Columns' field.

<?php 
// your custom code here
return $result; 
?> 

The $result variable is passed by refference, and contains just iterated element of the result array.
So you can create a new columns in your table or modyfing existing ones through modyfing this variable.
You can access it as normal array, where the key is the column name and value is the current row value.
Important: Use this field with caution, because every mistake made here can result with error in your production environment.

For example, to join table 'tblclients' with 'tblactivitylog' you should join it using 'tblclients - id' and 'tblactivitylog- clientid' .
If you have more than 2 tables in your report section, it is adviced to create more join relations.

You can use predefined conditions. Select record to apply filter on, afterwards select 'Operation Type' and type value into 'Default Value' field.

To set 'Group By' , select record to order by displayed values, afterwards select direction of grouping by.
You can also use custom group by command through pressing 'Add your own group by query' and typing command in textbox which will apear.

You can also use custom order by command through pressing 'Add your own order by query' and entering command in textbox which will apear.

To do it, simply enter time period (in days) to create report from.

You can create two type of charts which are pie chart and area chart.

Open lang file located at 'your_whmcs/modules/addons/mg_resellers/lang' , in this example it is 'english.php' .
Afterwards, enter:

$_LANG['record_name'] = 'displayed_record_name';

Where record_name is record name you want to display differently and displayed_record_name is name under which this record will be visible.
For example, to change record 'groupid' to 'Group ID' use this code:

$_LANG['groupid'] = 'Group ID';

Note 1: It will set up custom name for all records with that name.
Note 2: Custom table records support multi-language.

$_LANG['table_name'] = 'displayed_table_name';

Simply select admin or admins to which email with report should be sent.
Afterwards choose which of your reports should be sent.

You can specify report content setting them up, for example, on the screen below we have choosen 'admin' staff member.
This way report sent will refer to 'admin' staff member.
Finish by selecting time period for email sending and press 'Add Relation' .

Afterwards, press 'Upload' button and your report will be uploaded to the module.

To do so, simply press 'Install on Page' button as presented on the following screen.