1

I would like to show a project timeline in SSRS for a single project record containing a few milestone dates Given the following data set: (Single record) ProjectID (Text) , StartDate (Date), ApprovalDate(Date) , FinshDate (Date)

I would like to create a chart ( Timeline) with each date, having the columnName as the label Like: simplest timeline

Or Anything remotely like it.. It seems Simple, I just can't get it..
I assume I would create multiple series? And maybe use some sort of switch on the Name? Having trouble getting it to work. Even a suggestion on which type of chart to try. I have been trying with a bar, line, and scatter.

Help is appreciated. Thanks!

Sean
  • 55
  • 4
  • Check this link. https://www.advaiya.com/blog/how-to-create-timeline-chart-in-ssrs-report/ You probably have to turn columns into rows using UNION ALL in your query – niktrs Dec 20 '19 at 12:34
  • Thank you for the reply, unfortunately I don't have sql access - only sharepoint list or service. – Sean Dec 20 '19 at 17:01

0 Answers0