Kirix Strata Help Manual

Contents | Index

- A -

abs()

accessing data

acos()

activating the software

add fields

add new records

aggregate functions

	Grouping Data
	Summarizing Data
	Creating Relationships
	List Functions

alignment

api

append records

application video

asin()

atan()

atom

avg()

- B -

back

back up projects

bookmarks

	Using the Bookmarks Toolbar
	Saving Data and Bookmarks
	Saving Bookmarks

bookmarks toolbar

boolean expressions

border styles

browsing the web

- C -

calculated fields

	Creating and Managing Calculated Fields
	Using Formulas to Create Calculations

calculations

ceiling()

cell editing

characters

child tables

chr()

column views

columns

add

add breaks

colors

datasheet

delete

edit views

hiding

inserting

moving

combine tables

compact project

connections

console panel

	Opening, Saving and Running Scripts
	Using Structured Query Language (SQL)

contains()

conversion functions

	Functions Used in Formulas
	Conversion Functions

convert to fixed fields

copying records

cos()

create calculations

	Creating Calculations
	Creating and Managing Calculated Fields
	Defining the Contents of a Calculated Field

create connections

creating a new table

creating formulas

csv

	Opening Local Data Files
	Opening Data from the Web
	Using the Source View

curdate()

currentDate()

- D -

data

exporting

importing

	Importing Data Sets
	Importing Data Using Scripts

protect

read-only

data links

data menu

data operations

adding data

append

calculate

copy

delete

filter

group

mark

order

overview

query

removing data

replace

sort

update

data transformation

databases

	Creating Connections to Data Sources
	Importing Data Sets
	Exporting Data Sets
	Importing Data Using Scripts

date time functions

	Functions Used in Formulas
	Date/Time Functions

date()

dates

day()

dayname()

dayofweek()

db2

	Creating Connections to Data Sources
	Importing Data Sets
	Exporting Data Sets
	Importing Data Using Scripts

decimals

default project

delete fields

deleting records

demonstration video

desiging reports

design view

divide tables

	Merging and Dividing Tables
	Dividing/Splitting Tables

dynamic fields

- E -

ebcdic

ebcdic format

ecmascript

edit calculated fields

edit column views

edit indexes

edit menu

editing data

	Editing and Replacing Data
	Editing Values in a Cell

empty count

empty()

end user licensing agreement

example video

existing projects

exp()

expired license

exporting

	Importing and Exporting Data
	Exporting Data Sets

expressions

extensions

	Using Scripts, SQL and Extensions
	Installing Extensions

external databases

	Creating Connections to Data Sources
	Importing Data Sets
	Exporting Data Sets
	Importing Data Using Scripts

- F -

favorites

feeds

field name

	Using the Design View
	Defining the Contents of a Calculated Field

field type

field width

fields

add

delete

move

file menu

files

csv

ebcdic

fixed-length

text-delimited

txt

filter groups

filter records

	Filtering Data
	Filtering Records in a Table

filter related records

find and replace

find data

find in current window

find in files

find text

fixed fields

fixed-length files

	Exporting Data Sets
	Using the Source View

floor()

fonts

format reports

format toolbar

formula builder

formula functions

formula rules

formulas

	Using the Design View
	Defining the Contents of a Calculated Field
	Using Formulas to Create Calculations
	Working with Formulas
	Rules for Creating Formulas

forward

functions

abs()

acos()

aggregate

asin()

atan()

avg()

ceiling()

chr()

contains()

conversion

cos()

curdate()

currentDate()

date time

date()

day()

dayname()

dayofweek()

empty()

exp()

floor()

hour()

iif()

index

instr()

isnull()

left()

length()

lfind()

list

ln()

log()

lower()

lpad()

ltrim()

max()

min()

minute()

mod()

month()

monthname()

numeric

other

pageCount()

pageNumber()

pi()

power()

proper()

rand()

recid()

recno()

regexp()

repeat()

replace()

reverse()

rfind()

right()

round()

rpad()

rtrim()

second()

sign()

sin()

soundex()

str()

strpart()

substr()

sum()

tableName()

tan()

text

translate()

trim()

trunc()

upper()

val()

week()

year()

functions in formulas

- G -

go to

	Using Scripts, SQL and Extensions
	Opening, Saving and Running Scripts

group breaks

group filter

group footer

group header

grouping data

	Grouping and Summarizing Data
	Grouping Data

- H -

help menu

highlight records

home

horizontal tiling

hotkeys

hour()

html tables

- I -

iif()

importing

importing data

	Importing Data Sets
	Importing Data Using Scripts

include detail records

index of functions

indexes

insert calculated fields

	Creating and Managing Calculated Fields
	Defining the Contents of a Calculated Field

insert group breaks

installing extensions

instr()

internet settings

introduction

invalid characters

isnull()

- J -

javascript

jobs

- K -

keyboard shortcuts

keywords, reserved

- L -

layout view

left()

length()

lfind()

license manager

licensing agreement

lines in reports

links

	Saving Bookmarks
	Creating Relationships

list functions

	Functions Used in Formulas
	List Functions

ln()

local data

local files

log()

logical expressions

lower()

lpad()

ltrim()

- M -

manage projects

mark records

max()

menu

tools

menus

data

edit

file

help

overview

view

merge tables

	Merging and Dividing Tables
	Merging Tables Together

merge text

microsoft access

microsoft excel

microsoft foxpro

min()

minute()

mod()

month()

monthname()

move projects

multi-user

mysql

	Creating Connections to Data Sources
	Importing Data Sets
	Exporting Data Sets
	Importing Data Using Scripts

- N -

navigating the web

navigation toolbar

	Navigating the Web
	Using the Quick Filter Utility

nested calculations

network drive

new project

new records

new table

	Using the Table View
	Creating a New Data Table

numbers

numeric functions

	Functions Used in Formulas
	Numeric Functions

- O -

odbc

	Creating Connections to Data Sources
	Importing Data Sets
	Exporting Data Sets
	Importing Data Using Scripts

opening files

	Opening Data
	Opening Local Data Files

options

datasheet

internet

privacy

proxy

report

script

	Using Scripts, SQL and Extensions
	Opening, Saving and Running Scripts

oracle

	Creating Connections to Data Sources
	Importing Data Sets
	Exporting Data Sets
	Importing Data Using Scripts

order records

other functions

	Functions Used in Formulas
	Other Functions

- P -

page layout

pageCount()

pageNumber()

panel

console

	Opening, Saving and Running Scripts
	Using Structured Query Language (SQL)

fields

marks

project

relationships

parent tables

pdf

pi()

power()

preferences

internet

privacy

project

report

script

	Using Scripts, SQL and Extensions
	Opening, Saving and Running Scripts

print preview

printing reports

privacy settings

project manager

project panel

	Using the Project Manager
	Using the Project Panel

project preferences

project tree

	Using the Project Manager
	Using the Project Panel

projects

add existing

backing up

collaborating

compact

manage

move

new

overview

sharing

proper()

protect data

proxy settings

- Q -

queries

quick filter

quick find

quick report

quick sum

- R -

rand()

read-only

recid()

recno()

refresh

regexp()

relationship panel

remove group breaks

repeat()

replace records

replace text

replace()

replacing data

report settings

reports

add fields

add text

columns and rows

design view

footers

	Using Report Settings
	Working in the Design View

formatting

formulas

groups

headers

	Using Report Settings
	Working in the Design View

layout view

overview

page layout

pdf

printing

saving

sections

settings

sharing

template

reserved keywords

reverse()

rfind()

right()

round()

row colors

rpad()

rss

rtrim()

rules for formulas

- S -

save

	Saving Data and Bookmarks
	Using Save

save as

save as external

saving bookmarks

saving column views

saving data

saving reports

scheduling jobs

scheduling queries

scheduling scripts

	Using Scripts, SQL and Extensions
	Opening, Saving and Running Scripts

scripts

	Importing Data Using Scripts
	Using Scripts, SQL and Extensions
	Opening, Saving and Running Scripts
	Using Structured Query Language (SQL)

search data in tables

second()

settings

internet

privacy

proxy

report

script

	Using Scripts, SQL and Extensions
	Opening, Saving and Running Scripts

shared projects

sharing reports

shortcuts

sign()

sin()

software activation

sort orders

sort records

soundex()

source table

spaces in field names

split tables

	Merging and Dividing Tables
	Dividing/Splitting Tables

sql

	Opening, Saving and Running Scripts
	Using Structured Query Language (SQL)

sql server

	Creating Connections to Data Sources
	Importing Data Sets
	Exporting Data Sets
	Importing Data Using Scripts

sql statement

sql view

stop

str()

strings

strpart()

structure

structured query language

	Opening, Saving and Running Scripts
	Using Structured Query Language (SQL)

substr()

sum()

summarize tables

summarizing data

- T -

table

add new records

append records

delete records

edit cells

new

replace records

update records

table views

tableName()

tables

calculations

copying records

divide

filter records

group breaks

group data

links

mark records

merge

order records

query

quick sum

relationships

sort records

split

summarize

tabs

tan()

template view

text alignment

text files (txt)

text functions

	Functions Used in Formulas
	Text Functions

text justification

text-delimited files

	Opening Local Data Files
	Exporting Data Sets
	Using the Source View

tiling

	Navigating the Web
	Using the Table View

toolbar

bookmarks

format

navigation

tools menu

translate()

trim()

trunc()

tsv

tutorial video

txt

	Opening Local Data Files
	Creating Connections to Data Sources
	Exporting Data Sets
	Using the Source View

type

- U -

update records

upper()

URL bar

- V -

val()

vertical tiling

video tutorials

view menu

viewing jobs

views

design

source

table

- W -

web

navigation

overview

web browsing

web data

	Opening Data
	Opening Data from the Web

week()

welcome

width

working with formulas

wrap text

- Y -

year()