Hi
I admit to not getting my head around headergrps.. I would be glad if someone could help me.
After each group of the same f_number, I want to call a query to plugin a total amount for that group.
What follows is what I have now.
<table border="1">
<tr>
<td>f number</td><td>p number</td><td>segment</td><td>a</td><td>b</td><td>c</td>
</tr>
<tr>
[records.f_number;block=tr;headergrp=f_number]
<td>[sub.tt;block=tr;p1=[records.f_number]]</td>
</tr>
<tr>
<td>[records.f_number;block=tr]</td><td>[records.p_number]</td><td>[records.description]</td><td>[records.a]</td><td>[records.b]</td><td>[records.c]</td>
</tr>
</table>
|
What is happening is: (a) I see all the f_numbers appear (each value per line) above the table, then (b) the total value (from the query) appears on the row above each group of f_numbers. I'd like to get rid of (a), and put the (b) row after each group and not before.
The first <tr> series is just a label for the table columns.
Can anyone suggest a solution?
Thanks alot.
Regards
Michael.