Skip to Content
0
Former Member
Dec 12, 2011 at 10:39 AM

Date Sorting in Report Filter

108 Views

Hi Everyone,

I need to get your expertise help on timekey issue.

1. My database is MSSQL 2008. When I set my timekey as datetime data type, it will go to universe as date object type. If I set timekey as date data type, the parsing will not be compatible. Universe Designer only allow me to set object type as character, not date. How can my universe recognize date type in this case?

2. In my webi report, I need to add 1 timekey filter in Report Filter Toolbar. This timekey filter should have the format dd-MMM-yy and sorting should be in desc/asc time order. When I user FormatDate to change the format, it will give me a string and the sorting will not be in time order. If I user ToDate to convert it back to date, it will give me the format mm/dd/yyyy hh:mm:ss. How can I change the format of the timekey filter yet still be able to sort the value in asc/desc time order?

I can apply for column in table in report part by right click on the column and format number but I cant do anything with the filter since there is no format setting in filter.

Please enlighten me! Thank you in advance!

Mandy