Solved

Is there a way in SSRS to assign default report parameters by user?

Posted on 2013-06-21
1
542 Views
Last Modified: 2013-07-01
I have serveral reports which utilize 6-8 parameters.

I have different users from different departments accessing the report.

I am tasked to find a way to create default parameters configured differently for about 5 different types of users.

Is it possible in SSRS?
0
Comment
Question by:rhservan
1 Comment
 
LVL 1

Accepted Solution

by:
RCWade earned 500 total points
ID: 39266273
You can do it via UserID, which you may be able to tie into a grouping system.

Based on UserID:
In the report builder, select the parameter you want to change.

Then under 'Default Values', you can add an expression which uses the Built-In fields of UserID, similar to the expression shown below:

=SWITCH(User!UserID="domain\User1", "Value1", User!UserID="domain\User2", "Value2")

When User 1 runs the report, Value1 will automatically be selected. Of course, you can use other methods in place of SWITCH, but for just a few potential options, its not too bad.

To put this in use based on groups, you could used a query to pull the defaults from another table which contains a username field, group, and default value, and then use the 'Get Values from Query' where you would have to pass the UserID field to find the correct group/default parameter value.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now