How to achieve the sorted data from BEx report.

[Former Member]

Hi Guys.

I have a report which is having characteristics called customer and posting date.

when i execute that report i want data in assending order of first customer and next posting date.

I have given customer as sorting character in BEx display tab of customer and then i have given Posting Date also in display tab of posting date. But when query is executed its showing as execel will sort.

for ex.

C001 5/29/2007

C001 6/1/2007

C001 6/3/2007

C001 6/3/2007

C001 10/1/2007

C001 10/4/2007

this is how i want see my data

but i am seeing as below

C001 10/1/2007

C001 10/4/2007

C001 5/29/2007

C001 6/1/2007

C001 6/3/2007

C001 6/3/2007

Kindly anyone help me out.

thanks

peter

[Former Member]

Hi peter,

might be silli question, but have you set up postng date according to Key and not according to Text?

Pavel

[Former Member]

Hi,

I hope , you can set the property of Posting date by right click on it in the query designer, to make the report display on the required Sorting order.

With rgds,

Anil Kumar Sharma .P

[former_member188325]

Yes.Normally it works if set sorting order for both chars.Have you set sorting for both chars?