Solved

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

Posted on 2008-10-23
2
709 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

How to increase the row limit in Jasper Server.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

773 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