Reports 4 You

Reports 4 You Manual · Chapter 4

Quick Start – Reports 4 You for Vtiger CRM

In the following sections you can find short description of Report’s types and how to create your first simple Report for vtiger CRM using Reports 4 You and.

Note: The full description of the Reports 4 You menus, tabs and icons can be found in the later chapters.

4.1 Types of Reports

You are able to create 4 types of Reports like Standard User

Types of Reports (standard user) - Reports 4 You Vtiger 7
Types of Reports (standard user) – Reports 4 You Vtiger 7

and 5 types of Reports like Admin User.

Types of Reports (admin user) - Reports 4 You Vtiger 7
Types of Reports (admin user) – Reports 4 You Vtiger 7

4.1.1 Tabular Report

Tabular report is very simple type of report, with a columns heading row followed by table data information.

Tabular Report - Reports 4 You Vtiger 7
Tabular Report – Reports 4 You Vtiger 7
Tabular Report - Reports 4 You Vtiger 7
Tabular Report – Reports 4 You Vtiger 7

4.1.2 Summaries Report

Summaries report is intended to use when performing data calculations grouped by selected columns. Group data choosing rows values by one row or combination (rows-rows), (rows-rows-rows).

Summaries Report - Reports 4 You Vtiger 7
Summaries Report – Reports 4 You Vtiger 7

Examples:

  • Report grouped by one row (Invoice status). Summaries columns are COUNT Records, SUM Total, AVG Total, MIN Quantity, MAX Quantity. Filter is not set. Pie Chart (SUM Total).

    Summaries Report grouped by one row - Reports 4 You Vtiger 7
    Summaries Report grouped by one row – Reports 4 You Vtiger 7

  • Report grouped by two rows (Invoice status, Customer No.). Summaries columns are COUNT Records, SUM Total, AVG Total, MIN Quantity, MAX Quantity. Filter is not set. Horizontal Chart (SUM Total).

    Summaries Report grouped by two rows - Reports 4 You Vtiger 7
    Summaries Report grouped by two rows – Reports 4 You Vtiger 7

  • Report grouped by three rows (Invoice status, Contact Name, Invoice Date). Summaries columns are COUNT Records, SUM Total, AVG Total, MIN Quantity, MAX Quantity. Filter is not set. No Chart.

    Summaries Report grouped by three row - Reports 4 You Vtiger 7
    Summaries Report grouped by three row – Reports 4 You Vtiger 7

4.1.3 Summaries Report with Details

Summaries report with Details is intended to use when performing data calculations grouped by one selected column with displayed record details. You can define calculations for all report datas and define limited/unlimited count of displayed record details.

Summaries Report with Details - Reports 4 You Vtiger 7
Summaries Report with Details – Reports 4 You Vtiger 7

Example:

There is Report with details from Invoice module that is group by: Organization Name. Summaries Column is SUM Total. With Columns: Subject, Invoice No, Contact Name, Invoice Date, Sales Commission, Status, Total, Assigned To, Organization Name, Organization No.. Also Chart is included.

Summaries Report with Details - Reports 4 You Vtiger 7
Summaries Report with Details – Reports 4 You Vtiger 7

4.1.4 Matrix Report

Matrix report is a summaries report with one group column displayed in columns structure. For example COUNT, SUM, AVG, MIN, MAX columns summaries calculated and displayed by date intervals, status, or other column values.

Matrix Report - Reports 4 You Vtiger 7
Matrix Report – Reports 4 You Vtiger 7

Example:

Report is grouped by row: Status and column: Organization Name. With filter: Paid Amount is greater than 0.

Matrix Report - Reports 4 You Vtiger 7
Matrix Report – Reports 4 You Vtiger 7

4.1.5 Custom Report

Custom report have to be programmed by skilled user with programming experiences. Do not forget that custom SQL Report display Records based on defined SQL query. Keep in your mind to use user permissions queries and share with permitted users only! Take care to be really careful with custom report SQL definitions.

SQL query of Custom Report - Reports 4 You Vtiger 7
SQL query of Custom Report – Reports 4 You Vtiger 7

4.2 Create the simple Report

In the following part you can see how to create simple Report.

  1. Open Reports 4 You ListView

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  2. Click on button Add report button – Create the simple Report and select your Report type or choose Select type view

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  3. If you choose Select type viewyou can see types with short description. About Report types you can read more: Types of Reports.
    Choose Type of Report and click on Next button – Create the simple Report button.

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  4. Fill name and select primary module and also you can select Folder
    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

    You have 2 options to pass through Reports 4 You creation:

    • With Next grey button – Create the simple Report button you pass through all possible tabs
    • If you use Create the simple Report or Create the simple Report button, immediately when all required info are filled Report is generated (tabs that are not necessary are skipped)
  5. You can group, select Summaries field and limit and sort

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  6. Select fields to display in Report

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  7. You can edit Labels shown in Report

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  8. You can use filters

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  9. Define sharing

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  10. You can turn on scheduling

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  11. If you want to show Graphs you can set it in this tab

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

  12. In the last step you can create Widget on your Dashboard.

    Create simple Report - Reports 4 You Vtiger 7
    Create simple Report – Reports 4 You Vtiger 7

    Then please click on Save button – Create the simple Report or Create the simple Report

Need help with Reports 4 You?

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