how to display time in crosstab measures area

[cognos74]

Hi,
how to get time in crosstab measures area.

I have order type, date and time columns in my query
order type is row
date is a column
and time needs to be as a measure. I have time like(3:00:00 AM, 9:00:00 PM etc)

here is the example output that I need to show in the report:
                 11/03      11/03
238586       03:00         21:00(this is the time data item that I need to show in the cross tab report)
when I am pulling time into measures it is showing nothing.

can anyone please let me know that how to accomplish this one in the report studio

Thanks in advance

[Michael75]

Hi,

Here's a webinar that shows how to display dates in crosstab cells: http://www.budgetingsolutions.co.uk/news/events/webinar-archive/dates-in-crosstabs-within-reports/

By changing the cast() statement, and the formatting applied to the cells, you should be able to get this to work for time.