Hi gurus,
In cross tab i defined query calculation called "status", and it has 3 values s1,s2,s3.
where am displaying how many requests placed in a particular status..
when i run the report in the output it is displaying the status not in serial order.it is displaying like s2,s1,s3
how would i display them in serial s1 s2 s3.
thanks in adv
Can you just sort the column?
hi wyconian, if i sort the column the values in the column will be display in order.
here the below am giving an example
my output coming like this
S2 S1 S3
12 23 45
but it has to come like
S1 S2 S3
12 23 10
so here i want to display the S1 S2 S3 in a order...
Try this out
create a sort key Column If(dataitem='s1' ) then (1) else If(dataitem='s2' ) then (2) etc .
then go to edit layout sorting . in that under Detail sort list , first add sort key , then add dataitem.
Hi Prince,
Thanx for ur reply. i have created a column and defined as u told. then done the sorting. after that also i didt get it.
could please explain me steps in detail. i will try again..
Thanx in adv
Hi Prince,
I got it, i did a mistake. that i fixed. now i got the required output. once again thanks prince.
hi
it has nothing to do with the sort, you just have to place the data items in that order
S1 S2 S3 in the report page, I mean you just have to reorder them the way you want in the report page, and it should solve the problem.