?
Solved

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

Posted on 2013-06-21
1
Medium Priority
?
553 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
RCWade earned 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

770 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