SugarCRM: custom reports

SugarCRM provides a tool to build custom reports. If you add some new yourown fields in some module and want to include them in reports you have to add their definitions in vardefs.php which is placed in the module directory. To allow to specify logic operation in the report files you need to specify data type for added fields:

...
'my_new_field' => array(
'name' => 'my_new_field', # name a field in the table
'vname' => 'LBL_MY_NEW_FIELD', # field HTML caption
'type' => 'varchar', # field type,
'len' => '20', #field length
),
...