• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

Learn how to use Title Variables in your Sage Intelligence reports

By admin on June 26, 2018April 19, 2019

Having a meaningful title for a report can help make its intention clear.  For example, being able to add a date to a report name allows you to tell at a glance what information the report is referring to, and having this work dynamically is an obvious convenience.  Sage Intelligence has now made this possible using Title Variables.

This tip applies to: Sage Business Cloud Accounting

Two types of variables are provided, Company and Date.  Their use and function will be explained in the remainder of this tip.  To add these to a report do the following:

  1. Open the report for editing in the Online Design Screen or add a new report if you are creating one from scratch.
  2. Select the title for the report in the Design Screen and click the Add icon next to the Title field in the Design Pane.

  1. A dialogue box will be shown allowing you to select the variable you want to use. You can choose one or both.

  1. Click OK. You will now see two place holders shown for the variables in the Title field.

  1. The title in the Design Screen will be shown as follows.

  1. In addition to this you can place your cursor in the Title field, either before, in between, or after the variables and add any further descriptive text you would like.

  1. Next, set the filters for the report. This includes the Company, Year and Title Period.  Alternately you can wait to do this in the report filter dialogue box when you run the report from your My Reports page.  When the report is run out, the Company variable will display the company that is set in the report filters.  The title period isn’t required to run a report but needs to be set for the Date variable to show a value.  Here you have both static and dynamic options.  The date that is shown will be the last day of the month of the period that is selected.

An example of a run out report with the Company and Date variables included in the title is shown below.  This immediately adds further clarity to the information that will be presented in the report.

The post Learn how to use Title Variables in your Sage Intelligence reports appeared first on Sage Intelligence.

Source: Sage Intelligence

Post navigation

Save time by using shortcut keys in Sage Intelligence
How to insert icons into a spreadsheet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd