We have come to the final part of this Sage Intelligence 3-part series! Let’s take a look at what we have been through so far. In Part 1, you learned how to get started in the cloud with Sage 50cloud Intelligence giving you instant access to online financial reports. In part 2, we showed you […]
- Solutions
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
- Resources
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.- Learning
- Support
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.Get Support Assistance
Can’t find the solution to the challenge you’re facing in the resource library? No problem! Our highly-trained support team are here to help you out.Knowledgebase
Did you know that you also have access to the same knowledgebase articles our colleagues use here at Sage Intelligence? Available 24/7, the Sage Intelligence Knowledgebase gives you access to articles written and updated by Sage support analysts.Report Writers
Having some trouble creating or customizing the exact report you need to suit your business’s requirements? Contact one of the expert report writers recommended by Sage Intelligence.- Sage City
- University
- About Us
- Contact Us
Home Archives for Sage Intelligence Tips
Part 3 of 3: Create and customize reports easily with the Financial Report Designer
You’ve reached the final part of this Sage Intelligence 3-part series. Let’s recap what we have been through so far. In Part 1, you learned how to get started with Sage Intelligence Reporting so that you can have accurate and timely financial statements available to understand and run your business effectively. Then, in Part 2, […]
Saving changes to an existing report layout in Sage Intelligence Reporting
Sage Intelligence Reporting allows you to create reports of your own, as well as customize your existing ones, all in the familiar environment of Microsoft® Excel®. This is based on the Excel template that gets attached to each report. Once it’s linked back, after any changes have been made, the formulas will update seamlessly with […]
Get your filters to stick in PivotTable reports
Have you ever tried to make use of filters in your PivotTable reports, only to find that they don’t stick when you save your template back to the report in the Report Manager? When your workbook is generated, maybe you’d prefer blank items to be hidden, or you would like it to default to the […]
Enable the recipients of your distributed reports to interact with PivotTables like you do
Have you ever distributed reports containing PivotTables and found that your recipients aren’t able to interact with them, only having a snapshot of the data? Wouldn’t it be great if they could have some of the same functionality you do, like the ability to filter, drill down, or add other fields that may be of […]
More efficient report running: Part 2 – Using system variables with scheduled reports
In this tip, we continue from where we left off with the previous tip, and will demonstrate how you can use system variables when scheduling reports to run automatically. This will reinforce how they are applied during the scheduling process. If you didn’t catch the previous tip, you can find it here. There are many […]
More efficient report running: Part 1 – System Variable date Parameters
Have you ever wondered how you can set up your reports to pull data from the same day you run them, without having to manually change the Parameter values each time? Sage Intelligence System Variables make this possible and allows for more efficient report running. This works especially well when scheduling reports to run. In […]
Get a handle on your Sales Flash Report and the AVERAGEIF Function
Would you like to keep track of your most important sales indicators in no time at all? If so, why not check out the free Sales Flash Report provided through the Sage Intelligence Report Utility. This report gives you a quick view of your Sales over a particular day or period and includes measures like […]
Learn how to preserve formulas in older versions of Sage Intelligence Reporting
In our previous two tips we focused on Distribution in Sage Intelligence Reporting. In the first tip we showed you how Intelligence Reporting gives you the option to send reports either with embedded formulas or without. When doing so, you also need to take into consideration whether your recipients have Intelligence Reporting installed or not. In the last […]
Scenarios to consider when distributing your Sage Intelligence reports
In our previous tip we mentioned three ways Sage Intelligence allows you to distribute reports and how to set up your instructions to send them with static values or embedded formulas. The functionality to send reports with embedded formulas was added in core version 7.5 of the software and the tip can be found here: […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.