How to change the displayed field name in a crosstab

rbuser

I want to change the displayed field name in the columns and lines of a
CrossTab. Isn't there a way to do this at design-time?

I tried setting up a fieldalias in the associated pipeLine, but it seems
that the crosstab always use the physical field name (retrieved from the
database).

Carlos

nicocizik

The field name in the crosstab designer is determined by the Field Alias of
the field you select. This can be changed in DADE (data tab) using the
Query Designer. Simply click twice over the Field Alias (similar to
renaming a file in the Windows Explorer). If you are not using DADE, you
can alter the field aliases using the DataPipeline Field Editor. At design
time, right click over the DBPipeline connected to your crosstab and selecte
the Fields Editor option.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,

That's what I did before posting my message to the newsgroups. I use the
fields editor of the associated datapipeline to change the FieldAlias, but
it seems that the CrossTab component ignores it.

Carlos

nicocizik

Hi Carlos,

In my testing with RB 10.07, if I load the field editor of a DBPipeline and
alter the FieldAlias property of a defined field, this is used in the
CrossTab designer when it is opened. Are you certain the crosstab is
connected to the proper datapipeline?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Yep, I'm sure it is connected to the right pipeline.

I'm using RB 10.05, maybe this was solved in 10.06 or 10.07. I will update
to the latest version and check it again.

Carlos