Focal Point
A decoded List of customers

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5611068632

July 13, 2007, 02:35 PM
rfbowley
A decoded List of customers
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
July 13, 2007, 03:26 PM
FrankDutch
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

July 16, 2007, 11:42 AM
Darin Lee
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