FSGReportWritingBasics.ppt

· Oracle General Ledger Financial Statement Generator FSG Report Writing Basics FSG Definition Screens FSG Definition : Autocopy NAV : Reports Autocopy All report components can be copied using the ‘Autocopy’ feature for which most of the screens discussed below have a button. Component : Whatever screen you access the autocopy from you will need to select the component you want to copy from the pick list. All report components, including whole reports can be copied. Source : Select the name of the component you want to copy. Target : type in the new name of the component. When you press the [Copy] button a concurrent request will create the new components so this may take a minute or two. Once the request is complete you can then query your new component in the normal screens just like any of the existing ones. Where possible make full use of the ‘Autocopy’ feature instead of writing components from scratch. Row Sets : Definition NAV : Reports Define Row Sets Open the Row Set window below to either define a new Row Set or select an existing one to update. The screen works like a standard Oracle form so you can use either F11 or the torch button to query an existing Row Set. When you have selected the Row Set press the ‘Define Rows’ button to open the next screen. Row Sets : Row Definitions 1 NAV : Reports Define Row Sets Use this screen to define you rows within your Row Set. A Row Set can have from one to several hundred rows. Line : This is the row number that is used to reference the row in calculations. It is recommended that you use sequences 10,20,30,40 and then restart major areas of the report in a new range. For example if writing a Balance sheet, start the Assets at 10 and the Liabilities at 500,510,520 This will give you room to make adjustments later if needed. Line Item : This is the title of the row that will appear in the report. You can enter around 130 characters but bear in mind how this will appear on the report. Row Sets : Row Defin