The Knowledge Academy
Students will learn the basics of report creation including sorting, grouping, linking, basic formula creation, working with report experts and how to distribute reports to other users.
Identify the elements of the Crystal Reports interface
Create and modify a basic report
Use formulas to calculate and filter data
Build a parameterized report
Group report data
Enhance a report
Create a report using data from an Excel workbook
Who Should Attend
This course is designed for people who require an output from a database. In some cases, database programs have limited reporting tools, or such tools may not be accessible. Delegates may or may not have programming or SQL experience.
Delegates should be familiar with basic functions such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft Windows. They should also have an understanding of basic database concepts such as those outlined in any of our Microsoft Outlook Introduction courses.
Exploring the SAP Crystal Reports 2011 Interface
Explore Crystal Reports
Use Crystal Reports Help
Customise the Report Settings
Working with Reports
Create a Report
Modify a Report
Display Specific Report Data
Work with Report Sections
Using Formulas in Reports
Create a Formula
Edit a Formula
Filter Data Using a Formula
Work with Advanced Formulas and Functions
Handle Null Values
Building Parameterised Reports
Create a Parameter Field
Use a Range Parameter in a Report
Create a Prompt
Grouping Report Data
Group Report Data
Modify a Group Report
Group Using Parameters
Create a Parameterised Top N Report
Enhancing a Report
Format a Report
Insert Objects in a Report
Suppress Report Sections
Use Report Templates
Creating a Report from Excel Data
Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data
Create Mailing Labels
We are live!
Our new website has been launched.
You may notice that the appearance and layout of the website is different – The Knowledge Academy has a colourful new theme. We’ve incorporated a new font and have selected colours that complement each other, ensuring that you will be able to enjoy reading easier than before.
We’ve made our website more user-friendly by including our most common searches and courses at the top of the home page, allowing you to find them more easily and efficiently.
We are mobile! You can view our website via any device, whether it be a; laptop, desktop, tablet or smartphone. See for yourself; open up our website on your phone – its sleek design allows you to glide through any part of the website with ease. Everything is straight to the point and easy to navigate; with its new design, you can find and search for what you need in a matter of seconds. All of our courses are divided into different headings, a new feature allows you to hover your cursor over a sub-heading of your choice and view it before you’ve entered it. Any key, important information you should know, greets you on our homepage.
We have provided you with “widgets” containing facts about the courses.
- The amount of people who have already taken the course
- Whether the course has "The Knowledge Academy Best Price Guarantee"
- Logos of the Accreditors associated to the course
- How many are currently looking at the same course as you
- Any downloadable related content available
- View course availability if wanting to book with us
We have a dedicated section containing recent reviews made by our delegates. Reviewing our courses has been made easier. With our user-friendly website, you can scroll through them after clicking on “Trustpilot review(s)” to read their opinion. If you’re into your social networking, then our Facebook page is widget is located just on the right of the page, awaiting your “like”.
You’ll find additional information on our blog page. We like to keep you up-to-date with all the latest news. You will also find promotional material about our courses. You are able to share with your friends and family any of the blog posts you enjoy. We are on Facebook, Twitter, LinkedIn, Google+ and YouTube.
Welcome to the new website.