In How many ways we can generate custom reports in sugar crm?

[srini123]

Hi,can any one please say...In How many ways we can generate custom reports in sugar crm?


Thanks in advance,
srini

[malcolmh]

Hi,

Which version of Sugar are you using, CE or PRO?

With the PRO reporting tool you have unlimited reports, with CE out of the box no reporting capabilities

[Markku]

Hi,

In this thread http://www.sugarcrm.com/forums/showthread.php?t=40199

mcatling summarized different reporting options, quoting:

In the CE version there is no built in reporting. But you have a number of options.

Use the Zuckerreport module which uses the Jaspersoft reporting tools. This is integrated into Sugar and accesible through the Tab menu. You can build custom reports using the ireport report builder from Jaspersoft.

Another option could be to use native jaspersoft to talk to the database directly again using ireport for building detailled reports (more flexibility but you need to understand the database).

Option 3: similar to above but using the Pentaho BI toolkit to talk to the database directly.

Option 4: Use Excel and ODBC to talk to the database directly.

Option 5 Use Openoffice Calc and Database + sun report writer and ODBC to talk to the database directly. I use this option a lot.

Option 6: Use Microsoft Access and ODBC to talk to the database directly and use its reporting functions.

Option 7: if desperate create new list views using Sugarcrm studio and search (saved searches) and do print . Although you onlyget one screen at a time.

Option 8: Buy the Pro or Enterprise edition whic has quite good reporting built in. This is definately the easiest to implement and support going forward.

[srini123]

Hi...Markku ,


Thanks for your reply.


Rgds,
Srini