Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-23
2
Medium Priority
?
716 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
[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
  • 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

715 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