Visit Sage CRM Main Website
About Sage CRM
Browse By Tags
Key Attribute Profiling
Building Cross Database Views for Reporting
You may need to reference data held outside of Sage CRM and within another application's database for a variety of business requirements including Reporting Graphing Reports within CRM are based on views and so if the SQL within a view can provide a way of accessing data...
1 Jul 2009
Reports and Graphs using Key Attribute Data
Reports and Report Charts can only be built from views. So If we want to create a Report Chart that uses Key Attribute Data then we must first create the view. The structure of the tables that holds the key attribute data is complex and trying to work this out on our own to build a view would be a deeply...
8 Sep 2007
Restricting Access to a Report to Specific Times of Day
This article has been prompted by a question I was asked at a recent Developer training course in Johannesburg, South Africa. During the training course we discussed how when a user runs a large report it can place a load on the customer's server which in turn can create problems for other users...
29 Oct 2012
Tips for Building Views: A round up of articles on views.
The following is a survey of all the different articles that have discussed creating and editing views within Sage CRM. Understanding SQL views is essential as they under pin just about every feature within Sage CRM and completely determine what can or can't be done in Reports, Marketing Groups,...
1 Jul 2009
© The Sage Group plc 2019
All Rights Reserved