Solved

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

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
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…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

734 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