Wednesday, 15 April 2015

reporting services - SSRS Retaining Certain Parameters from URL -


I created a report that requires three parameters (all of which are integers):

    Month
  • Year
  • StaffID

The parameter StaffId is defaulted from a dataset and is hidden.

I am creating a URL from one report to another, just like adding the following:

  http: //  

Note - The server and report name is clearly specified in the URL!

The problem I am facing is that, when the above report runs, if I do month or year parameter, The StaffID has also been updated with the dataset associated with it, which is not the behavior that I would like.

What would I want to do that should not be changed / updated with a dataset if the employee ID is specified in the URL? I still want that user to month and year . Does anyone know how to achieve this?

I have information about refresh parameters in Advanced parameter options but it has an option for expression.

Edit

I tried to use the 'Refresh' option but it still seems to refresh if it makes a difference There are dependencies on the parameters.


No comments:

Post a Comment