SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS text box to display parameter choice
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

robert693
Starting Member

USA
42 Posts

Posted - 03/01/2013 :  09:24:49  Show Profile  Reply with Quote
Hello,

I have an SSRS report with a parameter that gives the user several choices from field called "Department." The choices are "(Select All)." "Information Technology," and "Process Improvement." The choice will decide what information is shown on the report. We need a text box on the report to show what choice the user made, "Information Technology," "Process Improvement," of if the user selected "(Select All)," then both "Information Technology" and "Process Improvement" should show up in the text box. I have tried various IIF() statements and could not make tis happen. Can somebody give me advice as to how to accomplish this? Thank you for any help!

James K
Flowing Fount of Yak Knowledge

3724 Posts

Posted - 03/01/2013 :  09:40:16  Show Profile  Reply with Quote
You should be able to use an expression such as =Parameters!Department.Value and that should automatically populate the text box based on your selection. Does that not work for you?
Go to Top of Page

robert693
Starting Member

USA
42 Posts

Posted - 03/01/2013 :  09:59:31  Show Profile  Reply with Quote
I found that I could use a join() function and get what I needed. ="Department: "&join(Parameters!Department.Value, " and ")
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000