Crosstab

rbuser

Hi, I'm currently using RB 7.02 and trying to create a crosstab report with
employee names listed in the first column, but I need the employees to be
ordered by employee_id. In the crosstab configuration I put employee_id in
the first column and then I tried to use the "OnGetCaptionText" event and
make aText := PipeBody['employee_name'], but that did not work.

How can I go about displaying the employee name while ordering by their
unique number.

Thanks,
Yelena

nicocizik

Yelena,

The crosstab component simply traverses the data you give it. If change the
order by on the dataset you are sending the crosstab to order the employee
names correctly, you should receive the results you are after.

--