Displaying same record twice- SQL Reporting Services

Posted by RyanW on Stack Overflow See other posts from Stack Overflow or by RyanW
Published on 2010-05-25T07:29:07Z Indexed on 2010/05/25 7:51 UTC
Read the original article Hit count: 254

Ok, here's the situation: I need to display the same record in two different sections. stupid i know, but here's why.

The Report I am building is grouped by one Field, called Day. Each record has date/times, an expected arrival date time, and an expected departure date/time.

so, at this point we have something like this:

Day..............Arrival Time..................Departure Time

18/5.............18/5 9.00am.........19/5 11.00am

The boss only wants to show times that relate to the current day in the arrive/depart coloumns (easy enough with expressions), which ends up like this:

Day..............Arrival Time..................Departure Time

18/5..............9.00am.........................-

the next thing he wants is to display the departing time in the correct day 'group', but as you can imagine as soon as you move to the next row, well you move to the next row of the table.

So the question is: is there anyway to display the same record on multiple coloumns? Have i missed something or have i got an unsolvable problem?

NOTE: this is not the only data in my table either. there is (for example) a name coloumn which also needs to be displayed on both days.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2005