Get user detail in SSRS from Code behind

Question

0.00/5 (No votes)

See more:

Hi Team,
We are using SSRS reports without any filters for the parameters. But our client came with new requirement to filter the parameters (dropdrop) based on the user details. For example, the client dropdown, we will define the cliente ids in user detail table. Now the client dropdown must filter according to the userId and only the assigned clients should get displayed.
How can we achieve this?

Posted 3-May-13 5:17am

Member 10027010

Add a Solution

Comments

joshrduncan2012 3-May-13 13:43pm

Use the selectedindexchanged property and query the db with the filter from the first choice.

Sandeep Mewara 3-May-13 15:36pm

So you want topass parameter to SSRS report now?

Member 10027010 4-May-13 2:08am

Yeah but from code behind. That is I'm sending the user id of the current user and I want to pass this to the SSRS report. In the report ill use this user Id to filter the available values. Pls let me know if I'm not clear on my question.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bhushan Shah1988 · Accepted Answer · 2013-05-03T20:15:00

Solution 1

Hi,

check following articles.

http://bhushan.extreme-advice.com/create-sql-server-report-with-parameters/[^]

http://bhushan.extreme-advice.com/call-ssrs-report-with-prameters-from-asp-net-web-application/[^]

Posted 3-May-13 20:15pm

Bhushan Shah1988

Comments

Member 10027010 4-May-13 9:44am

Thanks it helped out...

Member 10027010 6-May-13 3:53am

Bhusan, With this I was able to achieve the requirement. By this I was able to set the value to the parameter that was already created in the SSRS report. But I just want to know If I can create a new parameter to the SSRS report from the code behind.

Bhushan Shah1988 6-May-13 6:12am

I think its not possible.