Hello,

I wan to summarize some columns on report footer, so I add summary control on report footer.
the column that I wanto to summary is TOTAL_FACTURA, so summary is sum(TOTAL_FACTURA)

Sql expression to run this report is
select com_ivacompres.id as idx , com_ivacompres.*, sup_proveidors.* from com_ivacompres, sup_proveidors
Where id_proveidor = sup_proveidors.id

When I click on preview valentina throw this error :
17:38:13 Page 1: Error( 1060 ) 42S21: "Duplicate column name 'ID'"
17:38:13 Page 1: SELECT * ,TOTAL_FACTURA AS InternalReportField0 FROM ( select com_ivacompres.id as idx , com_ivacompres.*, sup_proveidors.* from com_ivacompres, sup_proveidors
Where id_proveidor = sup_proveidors.id) as foo

If I remove this summary control, report runs fine.

Whats wrong ?