Cannot find what you need? - Click here to contact us

Close




Customise the Desktop reports/templates and change the tags?

Reporting in Schedule it DESKTOP/ONPREM ONLY!!!!!



Open Reporting


As Schedule It Desktop uses open databases (Access, MSSQL and MySQL) you can choose any external reporting tools that allows you to access our database directly. Our understanding is external reporting tools such as Crystal Reports, Active Reports and many others allow you to use your own reporting tool against the Schedule It database.


Built-in Reports and Program Templates


The report system, emails and email templates, Outlook integration, HTML templates, and general information layout is template based so you can customise the database fields and text used to fit your needs.

  • Report Templates
  • Program Templates
  • Data Tags
  • Action Tags
  • Creating New Reports




    Report Templates


    For reports you can create templates from any text type document e.g DOC, RTF, TXT, CSV, ICS, VCS, HTML... All you need to do is create a document of your choice and insert special text tags shown below which will be inserted into your document with the event/project data. You can add your own, or edit the sample report templates, in the folder '...My Documents/Schedule it 7/Reports'.

    10 sample reports are supplied with Schedule it to demonstrate simple and detailed event reports, resource reports, sample invoice, quotation and order confirmation forms. These can be modified and saved with new names and your own company and custom details.

    The report templates are normally stored in the '...My Documents/Schedule it 7/Reports' folder although you can choose any location to save and load your report templates. When choosing 'Print' or 'Generate Report' within Schedule it you can change the location the templates are loaded from by clicking the path button ('...') on the right of the path box at step 2 of generating your report.

    If you make modifications to any reports its good to use a different name when saving before installing an update as all sample reports will be updated during the installation. Any replaced templates are automatically backed up.




    Program Templates (Layouts, Styling, Email, Outlook, HTML)


    Program templates are used for email alerts, Outlook appointments, the layout of data in the different views, and also html outputs. You can edit the templates from the menu Tools/Options/Templates and choose the template you wish to edit. You can also edit these directly with Notepad from the templates folder in 'My Documents/Schedule it 7/templates'.

    Most used program template files

    template_bar.txt = Event details shown in the bars and events in all views.
    template_popup.txt = Event details shown when hovering the mouse over an event.
    template_event_resources_popup.txt =Resource details shown when hovering the mouse over a resource.
    template_email_body.txt = Layout for the email alert. First line is subject, others are email body.
    template_email_ics.txt = Format of the iCalendar attachment to email alerts used for creating remote appointments.
    template_outlook.txt = Format for the appointment added to Outlook. First line is subject, others are appointment body.
    template_html_index_dynamic.html = Format for the main page used in 'Full Web Outputs'.
    template_html_ics.txt = Format for the iCalendar attachment used for creating remote appointments in 'Full Web Outputs'.

    Networked and shared templates

    If you need to store your templates in a common network location for you and other users to access you can change the location where templates are loaded by specifying a new location. In the menu Tools/Options/Network, choose a common path and tick the 'Template Files' tick box. You can now copy your local templates folder to this location and you and all users can also use this location for their templates and other shared files.




    Data Tags


    Tags are special text words that are replaced with actual data when the document or template is created. E.g. Adding SI-E-Title, will tell the report/template generator where to put the event title when creating a report or template.

    Global Tags:

    SI-User = User name of current user
    SI-Date = Current Date
    SI-DateTime = Current Date and Time
    SI-DateReportStart = The start date for the report
    SI-DateReportEnd = The end date for the report

    SI-R-Primary-Name (** Discontinued, use 'Extended Resource Details' see below **)
    SI-R-Primary-EmailAdd (** Discontinued, use 'Extended Resource Details' see below **)
    SI-R-Primary-Data1 to SI-R-Primary-Data10 (** Discontinued, use 'Extended Resource Details' see below **)

    SI-TotalReportEvents = Total events in the report
    SI-TotalReportEventExpenses = Total expenses in the report
    SI-TotalReportResourceCosts = Total resource costs in the report
    SI-TotalReportResources = Total resources in the report
    SI-TotalReportPrice = Total expenses and resources costs in the report
    SI-Condition-1 = Total events that are Accepted
    SI-Condition-2 = Total events that are Declined
    SI-Condition-3 = Total events that are Pending
    SI-Condition-4 = Total events that are Attended
    SI-Condition-5 = Total events that are Absent
    SI-Condition-All = Total events in any condition

    Event Tags:

    SI-E-ID = ID
    SI-E-Title = Title
    SI-E-Notes = Notes
    SI-E-FormatNotes = Notes for formatted reports (e.g Word, Wordpad)
    SI-E-SingleNotes = All notes on 1 line
    SI-E-DateStart = e.g 01/01/2001 09:00
    SI-E-DateEnd
    SI-E-ShortDateStart = e.g 01/01/2001
    SI-E-ShortDateEnd
    SI-E-ShortTimeStart = e.g 09:00
    SI-E-ShortTimeEnd
    SI-E-DayOfWeekStart = e.g. Monday
    SI-E-DayOfWeekEnd
    SI-E-WeekNumberStart = Week number where event starts
    SI-E-CreatedBy
    SI-E-ModifiedBy
    SI-E-Completed
    SI-E-OwnersNames = Names of all linked resources, limited to first 350 characters
    SI-E-OwnersNamesAll = Names of all linked resources
    SI-E-NamesIn-?????-Group = Names of linked resources in the specified group ID
    SI-E-CountIn-?????-Group = Number of linked resources in the specified group ID
    SI-E-SelectedResource-?????-IsSelected = Outputs 1 if resource with specified ID is selected
    SI-E-ResourceAnswer-?????-Value = Resource Units/Question answer for resource with specified ID
    SI-E-Owners
    SI-E-Priority
    SI-E-Price = The total value of all event expenses
    SI-E-ResourceCosts = Costs based on resource charge rates (Calculated live)
    SI-E-AllCosts = Total expenses and resource costs combined
    SI-E-Location
    SI-E-EmailAdd
    SI-E-Private
    SI-E-Locked
    SI-Copyright
    SI-E-Custom1
    SI-E-Custom2
    SI-E-Custom3
    SI-E-Custom4
    SI-E-SingleCustom4 = (custom4 on 1 line)
    SI-E-Custom5 = (0 or 1, or SI-E-Custom5-x to use language file x:359 or x:360 value)
    SI-E-Custom6 = (0 or 1, or SI-E-Custom6-x to use language file x:359 or x:360 value)
    SI-E-Custom7
    SI-E-Custom8
    SI-E-Custom9
    SI-E-Custom10
    SI-E-Duration = Calculated event duration shown as text
    SI-E-DurationM = Calculated event duration shown in minutes
    SI-E-DurationH = Calculated event duration shown in hours
    SI-E-ParentID = The ID of the parent event if this event is a child
    SI-E-SeriesID = The series/group ID the event belong to
    SI-E-ResourceCondition = Only used in Resource reports. Shows the current resource condition as Accepted, Declined, Pending, Attended and Absent.
    SI-E-Condition-1 = Total resources in the event that are Accepted
    SI-E-Condition-2 = Total resources in the event that are Declined
    SI-E-Condition-3 = Total resources in the event that are Pending
    SI-E-Condition-4 = Total resources in the event that are Attended
    SI-E-Condition-5 = Total resources in the event that are Absent
    SI-E-Condition-All = Total resources in the event in any condition
    SI-E-Resource-Count = Total resources in event

    SI-E-EventHTMLColour
    SI-E-EventHTMLColourBack

    SI-R-First-Name (** Discontinued, use 'Extended Resource Details' see below **)
    SI-R-First-EmailAdd (** Discontinued, use 'Extended Resource Details' see below **)
    SI-R-First-Data1 to SI-R-First-Data10 (** Discontinued, use 'Extended Resource Details' see below **)

    SI-R-Condition-1 = Total events that are Accepted
    SI-R-Condition-2 = Total events that are Declined
    SI-R-Condition-3 = Total events that are Pending
    SI-R-Condition-4 = Total events that are Attended
    SI-R-Condition-5 = Total events that are Absent
    SI-R-Condition-All = Total events that in any condition

    Chart Tags:

    SI-C-Name
    SI-C-Field1
    SI-C-Value1

    Special HTML/ICS tags (For HTML and ICS Export Only):

    SI-Skills = Show selected skills of event or resource
    SI-E-HTMLNotes = Notes formatted with HTML code for new lines
    SI-E-EventColour
    SI-E-HtmlOwners
    SI-E-HtmlLocked
    SI-E-CustomHTML4 (br
    SI-HtmlStatus
    SI-Links
    SI-E-vCalName
    SI-ICS-Private
    SI-ICS-DateStart
    SI-ICS-DateEnd
    SI-ICS-Notes
    SI-ICS-Custom4


    Resource Tags:

    SI-Group = Name of the group being processed in a report
    SI-R-Name = Resource name
    SI-R-EmailAdd = Email Address
    SI-R-GroupNames = Names of Groups resource is in
    SI-R-Price_Amount=- Charge Amount
    SI-R-Price_Type = Charge Type
    SI-R-TotalCost = Total Cost
    SI-R-TotalTime = Calculated total resource duration shown as text
    SI-R-TotalTimeM = Calculated total resource duration shown in minutes
    SI-R-TotalTimeH = Calculated total resource duration shown in hours
    SI-R-TotalEvents = Total Events
    SI-R-Data1 to SI-R-Data10 = The 10 fields in the General page
    SI-R-Location

    Document/Attachments:

    SI-AttLoop
    SI-E-AttachmentName
    SI-E-AttachmentShortName
    SI-E-AttachmentStart
    SI-E-AttachmentEnd
    SI-E-AttachmentAction
    SI-E-AttachmentID
    SI-E-AttachmentExt
    SI-AttLoopEnd

    Expense Tags:

    SI-Ex-ID = ID
    SI-Ex-Date = Date
    SI-Ex-Description = Description
    SI-Ex-Value = Value
    SI-Ex-Type = Type
    SI-Ex-CostCtr = Cost Center
    SI-Ex-Paid = Is Paid
    SI-Ex-Receipt = Is Receipted

    Example:
    SI-ExpenseLoop
    SI-Ex-Description, SI-Ex-Value
    SI-ExpenseLoopEnd





    Creating Reports


    Where possible you should create a copy and edit the sample reports and templates provided but you can also create your own from new. Areas of the reports/templates are grouped and then copied for each event or resource using Loops. All text between the Loop and LoopEnd tags will be repeated for each item.

    There are 2 types of reports that can be created. An event Event report lists all events, based on your search and filter setting, and outputs them in a list. A Resource report will output the details of each resource, based on your search and filter setting, and then all events that the resource is linked to.

    Sample report - Event CSV/Excel Report

    SI-EventLoop
    'SI-E-Title','SI-E-DateStart','SI-E-DateEnd'
    SI-EventLoopEnd


    Sample report - Resource CSV/Excel Report

    SI-ResourceLoop
    'SI-R-Name','SI-R-EmailAdd','SI-R-Data1','SI-R-Data2'
    SI-ResourceLoopEnd


    Sample report - Resource CSV/Excel Report including Events

    SI-ResourceLoop
    'SI-R-Name','SI-R-EmailAdd','SI-R-Data1','SI-R-Data2'

    SI-EventLoop
    'SI-E-Title','SI-E-DateStart','SI-E-DateEnd'
    SI-EventLoopEnd

    SI-ResourceLoopEnd


    Sample report - Extended Resource Details (Download this sample)

    SI-EventLoop
    'SI-E-Title','SI-E-DateStart','SI-E-DateEnd'

    SI-ResLoop
    SI-GroupsShow(10) SI-R-Name, SI-R-Data1, SI-R-Data2, SI-R-ResourceAnswer, SI-R-ResourceCondition...
    SI-ResLoopEnd

    SI-EventLoopEnd

    SI-ResourcesShow(????) can also be used (in exchange of SI-GroupsShow(????)) to output only specific resources in the event.


    Sample report - Chart Data CSV/Excel Report

    SI-ChartLoop
    'SI-C-Label1','SI-C-Value1'
    SI-ChartLoopEnd





    Action Tags


    Special action tags can be added to reports to force specific modes of reporting or actions for individual reports. Action tags can be added any where in your report and are removed automatically once detected.

    SI-Report-UseFullHours(1) = In resource reports durations are calculated for each event but only for the resource being reported on. When this action tag is added the duration will reported for all resources in the event.
  • Last updated, 11 January 2023, 16:32




    Leave a public comment (Login required) or click here to contact us for support




    Still need help? Contact Us
    Schedule it
    /faq/10055/customise-the-desktop-reports-templates-and-change-the-tags
    Join Us - Live Webinar
    ...
    Close
     
    Help Topics
    Search
    Contact Us