Sage Intelligence Reporting always outputs the data for a report to the first sheet in a workbook. Subsequent worksheets in the workbook are available for you to create your report output formats. The Expression names for the columns in the
Sage Intelligence Tips & Tricks
How to use the NPER Function to calculate number of periods in the life of a loan or investment plan
The NPER Function allows you to calculate the number of periods that make up the life of a loan or investment. So, If you have a loan with a constant repayment plan and a constant interest rate, the NPER function
There are various types of Timeouts that can occur during data extraction phase of a report generation. The three most common that can affect the execution of a report and troubleshooting options are described below: Connection Timeout – This occurs
There are 2 options to test the Containers in the Sage Intelligence Connector Module, before using the Container to build a Report. Sample Data Check/Test Sample Data The Sample Data icon enables a sample of data to be viewed from
Using the Connector, data is made available through the addition of data Containers and relevant expressions. The source of the underlying data can be a SQL Query, Table, a View, a Stored Procedure or a user defined SQL Join or
A Data Connection holds the relevant connection information to connect to a supported ODBC or OLEDB compliant data source. This data connection object is then used for all connections to this data source. By adding a data connection the Connector
Email is the most popular distribution channel. By default, your Microsoft Outlook profile settings will be used by Sage Intelligence to send emailed reports automatically, however, if this is not preferable, or you do not have Microsoft Outlook installed, an Exchange
Distribution Settings Email is the most popular distribution channel. By default, your Microsoft Outlook profile settings will be used by Sage Intelligence to send emailed reports automatically, however, if this is not preferable, or you do not have Microsoft Outlook installed,
In order to distribute a report once the distribution instructions have been set up, you need to link the instructions to the report and select the worksheets which the instructions must apply to. To Select Distribution Instructions, do the following:
This is a list of the top 5 Sage Intelligence Tips & Tricks of 2012 based on number of views by you! This list is made up of the Sage Intelligence tips which you and our other readers found the
