SugarPrint

What is SugarPrint?

SugarPrint is an AddOn for SugarCRM CE that enables printing to PDF / XLS export of any:

• ListView
• Detailview
• CalendarView

SugarPrint is also a simple and powerful reporting tool:

1. Filter data with the search panel of SugarCRM
2. Click on SugarPrint
3. Indicate the calculations (sums medium counts) and clusters
4. Create the report

A few clicks without moving from List!

SugarPrint is unique

All other reporting tools require users to activate the form of reports, select the report, change the parameters to run the report

SugarPrint harnesses the power of the search for SugarCRM: simple or advanced search are an important tool for users. Why not make it possible to extract results in an elegant PDF or an Excel file handy?

Why SugarPrint?

Our regular users of SugarCRM frequently ask us to print or export the information from various modules. They filters records on any modules and would then have the results printed in PDF or exported to Excel format. They want to make selections, groupings. calculations on that results It needs a reporting module? Not always. Quite often calculations are very simple and the data are in front of their eyes and do not want to repeat the same questions in a reporting module: they have no time to lose! We made SugarPrint to respond to these users. To your users!

Features

• Print PDF (1 click for printing all pages) of any SugarCRM ListView
• Print PDF of detail and subpanels of any SugarCRM Detailview
• Print Calendars PDF of SugarCRM
• Crosstab reports
• Create fles DHTML Grids with subtotals and nested group by
• Ability to add extra modules fields are not present in ListView
• Sorting columns in the Report PDF
• Group by with multiple subtotals and grand totals
• Reports with calculations: sum, average, count
• Export to Excel (not csv) of the records of the ListView
• Export to Excel (not csv) of Detailview: details + subpanels (one for each sheet)
• Security in the printing of records: print only records that the user can view
• Compatible with SugarCRM ACLs and Security Suite
• Pie charts, bar charts, histograms from each ListView
• Save reports as public report or private report

Installation

The installation of SugarPrint is fast and uses the SugarCRM Module Loader

To install Metro Theme follow the Following steps:

• Download SugarPrint package
• Go to the Administration module of your SugarCRM. With Module Loader uploads and install SugarPrint

SugarPrint icon will now Appear in any:

• Listview
• DetaiView
• CalendarView

Remember that if a user has disabled the Export records to a module SugarPrint is not enabled for that user in that module

Post installation

SugarCRM Ajax calls

Ajax features SugarCRM: SugarCRM CE enables a feature to change content via AJAX call. AJAX is used to improve the performance of SugarCRM.

In fact, disabling AJAX calls, there is no visible deterioration of the performance of your CRM. For a better use of SugarPrint is recommended to disable AJAX calls to all modules.

To disable AJAX follow the following steps:

1. Login as Administrator in SugarCRM
2. Go to Administration module
3. Click on System Settings
4. Click on Configure AJAX User Interface
5. Drag all modules in Disabled Modules
6. Save

No Core files changed and only one logic hook

No SugarCRM core files are changed from SugarPrint

SugarPrint installs a new logic hook for all modules:

• custom/modules/SugarPrint_logic_hook.php and
• custom/modules/logic_hooks.php

The hook is an “after_ui_footer” hook to add a common javascript file (SugarPrintt.js) to all pages (of course not if page is called with to_pdf=1)

Report types

In the current version of SugarPrint provides the following types of reports:

• Report: columnar report with the possibility of grouping totals and subtotals
• CrossTab Report: crosstab with one SugarCRM field for columns and one for rows plus a summary fields to calculate
• Report summary: there are two columns, one of which includes the values of the other sums which performs
• Pie chart: pie chart drawn by two columns selected by the user
• Histogram: Histogram drawn from two columns selected by the user

Create reports form Listview

SugarPrint SugarCRM works on any Listview

SugarPrint makes available in each Listview printing and reporting of records

It only works on Listview SugarCRM, each custom module that uses the normal Listview SugarCRM.

It does not work if the Listview has been replaced with a special Listview with different structure from the standard: a custom view with custom code.

Quickly print records with a click

Many times after performing a search on a module users need only to print in PDF format and then maybe on paper. Obviously they want to print all pages with a single click

With SugarPrint can activate the Print icon to SugarPrint in Listview and with a click on PDF Report obtain a stylish and professional PDF printable file.

How to create a report

In addition to printing the records in a few seconds you can get a report in PDF format that makes calculations on the rows and columns of the Listview

To create a report with SugarPrint:

• Click on SugarPrint icon
• Modify if necessary the report name
• Go to the Design tab
• If you desire, Drag the rows to get the order of the columns in the report: from top to bottom from left to right corresponds to the report
• Select the flags on columns of interest and columns to group
• Indicate which of the other columns to perform calculations
• In the Format tab, specify the format of the PDF file
• PDF report to run the report

Save a report

After you set up a report and before creating the PDF, you can go to Save tab, and click on Save report button. Please select the flag if the report will be "private": only for me option.

NOTE: Normally report is used by all users but the data probally will be different for different users: SugarPrint guarantees maximum and full compliance with the rules and roles of SugarCRM and Security Suite.

The name of the saved report is taken from the title of the report. If the name already exists creates two reports with the same name.

To manage the list of saved reports and possibly to delete or rename reports use the module SugarPrint.

NOTE: it is not possible to add reports from SugarPrint module. This module is only to manage Reports. But the users that want to use SugarPrint need to access to SugarPrint module

Extra fields: how to add columns to the report

SugarPrint allows you to add the columns in the form of SugarCRM that do not appear in Listview in use.

To add columns:

• Click on Report icon on ListView
• Goto Design tab
• Use the button Get more fields
• The additional fields are displayed with a white background, those in Lsitview with gray background.
• You can perform the same processing on the additional fields that apply to the fields in the Lsitview only difference is that SugarPrint will require additional processing and reporting will need extra time to be prepared and submitted in PDF format.
• If there are many records to be printed (eg, a few hundred) you might have expected significant.

Run a saved report

To run an existing report you have to use dropdown tab of the Report:

• Click on Report icon on ListView
• Use the dropdown

Selecting a report loads all parameters of the selected report. At this point there are two possible options:

• the user use the report with actual data in the listView: click on PDF Report
• the user wants to load data from filters saved with the report before: use the button “Load data from report parameters”

With the button " Load data from report parameters the Listview is reloaded with the new filters

PDF file format

SugarPrint allows you to specify the format of the PDF for each Report: a report with many columns requires a horizontal format with a size large. For a Report in which table columns are too narrow you have to expand the size of PDF file format. By choosing a custom format, the user can specify the width and height of the page. The measurements are in points. Information about the format are saved when the report is saved, and it can change from one report to another.

Sorting the records in reports

SugarPrint does not make any sort on records. The report follow the same sort of records present in Listview Therefore before using the report button SugarPrint verify the sorting of lists and change it with click on the column names.

Export to Excel

SugarPrint allows you to export to Excel any ListView and DetailView

Export from Listview

Allows you to create and view an Excel file all the data of a Listview organized a single workbook. Follow the following steps:

1. Activate Report icon on the ListView
2. Select Export to Excel from the Report type in the dropdown
3. Possibly change the parameters tab Design
4. Click on Export to Excel

Export from Detailview

Activating the Report icon in Detailview, SugarPrint creates an Excel file that contains a worksheet for the head and a sheet for each subpanel. In subpanels are displayed all rows (although on most pages) related to the record of the DetailView.

TCPDF Library

To create the report in PDF format SugarPrint uses library TCPDF (www.tcpdf.org). In the directory custom/modules/SugarPrint/views/tcpdf/fonts there are fonts installed with the installation of SugarPrint. To use a new font follow the instructions on the site www.tcpdf.org and indicate the name of the new font in the admin section of SugarPrint. See below. The standard font used by SugarPrint reports in PDF is Helvetica.

Administration section

In administration section of SugarPrint you can modify font name, font size or css rules used to create PDF report.

Before you change these parameters, it is recommended to make a backup copy of the data initially present, the changes may create a malfunction in the creation of the PDF.