Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

Sort by calculated field (RB 11.03)

edited May 2009 in DADE
Hi there,

Using Delphi 6, RB Enterprise 11.03, ODBCExpress DADE plug-in.

There appears to be a possible issue with adding a calculated field to the
sort by clause in the Query View.

My table has a field called Department (Varchar 10) but for one customer
this always contains numbers. So we created a calculated field in the query
view: CAST(Department) AS INT. This works fine, its alias is "DeptNo".

When adding this calculated field (DeptNo) to the Sort clause, the
"Department" field is put into the "Sort Fields" list instead. If I then
drag the Department field into the Sort Fields list, the calculated "DeptNo"
field is added.

This also works in reverse. If I add the original Department field and then
DeptNo, Department and then DeptNo are added in the correct sequence.

In other words, if I want to sort by the calculated field, I have to add the
field it is based on first before I can add the calculated field. I can then
remove the original Department field and everything is OK. So there is a
workaround, but there does appear to be an issue here?

Thanks
Jason.

--
Jason Sweby
Software Development Manager,
Carval Computing Limited, Plymouth, UK

Payroll - HR - T&A - Access Control

Comments

This discussion has been closed.