Search code examples
sql-serverreporting-servicesreporting

Can I use Report Builder 2016 to create reports using SSRS 2014?


Sorry for such a basic question, but google didn't clear up anything. Can I use Report Builder 2016 if I have SQL Server Report Service 2014? Is it compatible?

Thanks in advance.


Solution

  • You can use Report Builder 2016. But if your report server is an earlier version, you'll need to set the TargetServerVersion to SQL Server 2008 R2, 2012 or 2014.

    The TargetServerVersion property is in DEBUG --> Reporting Properties in Visual Studio but I don't remember where it is in Report Builder but it should be similar.

    enter image description here