locked
Save filter parameters to a URL RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Is there a way to expose the URL to the SSRS report with the parameters it ran under? 

    Here is the business case I want to solve:

    • User A views a report and uses the parameters to filter it to the Central region
    • User A can get the URL with the parameter encoded in it
    • User A sends URL to User B
    • User B is able to view the filtered report

    Example of the URL I would like to be provided instead of manually created:

    http://[server]/ReportServer/Pages/ReportViewer.aspx?%2fPublic%2fSIE%2fProvincial+And+Regional+Reports%2fAge

    http://[server]/ReportServer/Pages/ReportViewer.aspx?%2fPublic%2fSIE%2fProvincial+And+Regional+Reports%2fAge&rs:Command=Render&Region=Central

    Friday, February 10, 2017 7:56 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Swazimodo1,

    As you know, if we want to pass the URL to another, we have to manually append the selected parameter value to URL so that  the report will run under this default parameter value.

    Based on my research, there is no direct way to save parameter selections to current URL. But you could try to display the URL of current report together with parameter selection in report body, then copy and pass it to another user.

    In your report, create another dataset reference to Report Server database. Here, @ReportName is a report parameter with default value set to Globals!ReportName.

    declare @BaseReportURL varchar(512)
declare @ReplacementForSlash varchar(10)
declare @ReplacementForSpace varchar(10)

	set @BaseReportURL = 'http://localhost/Reports/Pages/Report.aspx?ItemPath='
	set @ReplacementForSlash = '%2f'
	set @ReplacementForSpace = '+'

select [Name] as ReportName
	, [Path] as ReportPath
	, @BaseReportURL + replace(replace([Path],'/',@ReplacementForSlash),' ',@ReplacementForSpace) as ReportURL
from [dbo].[Catalog]
where len([Name]) > 0 and [Name]=(@ReportName)
order by [Path]

    Insert a one column by one row table, set its value to:

    =Fields!ReportURL.Value & "&rs:Command=Render" & "&" & "IterationsDates=" & Parameters!IterationsDates.Value

    If you still have any question, please feel free to ask.

    Thanks,
    Yuliana Gu

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Yuliana Gu Monday, February 20, 2017 10:05 AM
    • Marked as answer by Swazimodo1 Tuesday, April 18, 2017 4:38 PM
    Monday, February 13, 2017 10:31 AM