Kirix Strata Help Manual
| Welcome |
| Using Projects |
| Browsing the Web |
| Accessing and Saving Data |
| Opening Data |
| Saving Data and Bookmarks |
| Creating Connections to Data Sources |
| Importing and Exporting Data |
| Viewing Data Sets |
| Performing Standard Data Operations |
| Adding and Removing Data |
| Creating a New Data Table |
| Adding Individual Records to a Table |
| Deleting Records from a Table |
| Appending Records to a Table |
| Editing and Replacing Data |
| Merging and Dividing Tables |
| Copying Data |
| Sorting/Ordering Fields |
| Filtering Data |
| Finding/Searching for Data |
| Marking/Highlighting Records |
| Creating Calculations |
| Creating and Managing Calculated Fields |
| Defining the Contents of a Calculated Field |
| Using Formulas to Create Calculations |
| Grouping and Summarizing Data |
| Creating Queries |
| Creating Relationships |
| Designing and Printing Reports |
| Using Report Settings |
| Working with Sorts and Groups |
| Working in the Design View |
| Working in the Layout View |
| Formatting a Report |
| Printing, Saving and Sharing a Report |
| Viewing and Scheduling Jobs |
| Using Scripts, SQL and Extensions |
| Working with Formulas |
| Types of Formulas |
| Rules for Creating Formulas |
| Using the Formula Builder |
| Functions Used in Formulas |
| Index of Functions |
| Conversion Functions |
| Date/Time Functions |
| Numeric Functions |
| Abs() |
| Acos() |
| Asin() |
| Atan() |
| Ceiling() |
| Cos() |
| Exp() |
| Floor() |
| Ln() |
| Log() |
| Mod() |
| Pi() |
| Power() |
| Rand() |
| Round() |
| Sign() |
| Sin() |
| Tan() |
| Trunc() |
| Text Functions |
| Chr() |
| Contains() |
| Instr() |
| Left() |
| Length() |
| Lfind() |
| Lower() |
| Lpad() |
| Ltrim() |
| Proper() |
| Regexp() |
| Repeat() |
| Replace() |
| Reverse() |
| Rfind() |
| Right() |
| Rpad() |
| Rtrim() |
| Soundex() |
| Strpart() |
| Substr() |
| Translate() |
| Trim() |
| Upper() |
| List Functions |
| Other Functions |
| Menu Reference |
| Keyboard Shortcut Reference |
| Video Tutorial Library |
© 2002-2022 Kirix Research LLC. All rights reserved.