Crosstab tables are a useful way to summarize information in a tabular format. A crosstab table is constructed by using the values of two table columns as row and column headers. A third column is used to obtain the crosstab table cell values. The cell values are a summarization of the rows that match both the row and column header values. For example, suppose we have the following table containing the original data:
The ‘Customer’ column is used as the row header, and the ‘Product’ column is used as the column header. The summarization is done on the ‘Quantity’ column. The resulting crosstab table is shown on the left:
The same information can obviously be generated by grouping on both the‘Customer’ and ‘Product’ columns, and by summarizing the ‘Quantity’
column. However, information is often more readable when presented in the
tabular form, as in a crosstab table.
The next example changes the report table to a crosstab table. It uses the ‘Company’ and ‘Product’ columns as headers, and the ‘Quantity’ column as the details.
Additional attributes can be specified on the Options tab. These include foreground and background colors as well as font. A label for the column and row totals may be specified. By clicking the appropriate border in the ‘Crosstab Grid’ area you can define crosstab table border options. This allows you to provide attractive formatting for the crosstab table grid cells.
Both rows and columns can be sorted. Sorting is always done based on the header values. Optionally, the row header columns’ original column header can be retained. In this case, the original headers are used as the column header of the row header columns. The ‘Show Summary Headers’ option can be selected in order to see the column header names for the summary columns. If the ‘Summary Cells Side by Side’ option is selected, the summary header row appears just above the data cells; if the ‘Summary Cells Side by Side’ is not selected, a summary header column appears on the left. The text in the summary column header field can be modified by applying text formatting to those cells.
Designing Reports | InetSoft Product Features & Benefits
This is a table of contents of useful product documentation about designing reports using InetSoft's reporting products, Style Report Enterprise and Style Report Professional.
3D Dashboard Tool | InetSoft Product Features & Benefits
Searching for a tool for creating 3D dashboards? InetSoft offers easy to use dashboard software with flashy dashboard designer for creating cool looking three dimensional charts and graphs. View a demo.
Tools for Creating 3D Dashboards | InetSoft Product Features
Looking for tools for creating 3D dashboards? InetSoft offers Web-based dashboard software that has been deployed at several thousand enterpises worldwide spanning several industries.
Style Intelligence Datasheet
InetSoft's Style Intelligence™ is a data intelligence platform. At its foundation is a powerful data mashup engine that
enables fast and flexible transformation of data from disparate sources, which can either supplement or obviate a data
Report Design | Report Designer | InetSoft Reporting Software
InetSoft's Style Report software (available stand-alone or as part of Style Intelligence, InetSoft's business intelligence software, provides many report elements that can display data through text and graphics.
InetSoft Training Videos
These videos are provided to help you take full advantage of the features of your InetSoft dashboard and reporting product.
Style Report™ Enterprise is an edition of Style Intelligence that focuses on enterprise reporting. It provides production
reports and Web-based interactive reports in a zero-client, Web environment. Style Report Enterprise's small footprint, 100% Java, pure Web architecture delivers an embedding and integration-ready platform.
This section discussed the manipulation of tabular data using Table objects. A table is the most common way to present data visually on either screen or paper. It is an important feature in Style Intelligence.
InetSoft Style Report Enterprise is an edition of Style Intelligence that focuses on enterprise reporting, generating pixel-perfect production reports and delivering interactive reports in a zero-client, web environment. It also includes the same data intelligence platform as Style Intelligence which solves data management challenges such as connecting to and transforming data from disparate sources.
InetSoft Technology Corp.
InetSoft Technology Corp.