FRx Report Designer 6.7 User’s Guide - …

1 Copyright 2004 FRx Software rights Report Designer user s GuideRevision HistoryLegal NoticesFRx Software Corporation makes no representations or warranties with respect to the contents of this manual and specifically disclaims any implied warranties of merchantability or fitness for any particular welcome user comments and reserve the right to revise this publication and to make improvements or changes to the products and programs described in this publication at any time without in the United States of part of this publication may be reproduced in any form without the prior written consent of FRx Software and Trademarks Notice Copyright 2004 by FRx Software Corporation.

2 All rights reserved. Microsoft, FRx, instant!OLAP, and Drilldown Viewer are either registered trademarks or trademarks of Microsoft Corporation or FRx Software Corporation or their affiliates in the United States and/or other countries. All other registered trademarks and trademarks are property of their respective owners. FRx Software Corporation is a subsidiary of Microsoft NumberDocument DateSoftware ReleaseRDUGM arch 1, Report Designer user s GuidePreface .. viiWho Should Read this Guide .. viiHow this Guide is Organized .. viiWhat s New in Report Designer in FRx ..viiiAvailable Product Documentation .. ixOther Documentation .. xConventions Used in this Guide .

3 XiHow to Contact xiSoftware Licensing .. xiChapter 1: Welcome to FRx Report Designer .. 1 Using This Guide ..3 Keyboard Commands .. 3 Mouse Commands .. 3 Typographical Conventions .. 3 Note and Warning Messages .. 4 System Requirements .. 5 Installing and Starting Report Designer .. 5 Starting Report Designer .. 5 Understanding Report Designer : An Overview .. 6 Building Blocks .. 6 user Security .. 8 Report Specification Sets .. 8 Presentation Quality Reports .. 8 FRx DrillDown Viewer .. 9 Account Codes .. 9 Getting Around in Report Designer .. 11 The Report Designer Control Panel .. 11 The Toolbar .. 12 Basic Report Designer Techniques and Keyboard Commands.

4 13 Record Control Boxes .. 18 Defining Available Commands on Report Designer Menus .. 18iiContentsFRx Report Designer user s GuideChapter 2: Creating Basic Reports with FRx Report Designer .. 21 Creating a Company .. 22 Creating a Sample Report .. 25 Building a Row Format from the Chart of Accounts .. 26 Modifying a Row Format .. 28 Revenue Rows .. 28 Operating Expenses 35 Income Rows .. 38 Saving Your Row Format File .. 42 Creating a Column Layout .. 43 Working with Reporting Trees .. 46 Viewing an Existing Tree .. 46 Creating a New Reporting Tree .. 47 Creating a New Catalog ID .. 49 Generating and Viewing a Report .. 53 Completing Your Setup.

5 55 Chapter 3: Creating Row Formats .. 57 Row Format Menu Functions .. 58 File Menu .. 58 Edit Menu .. 59 Format Menu .. 63 Link 65 Row Format Toolbar .. 65 Account Code Segments .. 66 Building a Row Format .. 67 Building a Row Format From the Chart of Accounts .. 67 Defining the Account Segments in a Row Format .. 68 Opening a Row Format .. 70 Modifying Row Formats .. 70 Row Code Column .. 71 Description Column .. 71 Fmt Code Column .. 73 Related Rates/Rows/Unit 80 Normal Balance Column .. 82 Print Control Column .. 82G Column .. 83 Link Column .. 84 Totaling and Calculations .. 86 Standard Totaling (TOT) .. 86 Formula Totaling (CAL) .. 86 Point and Click Totaling for TOT and CAL rows.

6 92 General Ledger Account Codes .. 94 Zero Balance Accounts .. 94iiiContentsFRx Report Designer user s GuideDefining an Account Code .. 94 Defining Only the Natural Code .. 94 Defining the Full Account Code .. 95 Entering General Ledger Codes .. 96 Using Wildcards and Ranges .. 97 Linking to Account Types .. 100 Account Sets .. 101 Using Account Modifiers .. 103 Combining Account 105 Restricting Rows with Book Codes .. 106 Using Account Attributes and Transaction Attributes in Rows .. 107 Assigning Currency Codes .. 111 Automatic Rounding for Balance Sheets .. 112 Chapter 4: Linking to Other Sources of Information .. 115 Creating Summary Reports Using Row Links.

7 116 Natural Row Format .. 118 DetlBSIS Row Format .. 118 SummryBS Row Format .. 119 Column Layout .. 119 Reporting Tree .. 120 Establishing Links .. 121 Creating Row Formatting Links .. 122 Linking Rows to a Summary Report .. 123 Linking to External Worksheets .. 124 Referencing External Worksheet Cells .. 125 Identifying Individual Worksheet Cells .. 125 Automatic Matching of Worksheet Columns to the Current Period .. 127 Using a Combined Worksheet Link .. 128 Using a Separate Worksheet 130 Chapter 5: Creating Column Layouts .. 137 Opening the Column Layout Window .. 138 Column Layout Menu Functions .. 140 File Menu .. 140 Edit Menu .. 141 Adding Column Headers.

8 143 Creating Typical Headers .. 143 Creating Dynamic (Conditional) Headers .. 146 Adding Column Detail .. 147 Specifying Column Types .. 148 Defining General Ledger Columns .. 150 Adding Calculation Formulas .. 155 Adding Special Formatting Options .. 157ivContentsFRx Report Designer user s GuideAdding Column Restrictions .. 164 Selecting a Reporting Unit .. 165 Formatting Multicurrency Reports .. 167 Account Filters .. 169 Attribute Filters .. 170 Restricting Columns to Specific Dates .. 171 Justification .. 172 Adding the OLAP Description to the Column Layout .. 173 Customizing Transaction Detail Reports .. 173 Creating Multiple Period Transaction Detail Reports.

9 174 Creating Year-to-Date Transaction Detail Reports .. 175 Creating Debit/Credit Reports .. 175 Creating Tabular Reports .. 177 Chapter 6: Creating a Reporting Tree .. 179 Understanding Reporting Trees .. 181 Reporting Unit Structure .. 181 Multiple Reporting Trees .. 182 Account Masks .. 183 Account Mask Structure and Segments .. 183 Reporting Tree Window .. 187 Graphical Reporting Tree .. 187 Reporting Tree Worksheet .. 188 Reporting Tree Menus and Toolbar Icon .. 190 Reporting Tree Menus .. 190 Reporting Tree Toolbar Icon .. 196 Understanding Building Reporting Trees .. 197 Understanding Building Reporting Trees Automatically .. 197 Understanding Building Reporting Trees Manually.

10 203 Building Reporting Trees 205 Building a Reporting Tree with the Reporting Tree Worksheet .. 205 Building a Reporting Tree with the Reporting Units Dialog Box .. 206 Defining Parent-Child Relationships .. 211 Verifying a Unit s Parent Unit .. 212 Building Reporting Trees Automatically .. 213 Adding Text and E-mail Links to a Reporting Tree .. 216 Adding Text to the Reporting Units in a Tree .. 216 Adding E-mail Addresses to a Reporting Tree .. 217 Securing Reporting Tree Units .. 221 Chapter 7: Understanding the Catalog of Reports .. 223 Catalog of Reports Window .. 224 Catalog of Reports Menu Bar .. 225 File Menu .. 225vContentsFRx Report Designer user s Guide Edit Menu.