Código SQL
[-]SELECT Producto,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='01' then Cantidad else 0 end) as Enero,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='02' then cantidad else 0 end) as Febrero,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='03' then cantidad else 0 end) as Abril,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='04' then Cantidad else 0 end) as MAyo,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='05' then CAntidad else 0 end) as Junio,
sum(case when (substring(cast( dia as char(10)) from 6 for 2))='12' then Cantidad else 0 end) as Diciembre
FROM pedidos
WHERE (fecha >= '01.01.2007' and fecha <='31.12.2007') and dia <> '01.05.2007'
GROUP by Producto, substring(cast( dia as char(10)) from 9 for 10)
Prueba a ver con esto ... Ya nos diras
Saludos