Hi Joydev,

You would use a "100% Stacked Column" chart to achieve this.

Put the Year in the Category groups and the Criteria in the Series groups.

You can use Show Data Labels...

Hi Kazmerelda,

Is this a matrix you are using?

Changing the language settings for the report will change the way dates are displayed by default.

Click on the design area just outside of the report body and press F4. ...

SQL is never really ideal for this sort of thing, using SSIS would be preferable, however when I want to check if something is a valid number I use TRY_CONVERT...

Whatever mate. Goodnight.

N.b. your coordinates ([COORDS]) should be long-lat for points.

My first post -

Spiff (8/3/2016)

---

I can see what you are trying to do however rather than trying to create the geometry text dynamically you should be using spatial aggregate...

I don't know why you need all that. The query I provided creates the whole linestring - of all the points. If you really need just a linestring...

If you want to to an INSERT or SELECT INTO on a CTE, you just...

wtf indeed. What are you doing with the Import Export wizard now?

You can't export a spatial datatype to a csv - it's a binary format. You don't need...

What won't recognise the string? You can use spatial queries in a report dataset, the SSRS maps require spatial types.

If you need to save the results you can just...

geometry::STGeomFromText() returns an actual geometry spatial datatype from the WKT text you supply.

If you are trying to SET that datatype to a column of VARCHAR it will try to implicitly...

OK, to be fair I was going from the question you posted in the SSRS forum. I thought your problem is that you wanted a linestring from the coordinates...

I have replied in the other thread. The gist is:

Import your data as individual points e.g. (long, lat) if that is how they are recorded.

You can then convert these...

I can see what you are trying to do however rather than trying to create the geometry text dynamically you should be using spatial aggregate functions.

Once you have all your...

Trying to embed javascript charts isn't really worth the trouble IMO, I have tried it. If you haven't seen it, this was the best article I found on subject...