Post reply

Enable Report User to Bookmark Report with selected Parameters

  • May 18, 2015 at 3:07 am

    #304107

    Hi there,

    is there a way that I can enable my Report Users to bookmark a Report with his selected Parameters?

    I know that you can add Parameters to the URL if you access the Report via http://.../ReportServer/Pages/ReportViewer.aspx<Report+Parameters>

    But I cannot tell my user to build there own URLs

    Christian

  • May 18, 2015 at 8:59 pm

    #1798890

    Use the parameters to create the URL like you specified and a message or something on how to create a bookmark, favorite, whatever using that string (that's just me thinking out loud).

    The other option, this is something I did recently, is to create a couple tables for storing that user's parameters and build some logic around that in your SSRS report.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • May 26, 2015 at 7:54 am

    #1800562

    You can create a linked report. This allows for the copy to have its own parameters and subscriptions. When the main report updates, the linked one also is updated.

    Here is a good reference:

    http://www.mssqltips.com/sqlservertip/2308/sql-server-reporting-services-linked-reports-example/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply