Section overview

This section provides a user with a possibility to generate a report with a focus on actual traffic over the specified period. The report allows customizing a display of routes limits, vendors, total records, etc.

Screenshot: LCR Lists query form

Creating an LCR Report

To create a new LCR report, go to the Statistics section and open the LCR ListsThen, you will need to fill out the search form with the next parameters: 

Information BlockField Description
Filters

On the Filters menu, select the required parameters for the report. To cancel any filter, click on the delete  icon next to the filter.

You can start a quick search by typing filters' names in the field at the top of a drop-down menu with filters.

Period

Specify an interval for the report and a timezone. Please note that the Period field is mandatory.

Group by

Select from the list of the following accessible options to group the data in reports:

  • Code
  • Code Name

This option is intended to simplify the grouping option, the system will automatically group data in specified columns.

(warning)   Attention

  • Please note, the Group by field is mandatory, it couldn't be empty to generate the report. Grouping by code is a default output.
  • When you select the grouping by a code name, please be aware that simulation marks will not be shown and an effective date, also the next rate, may not be accurate. This data is taken from one of the codes of the group.


ServiceSpecify a target service (calls, data, SMSs)

Additional Filters

There are the following accessible additional filters:

  • Clients: Owner, Client Tags
  • Events: Code/ Code Name
  • Extras: Routes Limit
Owner

Specify a target reseller

Client TagsIndicate client tags that will be used for the report
CodeEnter the code of a target destination
Code NameDefine the code name you would like to be displayed in a report
Routes Limit

Indicate the limit of routes that will be shown. To display all possible routes, leave this field empty.

Output



This form contains settings of the report output data.

Click the plus  icon next to Columns and select the required columns to add them to the Output information block. Also, you can cancel any chosen item.

Accessible columns in the report

There are the following columns to add to the report:

  • Code
  • Code Name
  • Total Volume
Other output settings
Type

Choose a format of the report from a drop-down list:  Web/CSV/Excel XLS/Excel XLSx.

The table view of the report is Plain by default.

Send to

You can send generated reports via email. For example, it is useful when it takes a lot of time to run the report. Also, it is possible to specify several emails.

(warning)   Attention

This feature is available only for CSV/Excel XLS/Excel XLSx formats of the report, it doesn't work with Web.


Currency

Specify a currency of the report. All values will be automatically converted to the specified currency in the report.

Code Deck

Select a code deck from a drop-down list. All code decks in the following report will be presented according to the specified code deck. All data will be unified by code names.

Warning

  1. Please be aware that if you do not specify the code deck, the system will use the code decks assigned to each pulled client or rate table.
  2. Code deck must contain code names and codes used for calls. Otherwise, the LCR report would not show results for missing codes and code names in the code deck.


Show Vendors checkbox

Specify whether you need vendor (terminator) names to be displayed in the report or not.

Show Total Calls checkbox

Check if you want total calls amount to be shown.

The LCR report has the following look:

Screenshot: LCR report

Each route, presented in a report, besides a total number of events and vendors (displayed when respective checkboxes are marked) has the following data specified (see screenshot above):

Also, you can create a template for reports and save specified parameters by clicking the Save Query button. Visit our Reports Templates article for detailed information.  

To query by template, click the Load Query button and the  icon .

Export generated report

You can export data to a CSV or XLSx file, which contains only currently displayed data, with no automatic request to update data while exporting. 

  1. To download a report in .csv, click on the Export to CSV button above the report.
  2. To download a .xlsx report file, click on the Export to XLSx  button above the report. 

(warning)   Attention

You can check an actual date interval by clicking the Info  icon. The displayed data could be different from the Interval specified above if there is no data for the period. 

Sharing a Report

Each time you get a report output, the system generates a unique link in the format of "/view?id=<uniq-string>". It allows sharing data between the users, even if they belong to different resellers (the feature works similarly to Share by Link in Google Drive). 

The link refers to the report data valid for a specific moment.

Example: When you send a link to a report, you ensure the recipient would see the same data as you do. If you change data in the system (for example, perform rerating), the previously copied link to the report will display data valid for the moment of generation (even though the actual data is now different).

You can also view the additional information about the generated report by hovering over the Info icon, which is located under the Output section:

Title

Description

Data PeriodStates the period set for a report
Generated byIndicates the Role of the user who generated a report and specifies a generation time