As often happens with our ASP.NET MVC Edition, we've recently introduced a new control that launched in Wijmo Enterprise several months ago. MultiRow Data Grid is a data grid that displays cells in a stacked format, reducing the need to scroll right to view additional columns. While it’s not a familiar spreadsheet format in North America, it’s very popular in Japan, and makes a lot of sense once you understand how it works.
In the example below, each item record consists of two rows (we’ll call them first and second). The first row includes Order ID, name, email, and shipper, etc. The second row includes the cost, address, phone, etc. In this example, you can see how MultiRow also supports pagination.
With the heavier border between records, you can see how a user can quickly assess all the fields in a record, instead of needing to scroll right to see more. In addition, you can group like fields so they’re in the same column, offering more of a summary at a glance.
In MultiRow, you can even collapse the header into a single row. The blue triangle allows the user to expand the headers:
Basic Features and Benefits of MultiRow Grids
- Display many fields in single page without scrolling.
- Display a grid in a flexible layout. For instance, in reports, you can create multiple rows and merge cells in single record.
- Group some fields and show hierarchical structure. For example, you can show customer’s name, e-mail, address fields in the same column group.
- Provides all the same features as FlexGrid.
- Uses multiple rows to represent each record.
- Merging cells for each record (not only for single record).
- Header has the same layout as body, and also header can be collapsed into single row.
- Users can navigate with keyboard just same way as single row grid.
- Select all rows of a record by clicking row header.
- FlexGrid features are also supported. Filtering, grouping, paging, freezing rows and columns, adding and deleting records, data type, datamap, resizing column, etc.