Data Grid Fields

This component is used for arranging the Data Grid display. The way Data Grid component is displaying data.

StoreReport gives you access to all the data provided by Skubana. To make it easier to work with huge amounts of information tied to one line of data, we made this advance list component. In the top list we show all the data visible in Data Grid, in bottom list we show all the available fields from Skubana with additional helper fields that we setup - StoreReport fields.

StoreReport fields are the one we identified in regular usage scenario. We added common summaries field like [#qtyOrdered, #cogs, #tax...]. We added common subgroups fields like [##orderDate, ##salesChannel... ]. We added some custom math fields like [netProfit, grossProfit, shippingProfit...]. All this modifications are done using StoreReport software, and that means you can upgrade this yourself to any usage scenario you need.

Summaries column group is visible only in Tree View of Data Grid. That group is populated with "#" marked fields - summaries fields. Summaries Group is auto hidden in Flat View. As this group is important for Tree View, it is displayed in Data Grid to second column. First Column is used for Auto Subgroup of data, from second column we display Summaries Group. This also means that any regular Field, not "#,##", dragged to 2nd place will be shown in Tree View after the Summaries Group. If you have [salesChannel, orderDate...] orderDate will be after the Summaries Group.

Drag fields Drag fields to rearrange data grid
Drag fields from Visible to Removed or other way
In Tree View, first field is used for auto Grouping
Fields with # in front - summaries fields
Fields with ## in front - subgroup fields

Drag fields Drag fields to rearrange data grid

Drag fields to rearrange data grid. You can also drag header of Data Grid to rearrange data.

Drag fields from Visible to Removed or other way

You can remove or add field to data grid by dragging it from Visible to Removed

In Tree View, first field is used for auto Grouping

Drag any field you want to start grouping data to beginning of the Data Grid .

Fields with # in front

# Means a summing field. Any field you want to see in tree structure summed up, is with # in front.

Fields with ## in front

Means sub grouping field. After the regular first field grouping, you can drag more ## fields to make subgroups.
Example: On first place you drag the Sales Channel field, to get grouping by sales channel, then you drag ##orderDate
filed to group by days also. And you get a tree structure grouped by Sales Channel and Days.