Displaying prompt values in order

[stv]

In my report, i am using a quarter filter by prompting values in value prompt.
Here the problem is i just want to sort the values in order.
But the prompt displaying as first,fourth,second and third.
I want it to be like first,second ,third and fourth for each year.

Thanks in advance.

[Darek]

If the names are first, fourth, second and third, than you are dealing with natural text sort. you will need a numerical column for sorting purposes.

[phani1979]

hai.
for that u need to create  four quarter data item and drop in the tabular model and in the properties mention it as sort key, name according to the data required..
say q1,q2,q3,q4, tabular item, we can say them as sort keys, and add them to facts cloumn in query explorer..  and  in report studio drag and drop in report studio beside to the data that should be displayed
try these
sudhakar