News & Updates
Training & Certification
to create and rate content, and to follow, bookmark, and share content with other members.
Does the Excel Plug-In work with Advanced Reports from Sugar Enterprise?
Question asked by
on Oct 13, 2014
on Dec 23, 2014 by David Sánchez
Show 0 Likes
I need some data from the _audit table in order to perform some excel calculations. Is it possible to use Advanced Reports along with the Excel Plug-In in order to capture this information?
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Dec 23, 2014 7:20 AM
I have tested on my own (Sugar 6.7 Enterprise with latest Excel 2010 plugin). It's not possible to access _audit tables because all data shown in Excel plugin are:
"query wizard": only core modules (Accounts, ...) and not tables in database
"reports": all the published reports using "Reports" feature and not "Advanced reports"
Of course, a workaround is available: create a custom module in Builder and sync all data from _audit tables (triggers, logic hooks, scheduler). Then you will access to this data by Reports and Excel plugin.
Project Manager | REDK
Show 0 Likes
Retrieving data ...
Using Composer with Sugar PHP development
New Sugar Integrate space in Developer community
The Basics of Creating and Mapping a Common Resource
Adding Custom Color Variables to the Sugar Theme
How to access dashlet configuration variables from the server?