Designing Longview Data Grids
You can create interactive Data Grids that enable users to work with data in the Longview database. The data displayed by a Data Grid is determined by the Data Area that the grid specifies in the Show DataArea function. For more information on this function, see “Show DataArea”.
Data View definition files define the layout, format, and behavior of data in a Data Grid. Use Data View functions in a Longview Data View definition (.lvdvw) file. The Data View definition file is also referenced by the Show DataArea command used in a procedure file.
The following graphic shows a typical Data Grid.
A Data Grid, such as the one above, could be defined in a Data View definition file similar to the following:
Example
//Orientation
Rows Accounts
Columns TimePeriods
Fix Details, Local_Statutory
Fix Departments, Departments_Default
Fix Products, Products_Default
Fix DIMENSION8, DIMENSION8_Default
Fix DIMENSION10, DIMENSION10_Default
Fix DIMENSION11, DIMENSION11_Default
Fix DIMENSION12, DIMENSION12_Default
Fix DIMENSION13, DIMENSION13_Default
Fix ReportingSets, ReportingSets_Default
Fix ScalingFactors, ScalingFactors_Default
//Slice Entities and Currency
Slice Entities, TORONTO
Slice Currency, TCAD
//Appearance
DefaultDecimals 2
Parentheses ON
ThousandsSeparator ON
InsertSeparator BLANK, Accounts, Month_End_Balances, AFTER, 1
//Add Save and Close buttons
Action "Save", "NII\images\save.ico", "Upload NII", "Save Data", toolbar|cellcontext, "parent & Leaf"
Action "Close", "NII\images\close.ico", "Show Return", "Close Data Grid", toolbar|cellcontext, "parent & Leaf"
//End of data view
This section contains the Longview Application Framework functions you can use in a Data Grid. Click the links in the following table for detailed usage and syntax information.
This chapter contains information on these main topics: