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
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/ (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.