Help report creation

[Alan]

I have to make a report, but am having some difficulties.
I am developing a report called structures.

In the first place I have, the description of the structures.

Involve three different tables. (Structures, types of structures, units of measure)

I select the following:

SELECT Structures. *
Unidades_Medida.v_descricao_unidade_medida,
Tipos_Estrutura.v_descricao_tipo_estrutura
FROM Structures
LEFT OUTER JOIN ON Unidades_Medida Unidades_Medida.i_id_unidade_medida = Estruturas.i_id_unidade_medida
LEFT OUTER JOIN ON Tipos_Estrutura Tipos_Estrutura.i_id_tipo_estrutura = Estruturas.i_id_tipo_estrutura

it returns me the description, the type of structure ...

only exists within each description of the structure (the structure items)
involving other tables.

How products_and_services / Itens_estruturas.

I need to put it all together ...

Then in the report, it gives me the following option:

structures
------> With your description, their fields, as in select.
And within that, bring the items of this structure (which involves two other tables)


For example:

Structure: All white 15 MM
Type: Box
Unit of Measure: Cubic Meter
Quantity: 1
Cost: 124.00
M3 Cost: 124.00
Total Cost: 124.00
DOWN COMES THE STRUCTURE OF THE ITEMS IN MY REPORT .. RELATED TO MY ID_ESTRUTURA.

ID: 5
DESCRIPTION: MDF
QUANTITY 2 ::
VALUE: 200
SUBTOTAL: 400

[Alex K.]

Hello,

Please send us your report with test data for analysis. We will try to prepare the sample for you.

Thank you.