Solved

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

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

630 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