Crosstab report

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. The order
by clause in the dataset is by employee_id, but the crosstab itself orders
the data by the whatever you put as the first column.

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

Thanks,
Yelena

nicocizik

Yelena,

Try not using a CrossTab. Try creating a regular report that emmulates a
grid and performs summary calculation on the dataset using calc fields.

You may also want to check out some of the add-on grid components available
for ReportBuilder. More information on these add-on components can be found
on our website in the friends | rcl section.
http://www.digital-metaphors.com.

--