I need help creating a Line Chart in SSRS 2008. My Data is formated from the database in the form: tdstamp, data001, data002, data003 and so on. These fields represent the day and the aggregrate number of items per hour( data001 is 8 am, data002 is 9 am...). I have used the Report Parameters function so I am able to drill down and find the data for a specific day. I need my line chart to so show the Hour on the X-axis and the value of dataXXX on the Y-Axis. Any help is appreciated. Thanks. By theway, how do I attach pictures? I can show screenshots.

Hi thisbetheduck, If you need the line chart to show the Hour on the X-Axis and the value of the dataxxx on the Y-Axis just like you mentioned, as long as you get the dataset which includes relevant datafields from the database, the line chart could achieve this requirement completely, for more information about chart control you could click these links: 1. Get More Out of SQL Server Reporting Services Chartshttp://msdn.microsoft.com/en-us/library/aa964128(SQL.90).aspx 2. Beginning SQL Server 2005 Reporting Services Part 3: The Chart Control http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-3-the-chart-control/ If I misunderstand you, you could upload your report picture to the SkyDriver at this link: http://skydriver.live.com And then point to the URL in the posts. You could also paste pictures in the post using the following steps: 1. Upload the picture to a website ‘s photo place holder at http://skydriver.live.com 2. View the picture in the website. 3. Right-click the picture, and select “Copy” 4. In reply window, select “Paste” to paste the picture into a post. If you have any question, please feel free to ask. Regards, Challen Fu

Sorry it been awhile for my reply. I forgot about the thread. I've attached some pictures of the database query/dataset and what the report looks like in excel. From what I've seen about the charts, they all take the database table columns as "what is being charted" and charts the individual row data entries below it. I want to take specific data data from one row of the database and chart it. My line chart needs to take the data001, data002, etc data of a specific timestamped row and display that data as one line. Thanks.