my goal is to output on each page total quantity of items, not overall quantity of all items

coax

<p><span>Consider this table(its a miniature of the real one):</span></p><p><span style="background-color:transparent;font-family:Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">itemsID QTY   SHIPdate</span></p><p><span style="margin:0px;background-color:transparent;">

---

</span><span style="margin:0px;background-color:transparent;"> </span><span style="margin:0px;background-color:transparent;">

---

</span><span style="margin:0px;background-color:transparent;"> </span><span style="margin:0px;background-color:transparent;">

---

</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">112</span><span style="margin:0px;background-color:transparent;">    </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">10</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2010</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">02</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">02</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">111</span><span style="margin:0px;background-color:transparent;">    </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">15</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2010</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">02</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">113</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">5</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2010</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">111</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">7</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2010</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">04</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">111</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">8</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2011</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">112</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">9</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2013</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">111</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">20</span><span style="margin:0px;background-color:transparent;">  </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2014</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">114</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">25</span><span style="margin:0px;background-color:transparent;"> </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2014</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">02</span></p><p> </p><p><strong>The scenario on each page:</strong></p><ul class='bbc'><li> below each page its showing 99 qty (which I don't want)</li></ul><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><strong>What I want is that:</strong></p><ul class='bbc'><li><p style="background-color:transparent;">on 1st page it shows 30 qty (for 3 rows)</p></li><li><p style="background-color:transparent;">on 2nd page it shows 24 qty(for 3 rows)</p></li><li><p style="background-color:transparent;">and last page it shows 45(for 2 remaining rows)</p></li></ul><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><strong>what I did is that (i dont know if its right approach):</strong></p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><strong>CASE WHEN (ROW_NUMBER() OVER (ORDER BY itemID)) % 11 = 0 then 11  else (ROW_NUMBER() OVER (ORDER BY </strong><strong>itemID</strong><strong>)) % 11   end as page</strong></p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><strong>which turned my table into</strong></p><p><span style="background-color:transparent;font-family:Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">itemsID QTY   SHIPdate      Page</span></p><p><span style="margin:0px;background-color:transparent;">

---

</span><span style="margin:0px;background-color:transparent;"> </span><span style="margin:0px;background-color:transparent;">

---

</span><span style="margin:0px;background-color:transparent;"> </span><span style="margin:0px;background-color:transparent;">

---

     

---

</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">112</span><span style="margin:0px;background-color:transparent;">    </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">10</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2010</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">02</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">02     1</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">111</span><span style="margin:0px;background-color:transparent;">    </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">15</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2010</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">02</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03     2</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">113</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">5</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2010</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03     3</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">111</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">7</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2010</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">04</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03     4</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">111</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">8</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2011</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01     5</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">112</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">9</span><span style="margin:0px;background-color:transparent;">   </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2013</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01     6</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">111</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">20</span><span style="margin:0px;background-color:transparent;"> </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2014</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">01     1(i know remaining im putting them wrong)</span><br />
<span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">114</span><span style="margin:0px;background-color:transparent;">       </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">25</span><span style="margin:0px;background-color:transparent;"> </span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">2014</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">03</span><span style="margin:0px;background-color:transparent;">-</span><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">02     1</span></p><p>                                                         2</p><p>                                                         4</p><p><span style="margin:0px;background-color:transparent;color:rgb(128,0,0);">what I want is that on the 1st page is shows items 112-111-114 and it shows its respecting quantities (1-1-1) AND  below the total quantity which is 3</span></p><p> </p><p>please help</p>

Hans_vd

<p>If you have separate run and render tasks, you can use a page variable.</p><p> </p><p>Go to this page <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/tags/ccs/footer/?search_app_filters[ccs][searchInKey]=database_3'&gt;http://developer.actuate.com/community/forum/index.php?/tags/ccs/footer/?search_app_filters[ccs][searchInKey]=database_3&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&nbsp;&lt;/p&gt;&lt;p&gt;Then search for </p> <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/devshare/_/designing-birt-reports/1247-page-totals-using-page-variables'>Page Totals using page variables</a><p> </p><p>Don't click the title, the link seems to be broken, but all the info is there.</p>