There is one feature in Sugar Enterprise that, while very useful, is rarely used: Advanced Reports. This is likely due to the fact that some knowledge of SQL is required to create Advanced Reports in Sugar Enterprise. In this blog post, we'll cover an overview of what Advanced Reports are and the pros and cons of using Advanced Reporting in Sugar.
The data coming into Advanced Reports are based on SQL queries that you create which allows more control over the data that will be provided into the report, like the ability to use sub-queries.
There are several advantages of Advanced Reports, the main one being that you can bypass the limitations of Sugar’s default reporting tool. These abilities include:
This photo below is an example of Advanced Reporting where a user selected multiple formats for the data tables all within one report.
Another big advantage of Advanced Reports is being able to access the Sugar database when using Sugar On-Demand. A couple of useful reports you can create are to show deleted records or report on audits (changes to data over time).
There are a few drawbacks of advanced reports. These include:
If upon saving a query there are any errors, you may lose your progress, so we recommend keeping a copy of your in-progress queries before you save them in case you need to reference them.
If you find yourself wanting a more colorful report, a single place to find multiple sources of different information, or you can’t quite get where you want using regular Sugar reporting, then it might be a good time to look into advanced reports. If you’d like help with implementation or training around Advanced Reports, please reach out to W-System’s today.