Post reply

Is it possible to build a Timeline report?

  • August 23, 2010 at 4:50 pm

    #237082

    I'm tasked to building a report (using BIDS 2008) of a schedule laid out in a timeline.

    I'm just curious if it's possible. Similar to a MS Project Schedule layout

    Thanks

  • August 30, 2010 at 12:09 pm

    #1213876

    I was able to figure this out about a week ago and wanted to share my experience.

    1. I basically used a table layout with fixed times on the columns (I wish I could somehow generate time instead of hardcoding the time in each column in report builder/bids 2008)

    2. I then used IIF expressions in the fields to put a space or a nonspace character to mark the column if it falls into the time on the column header.

    3. In the background color propery for the column used a SWITCH expression to color in a bar like and basing the color on the type of meeting/event.

    I'm not sure if this is the best way to do it but its the only way I can think of. Final result:

  • August 31, 2010 at 7:58 am

    #1214311

    A common solution in data warehousing is to build a calendar table and a time table.

    In your case if you built a table with all the time values you want, that might prevent you from hard coding the values.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply