Page 1 of 1

can't sort by related filed?

Posted: Mon Aug 11, 2008 1:43 am
by 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?

can't sort by related filed?

Posted: Mon Aug 11, 2008 3:07 am
by 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.

can't sort by related filed?

Posted: Mon Aug 11, 2008 6:57 am
by progame
thanks, it works.