pivotgrid

[jahlxx]

Hi.

First of all, sorry for this, is possible that this is answered in some previous topic.

I'm new with pivotgrid and can't gert what I am looking for, an the sample doesn't helps me.

 

I have this query:

select banco, producto, referencia,
sum(importe1) pb_saldo,
sum(importe2) pb_prestamo,
sum(importe3) pb_limldesc,
sum(importe4) pb_displdesc,
sum(importe5) pb_limlcred,
sum(importe6) pb_displcred
from
(
select a.des_banco as banco, des_pf as producto, referencia,
(case when a.cod_pf = 0 then a.importe else 0 end) as importe1,
(case when a.cod_pf = 2 then a.importe else 0 end) as importe2,
(case when a.cod_pf = 1 then a.limite else 0 end) as importe3,
(case when a.cod_pf = 1 then a.importe else 0 end) as importe4,
(case when a.cod_pf = 7 then a.limite else 0 end) as importe5,
(case when a.cod_pf = 7 then a.importe else 0 end) as importe6
from tabla a
where a.comp = :c1
) x
group by banco, producto, referencia
order by 1

And need to build a pivotgrid. I fill the leftaxis property, with banco, producto and referencia, and is shown ok.

My problem is that I don't know how to show the other fields as columns.

I've tried with topaxis, aggregators, and drilldows columns, with no success. I've tried some combinations, but can't get it.

Maybe this is a stupid mistake, or something I'm doing wrong, sure due to my ignorance.

 

Some help please.

Thanks.

[jahlxx]

Hi.

As I can see, a column for topaxis is needed, isn't it?

Thanks.