KReporter Support for Microsoft SQL Server and PostgreSQL

Provident are delighted to announce Deployment of KReporter into one of our Large Enterprise Finiancial Services Clients.   As part of our Port to Microsoft SQL Server (including Slave Database reporting), we have also added support for PostgreSQL. Following up on KReporter support for Oracle database in 2013, this brings the supported list of databases to: [list type=”circle”]Microsoft SQL Server (2005, 2008, 2008 R2 and 2012)[/list] [list type=”circle”]Oracle[/list] [list type=”circle”]PostgreSQL[/list] [list type=”circle”]MySQL[/list] Provident also support deployments in mixed environments, e.g: MSSQL Backend Database, and Linux Webserver (using FreeTDS Driver), all these environments are supported in all editions (Ultimate, Enterprise, Professional …

Year on Year – Period comparison reporting with SugarCRM & KReporter

The Problem – Comparing results over given Period If you are running your CRM System for a longer time it also becomes a great source of information. A typical requirement is comparing periods (e.g. last year compared to the current year) or the first quarter to the second quarter, etc. If you then also want to apply formulas to e.g. show the difference the best way to accomplish this is using union Reports. For more details & pricing on deploying KReporter, contact Provident: sales@providentcrm.com

Generating SLA Reports using SugarCRM’s Audit Table

We regularly have requests from customers to generate SLA reports in SugarCRM. To do this we use the powerful KReporter – this allows us to report off the Audit Table (which stores information on field changes). Below is an example report we have build which shows time since last status change on a call record: This looks great, but wouldn’t it be even nicer to see this information contextual to an actual record -e.g: as a subpanel. Below is an example of a Contact record, we have enabled the calls report above and filtered it by parent id (the Contact), …

Say Goodbye to Excel – Pivot Tables are now available in SugarCRM with KReporter

KReporter Release 3.0.4 is upcoming and will also bring a set of new features for the Pivot Grid. A very nice form of report if you have highly dynamic data. Below is a sample screenshot of how flexible this plugin is and demonstrates the potential of the Pivot table reporting: Watch a Screencast on Youtube on the new capabilities including sums and totals as well as a fully integarted Excel Export that will produce excel exports with the Pivot data now as well. For more information on Pivot Table Reporting you can read this PDF: Reporting with Pivot Tables in …