Products

Sage Accounts

• Sage 50 Accounts
• Sage Instant Accounts
• Sage CIS

Sage Payroll

• Sage Instant Payroll
• Sage Payroll
• Payroll Professional
• Sage P11D

Financial forecasting

• Sage Winforecast Professional
• Sage 50 Forecasting
• Sage Job Costing

CRM Software

• Sage ACT! Pro
• Sage ACT! Premium

Sage Training

• UK Sage Training Centres
• Customised Sage Courses
• Online Course booking
• Sage Course Information

Sage Support

• Sage Cover
• Partner Support

Sage Stationery

Sage Upgrades

HR Software and Advice

Sage 50 Accounts - Report designer

Become an expert at amending and creating reports/layouts, adding totals, filters and also ranges for more specific analysis.

To see detailed course content Click here

This is a 2 day course and costs £350 + VAT. Sage RRP £535.

See classroom course terms and conditions and FAQs.

Sage 50 Accounts Report Design	Glasgow	23/05/2012	2 days	12	3
Sage 50 Accounts Report Design	Bristol	07/06/2012	2 days	10	6
Sage 50 Accounts Report Design	Newcastle	11/06/2012	2 days	12	12
Sage 50 Accounts Report Design	N.London	14/06/2012	2 days	12	8
Sage 50 Accounts Report Design	Birmingham	18/06/2012	2 days	12	8
Sage 50 Accounts Report Design	Manchester	21/06/2012	2 days	12	4
Sage 50 Accounts Report Design	Reading	21/06/2012	2 days	12	7
Sage 50 Accounts Report Design	Croydon	25/06/2012	2 days	12	8
Sage 50 Accounts Report Design	N.London	12/07/2012	2 days	12	10
Sage 50 Accounts Report Design	Croydon	16/07/2012	2 days	10	10
Sage 50 Accounts Report Design	Leeds	19/07/2012	2 days	12	10
Sage 50 Accounts Report Design	Manchester	26/07/2012	2 days	12	11
Sage 50 Accounts Report Design	Bristol	30/07/2012	2 days	10	10

• 
  
  Detailed course information
  
  
  
  Sage 50 Accounts Report Designer course session 1 – Introduction To Report Design and Amending Existing Reports
  

  
  

  • Amending Existing Reports
  
  
  • Panes
  
  
  • Locating and adding variables
  
  
  • Using Active Complete
  
  
  • Saving Reports

  
  Sage 50 Accounts Report Designer course session 2 – Creating a New Report – Manually
  

  • The Design Screen
  
  
  • Resizing sections
  
  
  • Formatting and assigning styles
  
  
  • Editing in preview mode

  
  Sage 50 Accounts Report Designer course session 3 – Creating a New Report – Using the Wizard
  

  
  

  • Using the Design Wizard
  
  
  • Multiple Sorts

  
  Sage 50 Accounts Report Designer course session 4 – Expressions and Snippets
  

  
  

  • Wrapping Text and auto grow
  
  
  • Adding an Expression
  
  
  • Creating Snippets
  
  
  • Formatting Numeric Variables

  
  Sage 50 Accounts Report Designer course session 5 – Grouping and Totalling Data
  

  
  

  • Adding Groups
  
  
  • Adding Subtotals
  
  
  • The ‘Keep Together’ Function
  
  

  
  Sage 50 Accounts Report Designer course 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

  
  Sage 50 Accounts Report Designer course session 7 – Using Report Filters
  

  
  

  • Creating Filters
  
  
  • Shortening large filters
  
  
  • Using filters for checking purposes

  
  Sage 50 Accounts Report Designer course session 8 – Editing Group Functions
  

  
  

  • Character Breaks
  
  
  • Producing a Trial Balance
  
  
  • Filtering Zero Values

  
  Sage 50 Accounts Report Designer course session 9 – Adding Criteria
  

  
  

  • Using Criteria
  
  
  • Adding New Criteria
  
  
  • Printing Criteria on the Report
  
  
  • Adding a New Report Header
  
  
  • User Defined Criteria

  
  

  
  Sage 50 Accounts Report Designer course session 10 – Applying Multiple Sub-totals
  

  
  

  • Adding subtotals to additional groups
  
  
  • Dealing with unwanted sections
  
  
  • Utilising the count function
  
  
  • Moving groups

  
  

  
  Sage 50 Accounts Report Designer course session 11 – Conditional Properties
  

  
  

  • Conditional Formatting
  
  
  • Advanced Conditional Formatting
  
  
  • Creating drillable reports

  
  

  
  Sage 50 Accounts Report Designer course session 12 – Joining Tables
  

  
  

  • Adding Tables
  
  
  • Performing A Join
  
  
  • Adding Data From The New Table

  
  

  
  Sage 50 Accounts Report Designer course session 13 – Layouts and Letters
  

  
  

  • Invoice layouts
  
  
  • Inserting pictures
  
  
  • Emailing reports
  
  
  • Secure PDF
  
  
  • Creating letters
  
  
  • Bar code labels

  
  Sage 50 Accounts Report Designer course Appendix
  

  
  

  • List of values for common coded variables