-1

I'm tasked with creating a report in a RLDC that contains a Sunburst chart which is one of the new charts that comes with SQL 2016.

However in Visual Studio 2015 the option to add that type of chart only appears if you add it in a RDL file that is part of a Report Project, and not a RDLC file in a c# project. As this code is run on a web server rather than in than on the reporting server this presents a problem.

Is it possible to add a Sunburst chart to a RLDC? If so how?

RDL Select Chart Type RDL Select Chart Type

RDLC Select Chart Type RDLC Select Chart Type

Manually adding the chart to the RDLC results in an error. Sunburst is not a valid value Error: Sunburst is not a valid value

Taking a RDL and renaming it to RDLC as per Dan Andrews suggestion results in enter image description here

But that then errors out with

The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded.

Dijkgraaf
  • 11,049
  • 17
  • 42
  • 54
  • You could try renaming the RDL to RDLC, you can edit the XML to rip out all off the stuff (like connections) that RDLC's don't have. This may help - or not: https://msdn.microsoft.com/en-us/library/ms252109(v=vs.80).aspx – SQLMason Mar 02 '17 at 03:07
  • @DanAndrews That prompts to convert it to the latest RDLC format and then errors with "The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded. " – Dijkgraaf Mar 02 '17 at 03:10
  • That sucks but worth a shot. I hope someone else has an real answer. – SQLMason Mar 02 '17 at 03:13
  • @DanAndrews Yes I am a bit. But maybe only until they release the Report Viewer 2016 runtime to General Availability (currently in Release Candidate status). – Dijkgraaf Mar 02 '17 at 03:16
  • Maybe this on GitHub? https://bl.ocks.org/mbostock/4348373 or https://bl.ocks.org/maybelinot/5552606564ef37b5de7e47ed2b7dc099 – SQLMason Mar 02 '17 at 03:21

1 Answers1

1

RDLC-style reports are client-side reports that do not require SQL Server. The fact that sunbursts come with SQL Server 2016 is not relevant: the SQL Server version you have doesn't affect your RDLC reports.

You're looking to develop the kind of report that comes with Visual Studio ('local reports'), which will be at the level of RDLC file for Visual Studio 2015. It sounds like the Report Viewer 2016 control will come with functionality that may help.

Rich
  • 2,207
  • 1
  • 23
  • 27
  • Thought it was worth an answer rather than people trying to interpret the comments to your own question. – Rich Mar 16 '17 at 08:10
  • I heard later that they resolved this by upgrading to Visual Studio 2017 for development, then the sunburst is available. – Dijkgraaf Dec 19 '17 at 00:33
  • Or is it more that Visual Studio 2017 includes the Report VIewer 2016 control? – Rich Dec 19 '17 at 15:45
  • Possibly. But I couldn't get it working in Visual Studio 2015 before I stopped working at the client. – Dijkgraaf Dec 19 '17 at 19:26