Convert spatial points data to line data for use in Line Layer in SQL Server Reporting Services (SSRS)

I have a query that returns the fields Order, Lat, Long, SpatialData, . SpatialData is a point. I want to create a line layer that draws lines between my points based on the order field. According to http://technet.microsoft.com/en-us/library/ee240828.aspx#LineLayer I need to do something like this: SELECT N'Path' AS Name , CAST( 'LINESTRING( -76.5001866085881 42.4310489934743, -76.4602850815536 43.4353224527794, -73.4728622833178 44.7028831413324)' AS geography) as Route But how do I go from my data to something like that?