Converting Data into a graph - Is this possible?

• HoneyByBee

  Grasshopper

  Points: 10

  More actions

  April 29, 2009 at 6:42 am

  #220682

  Hi! I’m very new to SQL 2005 Sever. I’m wondering if there’s ways to write a query to display a graph showing times – like in Microsoft Outlook. I have data with rooms and in and out room times. I would like a graphic display showing when the rooms were & weren’t occupied. This graphic display would be weekdays, 6am thru to 8pm, on 3 rooms as day, for a month. Is this at all possible? I can query out the data points but I need help on how to get this displayed or even if this is possible. (3 rooms - a day - a colored bar showing when the room was occupied)

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 30, 2009 at 6:34 am

  #986609

  You would need to use SQL Reporting Services or some other reporting solution in order to get charting.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• manolomalaga

  SSCommitted

  Points: 1697

  More actions

  May 4, 2009 at 4:37 am

  #988021

  Hi, you could connect to SQL server from VBA outlook macro code with this example:

  http://www.tech-archive.net/Archive/Outlook/microsoft.public.outlook.program_vba/2007-04/msg00127.html

  or with

  http://www.eggheadcafe.com/software/aspnet/29672759/outlook-2003-vba--sql.aspx

  Then you cold create an appoinment to your calendar with this code:

  http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23159738.html

  Also you could try an application to do this simple like:

  http://www.ankord.com/wct.php