get header-detail and include summarized in detail [vb6 & DataReport]

[4prendiz]

hello friends,

I'm a little problem and would like to know if you could help me with one hand.

I am making an application in vb6 with questions DataReport $$$.

Now I have to print some slips yet must show a short summary of the last approved invoices made to the customer by way of information.

I have my consultation with shape (somewhat simplified because it is quite extensive)

EjecutarShape rstReport, "SHAPE {SELECT id_albaran, nroAlbaran approved, Total tbl_albaran FROM ORDER BY 1 DESC} header as" & _
                         "APPEND ({SELECT id_detalle_albaran, concept, cost, id_clienteFK, id_albaranFK FROM tbl_albaran_detalle} as detail" & _
                         "RELATE TO id_albaran id_albaranFK) retail as"

with this query I get very goods shipments to all clients I have. But now I want to include in the delivery note as he had mentioned above, a summary as a subquery which the DataReport does not allow me no longer working with subreports. I can not make a second detail.

the query to get the summary would be using TOP 3

SELECT TOP 3 id_albaran, nroAlbaran approved, Total tbl_albaran FROM ORDER BY 1 DESC

but I can not include it as mentioned above, try to add a label and display the result in that control section that intend to use the detail but it is not.

I need to do something rather like:



any ideas or suggestions are welcome.

thank you very much for your patience.