Sage 50 Accounts Report Designer training course
Sage 50 Accounts Report Designer is a two-day course. Our price is £250.00 (Sage's RRP is £535.00).
» Overview: Use Sage 50 Accounts Report Designer to fully customise your reports and layouts.
» What do I learn?
Become an expert at amending and creating reports/layouts, adding totals, filters and also ranges for more specific analysis.
» By the end of this course you will:
- Know how to create new reports using the report wizard, amend fixed reports, select variables, sort information and amend the page layout
- Be able to insert calculations into a report and change the presentation of information
- Know how to improve presentation by adding sub-totals and grand totals
- Understand how to add filters to a report to select specific information
- Be able to split debits and credits and produce meaningful transaction totals
- Know how to add ranges to a report
- Be familiar with selection filters, advanced filters and advanced criteria
- Know how to create overdue account letters and sales promotions using specific criteria and expressions
- Know how to amend an existing invoice layout or create one from scratch
Create your own high-impact layouts that incorporate data from Sage 50 Accounts. This will ensure you can easily present vital information in ways that meet specific requirements. Also learn how to amend existing stationery layouts to fit in with your own business needs.
Who should attend? users of Sage 50 Accounts v2007(v13) and onwards (for those on Sage Line 50 v12 or below we suggest our onsite training).
Book now
| Course | Centre | Start date |
Duration | Total places | Available places | Book |
| Sage 50 Accounts Report Design | Manchester | 07/09/2010 | 2 days | 12 | 0 | |
| Sage 50 Accounts Report Design | Bristol | 16/09/2010 | 2 days | 10 | 5 | |
| Sage 50 Accounts Report Design | Newcastle | 22/09/2010 | 2 days | 12 | 3 | |
| Sage 50 Accounts Report Design | Birmingham | 23/09/2010 | 2 days | 12 | 2 | |
| Sage 50 Accounts Report Design | N.London | 27/09/2010 | 2 days | 12 | 3 | |
| Sage 50 Accounts Report Design | Glasgow | 28/09/2010 | 2 days | 12 | 6 | |
| Sage 50 Accounts Report Design | Leeds | 30/09/2010 | 2 days | 12 | 4 | |
| Sage 50 Accounts Report Design | N.London | 11/10/2010 | 2 days | 12 | 6 | |
| Sage 50 Accounts Report Design | Croydon | 26/10/2010 | 2 days | 12 | 10 | |
| Sage 50 Accounts Report Design | Bristol | 28/10/2010 | 2 days | 10 | 7 |
Sage 50 Accounts Report Designer is a two-day course. Our price is £250.00 (Sage's RRP is £535.00).
You can book your course in several ways:
- Online: Just click the "Book now" button (your payment will only be processed after we have booked your course with Sage).
- Phone: Just call 0845 009 3990 to pay by card or arrange BACS or cheque payments.
- Use the contact form: Click here and fill out the contact form.
Important notes about booking your Sage classroom training course
- When booking a course online, if the course is not for the paying cardholder, please enter the name it should be booked for in the notes section when paying.
- If a vegetarian meal is required instead of the standard meal provided, please enter this in the notes section as well.
- If a course is showing no availability it is still worth contacting us as there maybe cancellations or the possibility of switching the course to a bigger room.
- Also note that the number of available places given is updated regularly, but it is not live, so it's always best to ask us for the latest availability if the number of available places is running low.
- *for all courses except Instant Accounts, which is £215 and Payroll Year End, which is £190.
Detailed course content
Click to see the course content
Session 1 - Introduction To Report Design and Amending Existing Reports
- 5 Key Ideas Behind Report Design
- Amending Existing Reports
- Saving Reports
Session 2 - Creating a New Report - Manually
- Creating a New Report
- The Design Screen
- Assigning Styles
Session 3 - Creating a New Report - Using the Wizard
- Using the Design Wizard
- Multiple Sorts
Session 4 - Expressions and Snippets
- Wrapping Text
- Adding an Expression
- Saving Snippets
- Formatting Numeric Variables
Session 5 - Grouping and Totalling Data
- Adding Groups
- Adding Subtotals
- The 'Keep Together' Function
Session 6 - Grouping Data Using the Wizard
- Audit Header, Split and Usage Tables
- Adding Groups and Totals Using the Wizard
- Totalling an Expression
- Suppressing Duplicates
Session 7 - Using Report Filters
- Creating Filters
Session 8 - Editing Group Functions
- Character Breaks
- Producing a Trial Balance
- Filtering Zero Values
Session 9 - Adding Criteria
- Understanding Criteria
- Setting Criteria
- Printing Criteria on the Report
- Adding a New Report Header
- User Defined Criteria
Session 10 - Applying Multiple Sub-totals
- Shortening Large Filters
- Adding Totals for Sales and Purchase Invoices
- Dealing with Unwanted Sections
- Count Function
Session 11 - Conditional Properties
- Conditional Formatting
- Advanced Conditional Formatting
Session 12 - Joining Tables
- Understanding Tables
- Adding Tables
- Performing A Join
- Adding Data From The New Table
Session 13 - Layouts and Letters
- Customising Invoices
- Choosing the Correct Address Variables
- Statement Layouts
- Bar Code Labels
- Creating Letters
- Inserting Pictures
Session 14 - Secure Email & Batch Reporting
- E-Mailing Reports
- Secure PDF
- Batch Reporting
Session 15 - Introduction to ODBC
- What is ODBC?
- What does it do?
Other relevant links
- Sage 50 Accounts training menu
- Linking Sage 50 Accounts with Microsoft Office (1 day)
- Sage 50 Accounts essentials course(1 day)
- Sage 50 Accounts stage 2 (2 days)
