This documentation relates to an earlier version of JeraSoft VCS.
View User Guide 3.20 or visit our current documentation home page.
Skip to end of metadata
Go to start of metadata
On this page

LCR List Query Form

This tool allows you to generate target lists of actual traffic for specified period. 


Screenshot: LCR Lists section query form

To create LCR report

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

SectionField Description

On the Filters menu, select convenient parameters for the report. To cancel any filter, click the delete sign next to the filter.

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


Specify an interval for the report and time zone.

Group By

Select a grouping option, here you can choose respective values to sort the data. There are following accessible options to group the data in reports:

  • Code
  • Code Name

Please note, the "Group By" field is mandatory, it couldn't be empty in order to generate the report. To group by code is default output.

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

When you select the grouping by code name, please be aware that simulation marks will not be shown and effective date, also the next rate, may not be accurate. This data is taken from one of codes of the group.

Additional Filters

There are following accessible additional filters:

  • By clients: Owner
  • By calls: Code/ Code Name
  • Extras: Tags/ Routes Limit
Origination Settings of Clients

Enter an owner/reseller, whose information should be displayed

Settings of Calls
CodeEnter the code of desired destination here
Code Name Codes NameEnter the code name you would like to display
Extra settings
TagsIndicate tags that will be used for the report
Routes Limit

Choose the filter "Routes Limits" and indicate the number of route limit that will be shown. To display all possible routes leave this field empty.


This form contains settings of the output data of the report.

Click plus sign  near the "Columnsto select respective columns to output a report data. Also, you can cancel any chosen item.

Accessible columns in the report

There are following columns to add to the report:

  • Code
  • Code Name
  • Total Time

Screenshot: LCR Lists section

Other output settings

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 e-mail. For example, it is useful when it takes a lot of time to run the report. Also, it is possible to specify several e-mails.

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

Specify a currency for a report. And all values will be automatically converted in the report to the specified currency.

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.

  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 should 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 check box

Specify whether you need vendor/terminator names to be displayed in the report or not, tick the check box.

Show Total Calls check box

Tick this check box if you want that total calls amount will be shown.

To create a new template

Also, you can create a template and save specified parameters by clicking "Save Query" button.  A pop-up window with settings will appear and you need to fill out the following form:

Screenshot: New Query Template form

LCR ListsHere you can specify parameters for the template that will be used while running reports.
TitleSpecify a name of the template.
ResellerIndicate a Reseller for the report template.

This tool allows to automatically generate the report at the appropriate time and send the results to the list of e-mails.

Please note, that this tool is not available for Web output type, only for CSV/Excel XLS/Excel XLSx.

RecipientsSpecify recipients, you can indicate your own e-mail or other users of the system, or even 3rd parties
Run TimeMention an appropriate time to automatically generate a report, it could be several times, for example: "10:00, 12:00, 18:00"
Days of WeekMention days of the week to automatically generate a report. For example, you can run a report only on Monday or each day of the week.
Report Query

Here you need to check filters and the output type. These values will be pre-selected by default according to the formed rate analysis query.

To load already existed templates while generating a report, click "Load Query" button in the query form.

Please note, the code deck should be assigned in the Rate Tables of the Terminator settings in order to generate the LCR report.

Export generated report

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

To download a report in .csv, click the "Export to CSV" button on the toolbar.

To download a .xlsx fileclick the "Export to XLSx" button on the toolbar. 

Please note, that you can check an actual date interval of the report by clicking the icon  and it could be different from the Interval specified above if there is no date for the period.

  • No labels