In this section: |
Create and name the procedure and select the tool you will use to create the report.
The Add Procedure dialog box opens.
Before Report Painter opens, the Open dialog box asks you to specify the data source you will be using to create your report.
Report Painter opens. The Object Inspector displays the fields in the CENTSTMT data source.
Before adding fields to the report, detour again to look more closely at the structure of the data in CENTSTMT.MAS. Proceed to Data Detour: What Is the Nature of the Data You Will Be Using?.
The CENTSTMT Master File used in this tutorial has two segments:
The hierarchy will come into play in the second part of this tutorial, when you begin to structure the income statement in the Financial Report Painter.
FILE=CENTSTMT, SUFFIX=FOC SEGNAME=ACCOUNTS ,SEGTYPE=S1 FIELD=GL_ACCOUNT, ALIAS=GLACCT, FORMAT=A7, TITLE='Ledger,Account', FIELDTYPE=I, $ FIELD=GL_ACCOUNT_PARENT, ALIAS=GLPAR, FORMAT=A7, TITLE=Parent, PROPERTY=PARENT_OF, REFERENCE=GL_ACCOUNT, $ FIELD=GL_ACCOUNT_TYPE, ALIAS=GLTYPE, FORMAT=A1, TITLE=Type,$ FIELD=GL_ROLLUP_OP, ALIAS=GLROLL, FORMAT=A1, TITLE=Op, $ FIELD=GL_ACCOUNT_LEVEL, ALIAS=GLLEVEL, FORMAT=I3, TITLE=Lev, $ FIELD=GL_ACCOUNT_CAPTION, ALIAS=GLCAP, FORMAT=A30, TITLE=Caption, PROPERTY=CAPTION, REFERENCE=GL_ACCOUNT, $ SEGNAME=CONSOL, SEGTYPE=S1, PARENT=ACCOUNTS, $ FIELD=PERIOD, ALIAS=MONTH, FORMAT=YYM, $ FIELD=ACTUAL_AMT, ALIAS=AA, FORMAT=D10.0, MISSING=ON, TITLE='Actual', $ FIELD=BUDGET_AMT, ALIAS=BA, FORMAT=D10.0, MISSING=ON, TITLE='Budget', $ FIELD=ACTUAL_YTD, ALIAS=AYTD, FORMAT=D12.0, MISSING=ON, TITLE='YTD,Actual', $ FIELD=BUDGET_YTD, ALIAS=BYTD, FORMAT=D12.0, MISSING=ON, TITLE='YTD,Budget', $
Tip: If you want to examine the Master File in Developer Studio, you can expand the Master Files folder in the FINANCIAL project, right-click CENTSTMT.MAS, and choose Edit in Text Editor to see the representation shown here. Alternatively, you can double-click CENTSTMT.MAS to open the file in the Synonym Editor, where you can select each field to see how its attributes have been defined. For details, see Describing Data for an FML Hierarchy.
WebFOCUS |