Versions Compared

Old Version 1

changes.mady.by.user iarmstrong

Saved on

compared with

New Version Current

changes.mady.by.user iarmstrong

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Chrono reports are the static reports with the date in columns and the data in rows. These reports are used to create static report tables to match business standard templates. 

...

This section details how to make a simple schedule summary sheet. 

  1. Go to Schedule tab > Reporting tab > Add Report button > "Chrono Report".

  2. Click in the name field and rename to "Summary".

  3. Open the Table Setup tab to edit the report.

...

  • Report rows can be added, removed, indented, moved up/down, copied, cut, pasted using the top toolbar. 

...

Button

Icon

Description

Find and Replace

<CTRL>+ H. Use this icon to quickly update a range of selected cells when editing or updating reports

Convert to Static Report

Convert your report to static. Note that if your report currently has errors, they must be resolved before the report can be converted to a static one. See the Errors list below.

Manage Custom Lists

Opens Custom Lists dialog where you may add, remove, move up/down, save and import custom lists, as well as add, remove, move up/down, sort, copy, paste and clear custom items.

Image RemovedImage Added

Formatting

Image RemovedImage Added

Use this button to:

  • configure Pivot Grid Appearance (font, size, style, color, background color for captions and samples),

  • clear formats,

  • paste or copy formats,

  • perform period formatting (font, size, style, color, background color for period captions and period names),

Usage Hints

Applicable hotkeys you may use when working with a report.

...

Right click on any field header to set or reset a color

Image RemovedImage Added

Right click on any field row to copy its full name

Image RemovedImage Added

Charts Setup tab

Before setting up tables:

  1. Select the Charts Setup tab.

  2. Add a new chart.

  3. Rename the chart to "Stockpiles".

  4. In the Primary Axis panel,

    1. change the caption to "Tonnes",

    2. change the Format to "0.0%".

  5. In the Series panel,

    1. Add three series.

    2. Name the series ROM HG, ROM MG, LG.

    3. Set the fields to "inv.hg", "inv.mh" and "inv.lg".

    4. Select from the Series Type column "FullStackedBar". You may select different types for each series to display in the Charts tab.

    5. Select colours for each bar.

...

Chats tab

Review all data you populated in the previous tab by opening the Charts tab.

...

Available filters

hg

Returns "hg"

hg?

Returns "hg" plus exactly one trailing character, ie. hg1, hg2, hg3

*note "hg" would be excluded in this filter, because it only has two characters

hg*

Returns "hg" plus any number of trailing characters, ie. hg, hg1, hga, hg171101

hg|bg

Returns "hg" or and "bg" 

!hg|!bg

Returns all parcels excepting "hg" and "bg"

...