Table

To add a table, set the frame element’s type attribute to table as shown in the following example.

Example of XML Report Definition to Generate Table Type JSON Data

    <report>
 		...
        <frame type="table" query-name="MainQuery" name="MainFrame">
            <groups>
                <group name="grpAllDiscounts">
                    <group-item name="organizationID" data-type="integer"></group-item>
                </group>
                <detail>
                    <detail-item name="discountName" data-type="text"></detail-item>
                    <detail-item name="discountTotal" data-type="number"></detail-item>
                    <detail-item name="discountCount" data-type="number"></detail-item>
                    <detail-item name="AvgDiscount" data-type="number"></detail-item>
                    <sort-rules>
                        <sort-rule name="s1">
                            <sort-field name="discountName" sort-type="ascending"></sort-field>
                        </sort-rule>
                        <sort-rule name="s3">
                            <sort-field name="discountTotal" sort-type="ascending"></sort-field>
                            <sort-field name="discountName" sort-type="ascending"></sort-field>
                        </sort-rule>
                        <sort-rule name="s4">
                            <sort-field name="discountCount" sort-type="descending"></sort-field>
                            <sort-field name="discountName" sort-type="ascending"></sort-field>
                        </sort-rule>
                        <sort-rule name="s5">
                            <sort-field name="AvgDiscount" sort-type="descending"></sort-field>
                            <sort-field name="discountName" sort-type="ascending"></sort-field>
                        </sort-rule>
                    </sort-rules>
                </detail>
            </groups>
            <sort-actions default="a3">
                <sort-action name="a1">
                    <sort-action-rule group-name="detail" sort-rule="s1"></sort-action-rule>
                </sort-action>
                <sort-action name="a3">
                    <sort-action-rule group-name="detail" sort-rule="s3"></sort-action-rule>
                </sort-action>
                <sort-action name="a4">
                    <sort-action-rule group-name="detail" sort-rule="s4"></sort-action-rule>
                </sort-action>
                <sort-action name="a5">
                    <sort-action-rule group-name="detail" sort-rule="s5"></sort-action-rule>
                </sort-action>
            </sort-actions>
            <bands>
                <band type="table-column-header">
                   <cell type="text" data-format="text" alignment="left" style="header_1" sort-action="a1">DiscountName</cell>
                   <cell type="text" data-format="text" alignment="left" style="header_1">DiscountPercentage</cell>
                  <cell type="text" data-format="text" alignment="right" style="header_1" sort-action="a4">DiscountCount</cell>
                  <cell type="text" data-format="text" alignment="right" style="header_1" sort-action="a5">AverageAmount</cell>
               </band>
               <band type="table-body">
                 <cell type="column" data-format="text" alignment="left" print-width="130" indent-level="6" drilldown="DrillAllChecks">discountName</cell>
                 <cell type="column" data-format="percent" alignment="right" suppress-zeroes="true" print-width="30" decimal-places="0" name="DiscPercent">posPercent</cell>
                 <cell type="column" data-format="integer" alignment="right" print-width="80">discountCount</cell>
                 <cell type="expr" data-format="currency" alignment="right" print-width="80" name="AvgDiscount">discountTotal/discountCount</cell>
               </band>
            </bands>
        </frame>
    	
        <layout type="columner">
            <component frame-name="MainFrame" column="1" visual-type="ojTable" visual-style="oj-sm-12" visual-title=""/>
        </layout>
        
    </report>