reporting services - SSRS Reports - Sort by Date, then by Time using Matrix -

reporting services - SSRS Reports - Sort by Date, then by Time using Matrix -

i'm having problem ssrs reports. here getting currently:

i rid of duplicate dates under "date" column. so, end result be: date                           time                       comments thursday, june 19     12:00                      blah blabh blah friday, june 19           12:00                      blah blabh blah                                     1:29                      blah blabh blah                                     1:30                      blah blabh blah                                     1:31                     blah blabh blah                                     2:30                      blah blabh blah

in summary, goal have type of layout:

date 1    time1    time2    time3 date 2    time1    time2    time3 date 3    time1    time2    time3

i using matrix command on ssrs report. date , time same field. here's info set:

the sec column datetime type.

i saw this msdn article on matricies , has near identical illustration of i'd achieve. see heading "adding parent group..." however, have been unsuccessful in getting work.

thanks!

to accomplish first layout utilize previous function accomplish need.

set look on date textbox as

=iif(fields!date.value=previous(fields!date.value), nothing, fields!date.value)

per definition previous returns previous instance of item within specified scope.

to accomplish final layout.

looking @ output, assuming know whow split date , time. after dataset created. add together table , add together row grouping on datefield. within grouping sort date, time.

reporting-services