Update (7/25/16): You should be fine with older versions of Report Server and SSMS 2016/Visual Studio 2015/SSDT, if you do these three things:
- Set the appropriate compatibility level for deployment (TargetServerVersion) in the report project properties.
- Build the report project before deploying (this may also catch some kinds of errors).
- Deploy from the build output directory (bin/Debug by default) rather than directly from the source code directory.
Disclaimer: I have not yet tested this, but the built RDL looks OK.
stackoverflow: Can I control the version of new SSDT reports in Visual Studio?
I only have time for a quick post at the moment, but be aware that if you take advantage of the latest SSMS 2016/Visual Studio 2015 SSDT releases, they do (at last) incorporate the SSDT-BI designer templates. The VS 2015 Report Designer, however, always upgrades the edited RDL file to the 2016 RDL schema. Continue reading →
It has been years since I tried selecting the RS 2012 option that automatically configures Report Server at installation time. I vaguely remembered that there was a good reason never to use it, but I felt like I needed reminding. And there was.
Continue reading →
The weirdness of SSRS dataset stored procedure metadata, explained at last! I have fought this battle in the past and won, eventually, but it sure is nice if you know the enemy. “Evil” is no exaggeration. Dealing with the Evil of FMTONLY from SSRS – SQLServerCentral.
One of my favorite subjects of late. Just watch out if your variable expression makes calls to a custom assembly. It doesn’t always seem to work! SQL Server Reporting Services Report and Group Variable References.
The trick is to stop and start the RS service at the time of day when it should start up. The recycle time is relative to that, not the time that it last recycled… Prevent SQL Server Reporting Services Slow Startup.
In the “better late than never” category… (I missed this because I had given up looking for it. Besides, I am presently trapped in RS 2008 RTM hell.) SQL Server Data Tools – Business Intelligence for Visual Studio 2013 SSDT BI – Analysis Services and PowerPivot Team Blog – Site Home … Continue reading →
Is that ever an understatement. Nevertheless, I have been finding good uses for report and group variables, in those situations where they can be used, which is in RS expressions in specific places. Of course as with any item, a few restrictions do exist in the use of variables. Link: SQL … Continue reading →
This being the day of the Visual Studio 2012 Virtual Launch, I thought I would actually try out the product, which has been sitting in my downloads directory for several weeks. … Continue reading →