Dynamic fields in CrossTabs

rbuser

Hello,

Well... does anybody knows how to create fields dynamicaly in CrossTabs?
I found a function that "seems" to have something about it - SelectValueDef.
But, I don't know how to you it. Does anybody knows?
Thank you very much...

Bruno Nepomuceno

digitalmetaphors

Check out the RBuilder.hlp help file for more information on crosstabs.

procedure TForm1.ppReport1BeforePrint(Sender: TObject);
var
lColumnDef: TppColumnDef;
begin

ppCrosstab1.InitAvailableDimensions;

lColumnDef := ppCrosstab1.SelectColumnDef(0);

lColumnDef.FieldName := 'CustNo';

end;


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thank you very much Cheers, but I'm still having some little problems. It
worked out, but only when there was any column or row was manually
configured, I mean, not by code. When I have a empty crossbar, nothing
happens. What must I do?

digitalmetaphors

You'll want to create a value defintion first, so that the column will have
some values.

procedure CreateCrossTabStuff;
var
lColumnDef: TppColumnDef;
lValueDef: TppValueDef;
begin

ppCrosstab1.InitAvailableDimensions;

lValueDef := ppCrosstab1.SelectValueDef(0);
lValueDef.FieldName := 'AmountPaid';

lColumnDef := ppCrosstab1.SelectColumnDef(0);
lColumnDef.FieldName := 'CustNo';
end;


Cheers,

Jim Bennett
Digital Metaphors