• New

SQL Reports

$99.00

vTiger CRM has powerfull Reports Wizard but it does not allow user to get cross modules analytics with some calculation. For example get deal profit or debts by invoices. Such analytics reports can be easily make from phpmyadmin or another mysql redactors but if it is regular reports and not all of you users understand sql language.

Quantity

  • 14 days FREE vTiger support 14 days FREE vTiger support
  • Professional source code Professional source code
  • Full refund within 7 days Full refund within 7 days

It is for this reason we have improved standard module Reports of vTiger CRM to get possible create and save sql reports. This improvement understands MySQL language with all of it possible functions. Check it in a demo. 

Features

  1. All MySQL functions can be used for reports creating
  2. Report result can contains links to vTiger modules (for example to Account's profile) or anywhere you need
  3. Reports can have dynamic parameters for filtering results

Live Demo

http://demo.vordoom.net/sqlreports/index.php (open in new window) 

demo / sqldemo

Instruction

To view or create sql reports you should go to standard Reports module in vTiger CRM. Created reports will appears in list of reports but to create sql report you need create Details Report and in Primary Module select SQL Query.

For setting dynamic parameters in report you need to set ? in where condition - for example 'where invoicestats=?'. If you want to specify parameter name you should set it after column name like this /*Parameter Name*/ - for example 'where invoicestats /*Invoice Status*/=?'

For creating link to module's profile you should use concat() function - for example 'select concat('module=Invoice&view=Detail&record=',vi.invoiceid,'|&',vi.subject)'. These symbols are mandatory - '|&'. They split link and title in result.

just unzip extension in vtiger root directory

Contact us if you have questions and we will answer within 24 hours.


9999 Items