Accordion By Row Enhanced Interface

Accordion By Row reports are HTML reports that offer an interactive interface to data aggregated at multiple levels, by presenting the sort fields within an expandable tree. By default, the report will present the highest dimension or sort field (BY value) and the aggregated measures associated with each value. The tree control can be used to open or close each dimension and view the associated aggregated values. Clicking the plus or minus sign or the arrow next to a sort field value opens new rows that display the next lower level sort field values and subtotals. The lowest level sort field, when expanded, displays the aggregated data values.

Using the Accordion By Row enhanced interface, navigation is easier when working with wide and large reports in a portal page, the data automatically resizes to fit the size of the container, and the column widths automatically adjust based on the largest data value or column title, whichever is larger. The SET EXPANDBYROWTREE=ON command in a procedure enables the enhanced Accordion By Row feature.

For more information on Accordion By Row reports, see the Creating Reports With WebFOCUS Language technical content.