Author: Tim

Edit Window

Tim

The Edit window is used to add, change and delete individual records. In most cases the Edit window is associated with a List window.

The Edit window may have line items and sub-sections like the Inventory Master Edit window:

00 RAG 7-27-2012

Or, it can simply have fields from the corresponding table:

02 RAG 7-27-2012

In both cases, the button at the lower right hand corner will return to the main List window.

   Page 1 — edit window
   Page 2 — the buttons
   Page 3 — find field
   Page 4 — field TAG
   Page 5 — the edit field

Next – The Buttons >

Pages: 1 2 3 4 5

Print — Repeat

Tim

SQL returns every field on every row selected on a query. You often don’t want every field to print on every row. So… we have this reserved word.

Where count and summarize keep track of unique values, repeat deals entirely with consecutive values.  If the values of the records are like this:

A B B C B A A C C B B A  — the printing would be like this:
A B    C B A     C     B     A

There are two forms.

  1. norepeat — skips print of duplicate value
  2. repeat on — accepts modifiers. Whenever the target field or any one of the modifiers change, the field prints.

 

   Page 1 — repeat
   Page 2 — norepeat
   Page 3 — repeat on
   Page 4 — repeat on page

Next – norepeat >

Pages: 1 2 3 4

Print — Summarize

Tim

summarize is used in two ways:

  1. For numeric fields, summarize will calculate a running total of the field. The on arguments then determine when the accumulated value prints. When the field prints, the running total is reset to zero.
    Where break will print totals under an existing column, summarize prints its values in a separate column.
  2. For date and text fields, summarize acts as a filter rather than an accumulator. The on arguments determine when the date or text field prints.

All summarize statements require at least one following ‘on’ reserved word.

   Page 1 — summarize
   Page 2 — summarize syntax
   Page 3 — numeric summarize
   Page 4 — date summarize
   Page 5 — expression summarize
   Page 6 — text summarize

Next – summarize syntax >

Pages: 1 2 3 4 5 6

Reports

Tim

Common to all Telios reports is this heading:

0010 RAG 7-19-2012

Printer Selection

It was Tip O’Neal that said, “All politics is local”. Well, all printers “is” local. You may have drivers installed for network printers, but each PC has to recognize those printers and store setup data for each one. On each PC there is a “default” printer which Windows likes to use for everything. On a technical basis, all of the data for each printer is stored as a blob of data. That blob tells the printer what the margins are, orientation, page size, output tray, color, resolution… you get the idea.

What Telios does is to let you set up a logical blob for each physical printer. We then save that blob information in a local database. For each logical setup, you can assign a name that is more meaningful. So, a “Brother MFC-J630W” that you use for printing photographs with no margins and rich color, etc. could be named “Photo Printer”. That same printer used for documents that contain your color company logo could be set up with different margins, etc. and be named “Invoices”, or “Color documents”.

The printer above is for an HP 5si duplex printer with three output trays, and an envelope feeder. The settings are for 1/2 inch margins top, bottom, left and right, using tray #2 for 8-1/2 x 11 inch paper, single sided — named “BIG”.

But, this printer could also be set up as 1 inch margin top, 1/2 inch margin on the bottom, 3/4 inch on the left, 1/4 inch on the right, tray #3 for 11 x 17 inch paper, duplex. We might call it “Really Big”

Whatever you do with the settings, the configuration will be saved on your computer. You can then use your custom “BIG” or “Really Big” on any Telios report.

Each Telios report remembers the last logical printer that you used for the report.

   Page 1 — printer selection
   Page 2 — the local printers
   Page 3 — tool bar options
   Page 4 — select
   Page 5 — preview window

Next – the local printers >

Pages: 1 2 3 4 5

Calculator

Tim

Of course there is a calculator on Windows. Some keyboards even have a key that will start it up.

But sometimes you need to do math on a specific field. It would be nice if the current value of the field loaded into a calculator – and when you finished the math –  the result would load back to the starting field.

Or, maybe you would just like to start a calculator in the Telios program…

On any Telios program, there are two key sequences that will display a small calculator. it looks like this:

0009 RAG 7-16-2012

Here is an example from the General Ledger Journal entry program:

0010 RAG 7-16-2012

The first key sequence is to press the letter C where the focus is on a numeric field – like the Amount field on this window

0012 RAG 7-16-2012

The calculator will open just under the numeric field and will be loaded with the value of the field. You can press the C character anyplace on the field – beginning or end.

0016 RAG 7-16-2012

You can also right-click on the numeric field to display the context menu and select Calculator C.

The second key sequence is a combination of CTRL + SHIFT + C (3 keys). This combination will work just about any place on the window. In this case, the calculator will pop up on the lower right hand corner of the window:

0017 RAG 7-16-2012

With this sequence, the calculator is independent from any field in the window. However, if you press ENTER on the result of the calculation, the result will automatically copy to the clipboard, so you can paste it someplace else.

The calculator can:

  • Add – press +
  • Subtract – press –
  • Multiply – press X or *
  • Divide – press /
  • Clear – press C  (or ESC if calculator field is not blank)
  • Abort/Quit – press Q (quit) (or ESC if calculator field is blank)

If the calculator starts from a numeric field with C  then:

  • Re-load from field – press SPACE (when calculator field is blank)
  • Load result into field – press ENTER

Back to our original window, we have an insurance expense of $5,016.00 which happens to be an annual amount. We want to divide this up to the expense for one month:

0018 RAG 7-16-2012

press / then type 12 and ENTER

0019 RAG 7-16-2012

For each step of the math, the operation will display below the entry.

To load the result back into the Amount field, press ENTER again.

0020 RAG 7-16-2012

The calculated amount will replace the original amount.

To discard the result, press ESC or Q instead of ENTER.

You can drag the popup calculator around the window if it covers something up.