SQL Server Performance Forum – Threads Archive

Line chart

Hi, I am trying to create line charts in SQL server 2005 reporting services. Earlier i thought that it is easy to create charts but when i start working on it then i undertood that it is little bit difficult. Well, Can any one help me asap in creating line charts and also i want to diasply alternate dates like jan 01 , jan 03, jan 05 and so on, on X-axis (i placed the date colum under "Drop Category Fields here"). The data in Date column are from Jan01 to Feb 28th. Thanks,
Swetha.

---

See thishttp://msdn.microsoft.com/msdnmag/issues/06/07/DataPoints/default.aspx is any help.
http://technet.microsoft.com/en-us/library/aa964128.aspx too.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Do you want to display alternative dates only in X-Axis and do you need data for other dates.
for example do you want to display data for January 2 and January 4. In that case I don’t think it is possible graph show the all the dates. If you want to eliminate those date and relevant dates, do it from the data set. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

---

]]>