Browse the archive
In SQL Server Reporting Services (SSRS), you can configure the sender address for email subscriptions at the instance level. This means that every email sent from your SSRS server will come from the same address. (On each subscription, you can optionally …
Continue readingToday, my friend Derik Hammer (blog) asked about moving SSRS reports between (versions and) instances of SSRS: Derik Hammer@SQLHammer twitter What is the best way to move 2008 R2 SSRS reports into an existing 2012 SSRS instance? Catalog move is insufficient …
Continue readingQuestion Consider the following: CREATE PROCEDURE dbo.usp_trantest AS SELECT @@TRANCOUNT as trancount; GO When I call usp_trantest manually from within SSMS, the trancount is 0. If I run an SSRS report that contains a dataset that queries the same stored …
Continue readingQuestion I have Native SSRS configured on a 2012 instance (11.0.2100). I have two reports with images that act as buttons to toggle between the chart report and the detail report. I want to configure the action URLs to dynamically pass in parameters when …
Continue reading
