Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     A decoded List of customers

Read-Only Read-Only Topic
Go
Search
Notify
Tools
A decoded List of customers
 Login/Join
 
rfbowley
Platinum Member
posted
From a multi select listbox in a launch page, a list of customer ID numbers is used in the fex in a where statement. HTML Painter and Where clause assit works perfectly to do this. The problem I have is that the final report output does not contain the custmer names corresponding to this list of customer ID's.

The end user wants to see these customer names in the header IF there are no more than 10 of them. If the user selected the "All option, he wants to see "All" in the header. If he picked more than 10 Customers, then teh header should contian "Multiselect" but for 1 to 10 customers, he wants to see the concatenated string of the customer names in the ehader.

Any Ideas?

Bob


Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC

In WebFOCUS since 2001
 
Posts: 132 | Location: Gadsden, Al | Registered: July 22, 2005Report This Post
FrankDutch
Virtuoso
posted Hide Post
Based on the selection you can go to a labeled section in your FEX and if the number is less then 10 it runs a small fex to read the 10 customer names.
You put the names in a alpha hold file and branch through that file with a -READ for each record.
Create an amper value that does something like this.


-AGAIN
-READ HOLDFILE &STRING1
-SET &LONGSTRING=&LONGSTRING||','||&STRING;

You have to search how you do the looping, I do not know it by hart, but you can do this till the end of the hold file.
Use the &LONGSTRING in the heading of the report.

I hope this helps you a bit




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Darin Lee
Virtuoso
posted Hide Post
Dialogue Manager will probably be the only way to go for this one. We use Franks's technique in some cases. For others, we do the following. Instead of using the simple lookup you get with the Painter, we execute a fex which prepares the values for the list box. The display value looks the same, but the passed value contains both the customer number and the name. That way we already have everything we need for displaying selected parameter values. Then we use DM to mask off whatever portion we need to use - either the number or the name. You would also have to use DM to determine the logic to display "ALL", selected values, or "MULTISELECT."


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     A decoded List of customers

Copyright © 1996-2020 Information Builders