How to create SSRS reports (rptproj) using TeamCity and Visual Studio 2015

Question

We have a build step to create a solution with approximately 70 projects using Visual Studio (sln) as the type of runner. We can successfully create other projects that are not supported by MSbuild, for example, vdproj files and office plugins, by doing this. However, it does not seem to work for SSDT / SSRS projects. I made sure that the latest version of SSDT is installed in Visual Studio, and Visual Studio 2015 is installed directly on the build server.

rptproj is not supported by MSBuild and cannot be built

Is there anything else that is needed for proper assembly? I read that some people move them to their own solution, but that’s not what we are here, and I’m not sure that this is actually a problem.

This is important to us because we need assembly output that targets SQL 2008 instead of copying the RDL directly into the project, which is a version of the toolkit (SQL 2016).

Answer 1

You must create rptproj by calling the Visual Studio executable (devenv.exe):

"C: \ Program Files (x86) \ Microsoft Visual Studio 14.0 \ Common7 \ IDE \ devenv.exe" "[full path] \ FooBarSolution.sln" / Rebuild [SolutionConfiguration] / Project KPI / Log "[fullpath] \ Logs \ KPI.Build.Log.log "/ Out" [FULLPATH] \ Logs \ KPI.Build.Out.log "

You must also set the TargetServerVersion property for the SQL Server 2008 project.