Hola amigos tengo un problema al hacer un reporte.
les cuento tengo 3 tablas producto, modelo, color
lo que me piden es imprimir un reporte o en tablas html de la siguiente manera
[producto1]
-------------------------------------------------------------------------------------
----------------modelo1- modelo2-modelo3-modelo4-modelo5-modelo6
-------------------------------------------------------------------------------------
color1---------3---------------5----------4----------2----------4------------4 total
-------------------------------------------------------------------------------------
color2---------4---------------6----------5----------4----------3------------3 total
-------------------------------------------------------------------------------------
color3---------4---------------8----------9----------3----------4------------3 total
-------------------------------------------------------------------------------------
total total total total total total
[producto2]
-------------------------------------------------------------------------------------
----------------modelo1- modelo2-modelo3-modelo4-modelo5-modelo6
-------------------------------------------------------------------------------------
color1---------3---------------5----------4----------2----------4------------4 total
-------------------------------------------------------------------------------------
color2---------4---------------6----------5----------4----------3------------3 total
-------------------------------------------------------------------------------------
color3---------4---------------8----------9----------3----------4------------3 total
-------------------------------------------------------------------------------------
total total total total total total
etc.
Como podría lograr eso. T_T recurro a su experiencia.
Gracias de antemano.