How to create a gantt chart for event rooms during a day

• PatrikW

  Valued Member

  Points: 62

  More actions

  January 27, 2021 at 11:41 am

  #3837961

  Hi all,

  This will be my first ever post in a forum like this. But searching around the web and been spending to many hours allready, I tried finding a great community to join.

  Scenario - I`m working for a customer that are running some big event properties, they are lacking a good gantt chart overview for each conference/event inside their system and wanted us to create it in report builder for their SSRS solution.

  One conference (can run over multiple dates) can have many events (the event can only be on one date).

  The events holds conference room, servings, date and the start and end time.

  for example

  Conference XY have 2 events

  - Meeting Event in room conference room 1 between 08:00 and 16:00

  • and a break event in conference room "Break area A" between 09:30-11:00.

  they would like the Gantt chart to start the same as the first event starts that day (this case 08:00) and the chart should end when the last event ends (in this case 16:00)

  Ifthe conference is over multiple dates, then the next date follows.

  This is what they would like

  

  and I have a dataset that looks like this

  

  

  This is showing all information that is needed. But man oh man, I can not in my life figure out how to do this. Only examples I find is for bigger projects, running over weeks, months and years.

  So if someone can help out I will of course give all information needed.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  January 28, 2021 at 12:10 pm

  #3838333

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.