Solved

How do I input a Prompt Value into the title's text of my report?

Posted on 2008-10-23
2
707 Views
Last Modified: 2012-05-05
I have a generic report that is titled "To Date Values for Region(s): ___".  On the report I have a Value Prompt where the user selects a Region (they can select more than one Region).  I want to display the Value Prompt's selection in the title.  So, for exampe, if the user selected 'West' from the Value Prompt the title would then read "To Date Values for Region(s): West"; or, if they selected two values ('East' and 'West') the title would then read "To Date Values for Region(s): East, West".  I think this is done with a bit of Java code, but I don't remember how it's supposed to be written.  I thought it was something like  "</...?Prompt?.../>, but that's not working.  So, can anyone tell me how to code this?
Thanks,
Shawn
0
Comment
Question by:shawn1272
  • 2
2 Comments
 

Author Comment

by:shawn1272
ID: 22791238
I've gotten a single value to display in title, but I'm still missing how to do multiple values.  What I did to get a single prompt value to display in a text line:  After setting up my prompt... 1. I added an additional text box to the end of the text box containing the title.  2. I changed the property value Text Source: Text Type: 'Text' to Text Source: Text Type: 'Report Expression'.  3. In the box below Text Type is now the property Report Expression.  4. Open the Report Expression property and in the Expression  Definition box drag your parameter into it.  You'll see sometthing like  ParamDisplayValue('Region').  

The ParamDisplayValue('Region') will show the value prompt's chosen value in the title line.  However, like I said, I don't seem to be getting how to get more than one value to display.  It is also overriding the value prompt's Mulit Select property.  Help please.
0
 

Accepted Solution

by:
shawn1272 earned 0 total points
ID: 22791486
Got it.  
My prompt variable ?Region? in the Year, Quarter, and Month queries defaulted to 'required'.  I set the prompt variable property to 'optional' for the filters in the Year, Quarter, and Month queries; and, I set the Value Prompt to 'required'.  I am now getting multiple values in my title.  
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

How to increase the row limit in Jasper Server.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

18 Experts available now in Live!

Get 1:1 Help Now