SQL Reports

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