11  I just installed AlineaSol Reports Community Edition in my SuiteCRM site and the module dropdown does not show any custom modules. Is the Community Edition not set to show custom modules?
Yes, AlineaSol Reports Community does show Custom Modules, if they are correct. Here are some actions for you:
If you do a "Quick Repair", the custom modules should appear.
If the Quick Repair didn´t solve your issue, then you should check into the bean file for the custom module that is not appearing (ex: yourCRMdir/modules/YourCustomModule/YourCustomModule.php) that you are implementing the function 'bean_implements' and that it returns 'true' for the 'ACL' interface:
case 'ACL':return true;
If it doesn´t, the module will not be shown by Reports, as it is not able to identify roles permissions at your Sugar instance.
12  How to manage null values within filter dropdown user inputs?
For the field that will output null results, add a SQL function by clicking on the SQL button at the field, and in the advanced editor enter a Flow Control function as in this example:
For a more descriptive text for this NULL value, you can add a 'Enum' Format Type and click on the gear wheel icon. There, click on Add New Value, enter NULL on Internal Value and the derired text for null values on Display Value.
Now, for the filter:
Add a filter to the field by clicking on the + button, set Behaviour to User Input and Operator to One Of. On Behaviour click on the gear and as before, click on Add New Value, enter NULL on Internal Value and the derired text for null values on Display Value.
Now, if you run the Report, you should see the Null values and Dropdown Null values displayed as you specified.
13  I have installed AlineaSol Reports Community and I get a PHP Fatal error: 'Call to a member function getRelationshipObject() on null'. What to do?
To solve this issue, add this line to your config_override.php file, in your CRM´s base directory:
$sugar_config['asolReportsRelationshipsTableUsage'] = true;
This was introduced on Reports 5.5.2, wich was published on December 14th 2016. If you don´t have this version already, you can update through your "My Downloads" section.
14  How can I know what is the latest version of a module?
Also, under Documentation you will find the Module Compatibility Matrix, wich shows you the module versions to interact with each other thus enhancing themeselves. This table also shows you the minimum Common Base version needed for the latest version of every module.
Remember too, that from your My Downloadable Products section you will be always downloading the latest version.
15  I get the message "You do not have access to this area. Contact your site administrator to obtain access.": What to do?
You have to perform a Repair of your CRM´s roles.
Go to your CRM administration panel, go to Repair (under System) and click on Repair Roles.
16  After install, Reports shows 40X errors at the Reports´s validation page and I cannot create or list existing Reports. What can I do?
This can be caused by incorrect filesystem permissions, making our installer unable to create new files and causing the numerical errors as 404, 403 and any other kind of Apache´s 4XY errors that you see at the Reports´s validation page.
You can solve this by configuring default file permissions and ownership at the config.php file and then reinstalling Reports.
Check this link for more information about setting up permissions via the config.php file.
17  After Common Base installation, AlineaSol configuration page is showing php code and not the option it should. I'm having the same Issue with other modules. What can I do?
This issue is related with PHP´s short tags and PHP version.
To fix this, set the following in your php.ini:
This is default for versions over PHP 5.4.0 .
For more information, check here.
18  Can I improve Reports´s PDF Export performance?
By default, Reports uses TCPDF to send the report output to PDF. As an alternative to this engine, we support PhantomJS, wich performs 300% faster, so if you experience timeouts when exporting a large Report to PDF, or any other issue, you can consider using PhantomJS.
To start using it in Reports, perform the following steps:
- Download PhantomJS from http://phantomjs.org/download.html
- Make sure that you pick the correct binary for your OS and architecture (32 or 64 bit).
- Place the PhantomJS binary at the CRM´s root directory.
+ For Linux:
-> Make sure the binary file has executable permissions (chmod +x phantomjs)
- Edit your config_override.php file:
+ For Windows:
-> $sugar_config['asolReportsPhantomJsFilePath'] = "phantomjs.exe";
+ For Linux:
-> $sugar_config['asolReportsPhantomJsFilePath'] = "./phantomjs";
You can place the binary at another path within the CRM´s root directory, if you preffer. You´ll have to make changes in the config_override.php file to reflect the new relative (to CRM root directory) path.
19  I migrated from SugarCRM to SuiteCRM and the AlineaSol modules do not work correctly. What can I do?
Migrations to SuiteCRM from SugarCRM sometimes causes issues with our modules.
To fix this issues, follow this steps.
- Uninstall AlineaSol modules that you have installed. Select "Do Not remove Tables"
- Uninstall AlineaSol Common Base. Select "Do Not Remove Tables"
- Install again AlineaSol Common Base, and after that, the rest of AlineaSol Modules that you had.
20  On the Enterprise/Community feature comparison the Enterprise edition gives you access to the Report library. What exactly is the report library?
Reports Library is a set of example Reports contained in the folder "yourCRM/modules/asol_Reports/include_premium/examples/" that you can import into your Reports installation.