W-Systems joins SugarCRM! Read Blog
In January, W-Systems employees Amanda Anderson and Andy Hidalgo, hosted a Sugar User Group on building reports in SugarCRM. They covered the creation of reports, the different types of reports, and how to manage changes within them. The webcast ended with an open Q & A discussion with engineers Andy Hidalgo and Aaron Wine. Below are some of the questions and answers from the session.
Yes, as long as it’s a module you created in module builder or is a standard Sugar module.
Yes you can. You pick a module, and then all the modules associated with that original module will already be linked to it. Then you just pick what you want to set your criteria against and what you would like to display.
There is a way to narrow the field for each folder. This is done by unchecking the reportable box when editing a field in Studio. There is not a way to limit subfolders.
Yes, you can do add or joins, this can be found in the report details step. Once in this section, you will see an Optional Related Modules check box, there you can click the relation you would like.
You can pull from both sections, however you need be careful exactly who’s email address you are trying reach. By going through the Contacts section you are pulling a specific individual’s email, and by going through the accounts section you are pulling the Account’s email.
To schedule a report you must be logged in as that person. So if you need to schedule the report for someone else, you need to have their login access and be a user to receive the report via email.
As long as the individual is a user they can receive the email. However, there are specific third party tools or customizations that W-Systems can provide.
When creating the report, by default, it only pulls in the primary email address from the Account.
Yes you can, but it has to be a rows and columns report, not a summation or matrix report.
Out of the box, no you cannot. The problem is each activity is stored within its own module and we would need to write a union query. However, W-Systems can provide this solution.