can't sort by related filed?

[progame]

table
order:
orderid orderdate productid

product:
productid, productname

relation: order.productid product.productid

databand's datasource:order

order by: order.order_product.productname

but the data sorting order is not by productname. why?

[Vital]

Hello,

At this moment SR does not support sorting by related field. You can use one trick. Add to report GroupHeaderBand. Set condition equal to related field. Set height of GroupHeaderBand to zero. After then you receive sorting by related field.

Thank you.

[progame]

thanks, it works.