Is there a way to limit the numbers of results from the reports when using sort by in sugar pro ?
Check config.php File. Default values are:
'special_query_limit' => 50000,
0 => 'Reports',
1 => 'Export',
2 => 'Import',
3 => 'Administration',
4 => 'Sync',
'default_limit' => 1000,
I tried this , did a QR&R but couldn't get it to work , strangely reports still return all records? And it's a global settings I think ? Was looking for something along the lines of Advanced Reports of the Ultimate version ? I'm on the Professional version though.
Something similar to what it would be like to have a limit for the query ( imagined in the screenshot ) ?
As far as I know, AlineaSol Reports has query limit. You should test it, this may solve your problems with reports.
The module is downloadable here: AlineaSol
Another option would be Kreporter from KReporter - the reporting Solution for SugarCRM
Thank , will give try it.
KReporter especially looks really nice.
For the moment generating some sort of "report" in a custom dashlet since it proved easier to customize.
Retrieving data ...