LOV not sorted in Infoview

building reports desktopintelligence
1

BOXI, Release 2
I have a date field which sorts fine (in descending order) in DESKI, but when I run report through Infoview, there is no sort. How can I get a descending sort in Infoview just like DESKI…

ldcaudle (BOB member since 2005-10-04)

2

Hi…

Can you force the sort by editing the LOV in designer and adding a sort to the date object , or have you done this already and Infoview is just not behaving ?

richmona :australia: (BOB member since 2003-04-15)

3

I went to the object properties, and edited the sort order for the LOV and it is not behaving in Infoview - just DESKI

ldcaudle (BOB member since 2005-10-04)

4

Hi…

one other thing. did you check the property of the object in designer to set “export with universe” ?

if you have and it still doesn’t work, and if the field is actually stored as a date field in the table, then I have nothing more to suggest other than contact BO support

good luck

richmona :australia: (BOB member since 2003-04-15)

5

sorry, forgot to addd

check the option “export with universe” and then export the universe before testing the Infoview report again

richmona :australia: (BOB member since 2003-04-15)

6

That was it!!! Thanks!

ldcaudle (BOB member since 2005-10-04)