Reporte Matricial en BI Publisher

Para hacer un reporte matricial en Bi Publisher,  el escenario es:  se desea saber el número de facturas vencidas en receivables  a 30, 60, 90 días agrupado por número de cliente.
Entendiendo por vencidas, todas aquellas facturas que no tengan asociado un cobro, un recibo.
El xml de ejemplo.

---

<?xml version="1.0" encoding="UTF-8"?>
<G_REPORT>
<G_LINES>
<COL>30 Days</COL>
<TEXT_VALUE>1</TEXT_VALUE>
<CUSTOMER_NUMBER>BAQP640604K48</CUSTOMER_NUMBER>
</G_LINES>
<G_LINES>
<COL>60 Days</COL>
<TEXT_VALUE>10</TEXT_VALUE>
<CUSTOMER_NUMBER>BAQP640604K48</CUSTOMER_NUMBER>
</G_LINES>
<G_LINES>
<COL>90 Days</COL>
<TEXT_VALUE>30</TEXT_VALUE>
<CUSTOMER_NUMBER>BAQP640604K48</CUSTOMER_NUMBER>
</G_LINES>
<G_LINES>
<COL>30 Days</COL>
<TEXT_VALUE>10</TEXT_VALUE>
<CUSTOMER_NUMBER>BAQP701211TE1</CUSTOMER_NUMBER>
</G_LINES>
<G_LINES>
<COL>60 Days</COL>
<TEXT_VALUE>1</TEXT_VALUE>
<CUSTOMER_NUMBER>BAQP701211TE1</CUSTOMER_NUMBER>
</G_LINES>
<G_LINES>
<COL>90 Days</COL>
<TEXT_VALUE>45</TEXT_VALUE>
<CUSTOMER_NUMBER>BAQP701211TE1</CUSTOMER_NUMBER>
</G_LINES>
<G_LINES>
<COL>30 Days</COL>
<TEXT_VALUE>40</TEXT_VALUE>
<CUSTOMER_NUMBER>TVON844022TX1</CUSTOMER_NUMBER>
</G_LINES>
<G_LINES>
<COL>60 Days</COL>
<TEXT_VALUE>1</TEXT_VALUE>
<CUSTOMER_NUMBER>TVON844022TX1</CUSTOMER_NUMBER>
</G_LINES>
<G_LINES>
<COL>90 Days</COL>
<TEXT_VALUE>61</TEXT_VALUE>
<CUSTOMER_NUMBER>TVON844022TX1</CUSTOMER_NUMBER>
</G_LINES>
</G_REPORT>

En MS-Word, hay que insertar una tabla de 2×2 y poner el codigo a en las celdas:

Customer Number	<?for-each-group@column:G_LINES;./COL?> <?COL?> <?end for-each-group?>
<?for-each-group@section:G_LINES;./CUSTOMER_NUMBER?> <?CUSTOMER_NUMBER?> <?variable@incontext:CUST_NUM;CUSTOMER_NUMBER?>	<?for-each-group@cell://G_LINES;./COL?> <?if:count(current-group()[CUSTOMER_NUMBER=$CUST_NUM])?> <?current-group()[CUSTOMER_NUMBER=$CUST_NUM]/TEXT_VALUE?><?end if?> <?end for-each-group?><?end for-each-group?>

Tendria que verse algo asi, ya formateado.

Advertisement