Daniel,

You're looking for CrossTab. You can start here http://fox.wikis.com/wc.dll?Wiki~CrossTab

>
>hi friends, i've a problem i've a app that app generate university hours by materies mi table has there:
>
>my report print this :
>
>dia hini hfin materia
>lunes 1000 1100 logica
>martes 1000 1100 matematicas
>miercoles 100 200 programacion 1
>
>but that report have print this:
>
>hora lunes martes miercoles jueves viernes
>10:00-11:00 logica matematicas
>1:00-2:00 programacion1
>
>i try with sql but nothing i try too grouping data, never.
>help me please.