Reports 4 You

Reports 4 You Manual · Chapter 6

Additional features – Reports 4 You for Vtiger CRM

6.1 Data export

Within the Reports extension, it is possible to export report data into the Excel or PDF formats or even Print it.

Report buttons have two options when clicked on:

Report Data

Exports the generated report data using the limit in the Report.

All(tabular reports)

Exports data according to report settings without limit (i.e. all records)

In the background

It exports data according to the report settings without limit by CronJob/Scheduler and sends it to the user who performed the action.

6.1.1 Support of PDF Maker

With Reports 4 You you are able to save your Reports as PDF files. To save Reports as PDF you need to have PDF Maker (Free version sufficient).

PDF Maker is extension tool designed by ITS4You for vTiger CRM.
For more info about PDF Maker please read: www.it-solutions4you.com/pdf-maker

PDF Export - Reports 4 You Vtiger 7
PDF Export – Reports 4 You Vtiger 7

6.1.2 Support of Excel Export

With Reports 4 You you can also save your Reports as Excel files. To save click on Excel button – Support of Excel Export button.

Excel Export - Reports 4 You Vtiger 7
Excel Export – Reports 4 You Vtiger 7

6.1.2.1 Currency column Disable/Enable

Some users prefer to not show this column in .xls exported files.

So here we will show you how to hide it:

  1. Go to vtigerfolder/modules/ITS4YouReports/configs/env/
  2. Create file with name XlsCurrencyColumn
    – should be like : modules/ITS4YouReports/configs/env/XlsCurrencyColumn
  3. Open the file and write in the value 0
    – write it just as 0 without anything else
    0 – currency column not shown
    1 – currency column shown

Now the Currency column will be not showm in the exported .xls files.

6.1.3 AVG Calculation without empty values

Users which want an Average calculations without empty values or zero values can use this quick tip from us.

  1. Go to vtigerfolder/modules/ITS4YouReports/configs/env/
  2. Create file with name UseEmptyRowsCount
    – should be like : modules/ITS4YouReports/configs/env/UseEmptyRowsCount
  3. Open the file and write in the value 0
    – write it just as 0 without anything else
    0 -counts the AVG value with COUNT rows where the value is not empty
    1 – counts the AVG value with COUNT rows where the value is empty

This configuration affects tabular report calculations.
Summaries report calculations are calculated by MySQL queries and user can simply filter off empty values there.

6.2 Support of Multi Company

With Reports 4 You you are able to generate your Reports across your Companies created by Multi Company extension.

Support of Multi Company - Reports 4 You Vtiger 7
Support of Multi Company – Reports 4 You Vtiger 7

Multi Company is extension tool designed by ITS4You for vTiger CRM which allows you in easier way to manage your companies within one vtiger CRM installation..
For more info about Multi Company please read: www.it-solutions4you.com/multicompany-extension-vtiger-crm
How to create Report based on Companies created by Multi Company you can find in our Tips & tricks

6.3 Key Metrics

The useful functionality of Reports 4 You is Key Metrics. Key Metrics allows you create Views on Dashboard(s) with information like Count of records based on Filter.
Extended version of Key Metrics included in Reports 4 You allows, after creating Tabular Report, use these Metrics ( SUM, AVG, Min, Max) on Dashboard(s).

Key Metrics - Reports 4 You Vtiger 7
Key Metrics – Reports 4 You Vtiger 7

6.3.1 How to create and add Key Metrics on Dashboard?

To create Key Metrics please provide following steps:

  1. Open Reports 4 You and click on How to create and add Key Metrics on Dashboard?

    Key Metrics - Reports 4 You Vtiger 7
    Key Metrics – Reports 4 You Vtiger 7

  2. Now, you can see list of your Key Metrics.
    • To edit or delete Widget click on How to create and add Key Metrics on Dashboard?
    • To add Key Metrics Row to show on Widget please click on Name of Widget
    • to add new Widget click on How to create and add Key Metrics on Dashboard?

    Key Metrics ListView - Reports 4 You Vtiger 7
    Key Metrics ListView – Reports 4 You Vtiger 7

  3. Click on How to create and add Key Metrics on Dashboard? insert Widget name and also you can insert Description and save it.

    Add Key Metrics - Reports 4 You Vtiger 7
    Add Key Metrics – Reports 4 You Vtiger 7

  4. Next step, is adding Key Metrics Row to calculate. Please click on Name of Your Widget

    Add Key Metrics Row - Reports 4 You Vtiger 7
    Add Key Metrics Row – Reports 4 You Vtiger 7

  5. Click on How to create and add Key Metrics on Dashboard?

    Add Key Metrics Row - Reports 4 You Vtiger 7
    Add Key Metrics Row – Reports 4 You Vtiger 7

  6. Insert
    • Label – Name
    • Report Name – you can choose filter or tabular Report
    • Column – if you choose only filter then you can select only Count of Records. If you choose tabular Report then you can select SUM, AVG, Min, Max from this Report

    and save it.

    Add Key Metrics Row - Reports 4 You Vtiger 7
    Add Key Metrics Row – Reports 4 You Vtiger 7

  7. Now, you can repeat step 6 like you need.

    Add Key Metrics Row - Reports 4 You Vtiger 7
    Add Key Metrics Row – Reports 4 You Vtiger 7

  8. To add Widget on Dashboard visit Home Dashboard, click on Add widget button – How to create and add Key Metrics on Dashboard? and find Name of Your Key Metrics.

    Add Key Metrics on Dashboard - Reports 4 You Vtiger 7
    Add Key Metrics on Dashboard – Reports 4 You Vtiger 7

note

6.4 Dashboard

How to add Widget on Dashboard?

  • Open your Dashboard, click on Add widget button – Dashboard button and find your Name of Report

    Add Widget on Dashboard - Reports 4 You Vtiger 7
    Add Widget on Dashboard – Reports 4 You Vtiger 7

  • Now, you can see your Widget on Dashboard.
    Add Widget on Dashboard - Reports 4 You Vtiger 7
    Add Widget on Dashboard – Reports 4 You Vtiger 7

Dashboard Notice for Vtiger 6.x users: Since the version of Reports 4.3 there was fixed a bug, where you were not able to increase the size of Reports 4 You Widgets in Vtiger 6. x, because it has got no option to resize it by default itself.

So if you are facing this issue, please update your Reports to the latest version via Installer.

6.5 Print

There is also option to print your Reports directly from Vtiger CRM as well as print end export Charts. Click on Print button

Print - Reports 4 You Vtiger 7
Print – Reports 4 You Vtiger 7

6.6 Bing Maps

With the version of reports ITS4YouReports_2_8_0 and higher. You are able to use Bing maps with our reports!

  • To start using Bing maps you need to create API Key. You can do that by going into Reports module, then click on the button Customize button – Bing Maps and select “API Key Settings”.
  • You must create key for Default usage or users can have their own key. How to get the Bing Map Key simply click on this URL text, see image below:
    Bing Maps
  • You will be redirected to the guide how to get a Bing Maps Key. Obtain key and choose if you want it for Default or User defined and paste the key in the window. Then “Save”.

After you successfully created and applied Bing Map Key, you can proceed to create or edit your reports. When you are creating report you have a step called “Maps” see image below:
Bing Maps

You will have to select mapping for the fields in this step, explanation of the fields is below:

  • Pin title – title for the pin which will be shown on the map, select any value from the pick list
  • Pin description – select field which will be used as description
  • Street – select street field, for example Billing Street
  • City – select city field, for example Billing City
  • State – select state field, for example Billing State
  • Zip – select postal code/zip field, for example Billing Postal Code
  • Country – select country field, for example Billing Country
  • Zoom – how much zoomed your map will be (optimal is 7)

When you are done with “Maps” step, proceed with generating reports. In the detail view of the report, please click on the “Display Map” button like it’s shown on the image below:
Bing Maps

The result is that our Invoices are shown on the map based on the Billing details used:
Bing Maps

Need help with Reports 4 You?

Our support team answers questions about installation, templates and settings.