Kirix Strata Help Manual

Contents | Index | Search

- 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()