ToolZ - Dynamic Web Reporting

A client may request a report that needs to show nested results that involve some crosstabbing, and also show totals for higher nesting levels.

{|NESTED|}<h2>Level 5 nested with level 4 crosstabbed by day of week</h2>

<table id="nest-level-5-by-level-4-by-day-of-week">

  {|LOOP|NESTED.CLIENT_10_LEVEL_5(SORT=NAME)}

    {LOOP.ISFIRST?:|VANISH|}

      <thead>

        <tr class="header-row" id="nest-level-5-by-level-4-by-day-of-week-header-row">

          <th>Name <span class="seleniate">(sel)</span></th>

          {|LOOP|CLIENT_10_LEVEL_5.CLIENT_10_LEVEL_4(SORT=NAME)}

            {LOOP.ISFIRST?:|VANISH|}

              {|LOOP|CLIENT_10_LEVEL_4.DAY_OF_WEEK(SORT=ORDER_NUM,NESTED_FILTER=WITH_BLANKS)}

                <th  id="nest-level-5-by-level-4-by-day-of-week-header-column-{DAY_OF_WEEK.ID}">{DAY_OF_WEEK.NAME}</th>

              {/|LOOP|}

            {/LOOP.ISFIRST?:|VANISH|}

          {/|LOOP|}    

          <th>Total</th>            

        </tr>

      </thead>

      <tbody>

        <tr class="total-row" id="nest-level-5-by-level-4-by-day-of-week-total-row">

          <th>Total</th>

          {|LOOP|CLIENT_10_LEVEL_5.CLIENT_10_LEVEL_4}

            {LOOP.ISFIRST?:|VANISH|}

              {|LOOP|CLIENT_10_LEVEL_4.DAY_OF_WEEK}

                <td id="nest-level-5-by-level-4-by-day-of-week-count-day-of-week-{DAY_OF_WEEK.ID}">

                    {COUNT(DAY_OF_WEEK,DAY_OF_WEEK)}

                </td>

              {/|LOOP|}

            {/LOOP.ISFIRST?:|VANISH|}

          {/|LOOP|}

          <th id="nest-level-5-by-level-4-by-day-of-week-count-overall">{COUNT(CLIENT_10_LEVEL_5,OVERALL)}</th>

        </tr>

    {/LOOP.ISFIRST?:|VANISH|}    

        <tr id="nest-level-5-by-level-4-by-day-of-week-row-level-5-{CLIENT_10_LEVEL_5.ID}">

          <th id="nest-level-5-by-level-4-by-day-of-week-member-name-level-5-{CLIENT_10_LEVEL_5.ID}">

                {CLIENT_10_LEVEL_5.NAME}</th>

    {|LOOP|CLIENT_10_LEVEL_5.CLIENT_10_LEVEL_4}

      {LOOP.ISFIRST?:|VANISH|}

        {|LOOP|CLIENT_10_LEVEL_4.DAY_OF_WEEK}

          <td id="nest-level-5-by-level-4-by-day-of-week-count-level-5-{CLIENT_10_LEVEL_5.ID}-day-of-week-{DAY_OF_WEEK.ID}">

            {COUNT(DAY_OF_WEEK,DAY_OF_WEEK,CLIENT_10_LEVEL_5)}

          </td>

        {/|LOOP|}

          <td id="nest-level-5-by-level-4-by-day-of-week-count-level-5-{CLIENT_10_LEVEL_5.ID}">

            {COUNT(CLIENT_10_LEVEL_5,CLIENT_10_LEVEL_5)}

          </td>

        </tr>

      {/LOOP.ISFIRST?:|VANISH|}

        <tr id="nest-level-5-by-level-4-by-day-of-week-row-level-4-{CLIENT_10_LEVEL_4.ID}">

          <th id="nest-level-5-by-level-4-by-day-of-week-member-name-level-4-{CLIENT_10_LEVEL_4.ID}">

                    {CLIENT_10_LEVEL_4.NAME}

          </th>

        {|LOOP|CLIENT_10_LEVEL_4.DAY_OF_WEEK}

          <td id="nest-level-5-by-level-4-by-day-of-week-count-level-4-{CLIENT_10_LEVEL_4.ID}-day-of-week-{DAY_OF_WEEK.ID}">

            {COUNT(DAY_OF_WEEK)}

          </td>

        {/|LOOP|}

          <td id="nest-level-5-by-level-4-by-day-of-week-count-level-4-{CLIENT_10_LEVEL_4.ID}">

            {COUNT(CLIENT_10_LEVEL_4,CLIENT_10_LEVEL_4)}

          </td>

        </tr>

    {/|LOOP|}

  {/|LOOP|}

      </tbody>

</table>

{/|NESTED|}

{|NESTED|}<h2>Level 5 nested with level 4 crosstabbed by month-year in range with data</h2>

<table id="nest-level-5-by-level-4-by-month-year">

  {|LOOP|NESTED.CLIENT_10_LEVEL_5(SORT=NAME)}

    {LOOP.ISFIRST?:|VANISH|}

      <thead>

        <tr class="header-row" id="nest-level-5-by-level-4-by-month-year-header-row">

          <th>Name <span class="seleniate">(sel)</span></th>

          {|LOOP|CLIENT_10_LEVEL_5.CLIENT_10_LEVEL_4(SORT=NAME)}

            {LOOP.ISFIRST?:|VANISH|}

              {|LOOP|CLIENT_10_LEVEL_4.MONTH_YEAR(SORT=ORDER_NUM,NESTED_FILTER=WITH_BLANKS_IN_RANGE)}

                <th  id="nest-level-5-by-level-4-by-month-year-header-column-{MONTH_YEAR.ID}">

          {MONTH_YEAR.NAME}

        </th>

              {/|LOOP|}

            {/LOOP.ISFIRST?:|VANISH|}

          {/|LOOP|}    

          <th>Total</th>            

        </tr>

      </thead>

      <tbody>

        <tr class="total-row" id="nest-level-5-by-level-4-by-month-year-total-row">

          <th>Total</th>

          {|LOOP|CLIENT_10_LEVEL_5.CLIENT_10_LEVEL_4}

            {LOOP.ISFIRST?:|VANISH|}

              {|LOOP|CLIENT_10_LEVEL_4.MONTH_YEAR}

                <td id="nest-level-5-by-level-4-by-month-year-count-month-year-{MONTH_YEAR.ID}">

                  {COUNT(MONTH_YEAR,MONTH_YEAR)}

                </td>

              {/|LOOP|}

            {/LOOP.ISFIRST?:|VANISH|}

          {/|LOOP|}

          <th id="nest-level-5-by-level-4-by-month-year-count-overall">

            {COUNT(CLIENT_10_LEVEL_5,OVERALL)}

          </th>

        </tr>

    {/LOOP.ISFIRST?:|VANISH|}    

        <tr id="nest-level-5-by-level-4-by-month-year-row-level-5-{CLIENT_10_LEVEL_5.ID}">

          <th id="nest-level-5-by-level-4-by-month-year-member-name-level-5-{CLIENT_10_LEVEL_5.ID}">

            {CLIENT_10_LEVEL_5.NAME}

      </th>

    {|LOOP|CLIENT_10_LEVEL_5.CLIENT_10_LEVEL_4}

      {LOOP.ISFIRST?:|VANISH|}

        {|LOOP|CLIENT_10_LEVEL_4.MONTH_YEAR}

          <td id="nest-level-5-by-level-4-by-month-year-count-level-5-{CLIENT_10_LEVEL_5.ID}-month-year-{MONTH_YEAR.ID}">

            {COUNT(MONTH_YEAR,MONTH_YEAR,CLIENT_10_LEVEL_5)}

          </td>

        {/|LOOP|}

          <td id="nest-level-5-by-level-4-by-month-year-count-level-5-{CLIENT_10_LEVEL_5.ID}">

            {COUNT(CLIENT_10_LEVEL_5,CLIENT_10_LEVEL_5)}

          </td>

        </tr>

      {/LOOP.ISFIRST?:|VANISH|}

        <tr id="nest-level-5-by-level-4-by-month-year-row-level-4-{CLIENT_10_LEVEL_4.ID}">

          <th id="nest-level-5-by-level-4-by-month-year-member-name-level-4-{CLIENT_10_LEVEL_4.ID}">

                    {CLIENT_10_LEVEL_4.NAME}

          </th>

        {|LOOP|CLIENT_10_LEVEL_4.MONTH_YEAR}

          <td id="nest-level-5-by-level-4-by-month-year-count-level-4-{CLIENT_10_LEVEL_4.ID}-month-year-{MONTH_YEAR.ID}">

        {COUNT(MONTH_YEAR)}

      </td>

        {/|LOOP|}

          <td id="nest-level-5-by-level-4-by-month-year-count-level-4-{CLIENT_10_LEVEL_4.ID}">

            {COUNT(CLIENT_10_LEVEL_4,CLIENT_10_LEVEL_4)}

          </td>

        </tr>

    {/|LOOP|}

  {/|LOOP|}

      </tbody>

</table>

{/|NESTED|}

{|NESTED|}<h2<Level 5 nested with level 4 crosstabbed by month-year in range with data