Hello all,
I need to put subtotals in a grid group break within a group footer. I have the subtotals working, however the only way I was able to get to align to the corresponding column was to basically "stack" the subtotals where they kind of cascade to the right, but awkardly step down each line to the right. Essentially creating this "stairstep" type look.
It works, but would be way more easy on the eye if were able to include on the same "row" for each column. Below is the code for your reference.
I'm sure there is probably an easier way. Can someone please advise?
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMFOBCost.total]],"N") ,250,2,","))}</b></td>
</tr>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMDutyCost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMBrokerCost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITM7501Cost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMFreightCost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMLandedCost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMTotalLandedCost.total]],"N") ,250,2,","))}</b></td>
</tr>
I need to put subtotals in a grid group break within a group footer. I have the subtotals working, however the only way I was able to get to align to the corresponding column was to basically "stack" the subtotals where they kind of cascade to the right, but awkardly step down each line to the right. Essentially creating this "stairstep" type look.
It works, but would be way more easy on the eye if were able to include on the same "row" for each column. Below is the code for your reference.
I'm sure there is probably an easier way. Can someone please advise?
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMFOBCost.total]],"N") ,250,2,","))}</b></td>
</tr>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMDutyCost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMBrokerCost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITM7501Cost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMFreightCost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMLandedCost.total]],"N") ,250,2,","))}</b></td>
<tr >
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td class="[class.gridSummaryData]" colspan="{systemcolumnCount}"> </td>
<td colspan="100" > <b>{alltrim(str( convert_type([[groupSummary.ITMTotalLandedCost.total]],"N") ,250,2,","))}</b></td>
</tr>
Comment