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     [Solved] Multi Select variable values displayed in an excel report header

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved] Multi Select variable values displayed in an excel report header
 Login/Join
 
Guy
Member
posted
Is there a way to display the selected values from a multiselect variable into the header of an excel report?

I have searched for this but cannot find a posting. It may be that I am not searching properly.

We would like to be able to do this so a report can be recreated or verified if questions arise.

Thank you in advance.

This message has been edited. Last edited by: Guy,


WebFOCUS 7.6.4
Windows XP against an Oracle Database mainly SCT Banner Higher Education ODS and EDW
Various output formats


Guy Brenckle
Budget Analyst
University of Northern Colorado
 
Posts: 25 | Location: Greeley Colorado | Registered: October 08, 2007Report This Post
Darin Lee
Virtuoso
posted Hide Post
Depending on how or what you're using the multiselected values for (filtering, display, etc.) all of those values are in your &variables. So you need to write some Dialogue Manager to put them into manageable form (may require some looping for indexed variables or a STRIP function for those '&var1' OR '&var2' OR '&var3' type strings) and then insert the &variable names in the HEADING section of your report.

If you were looking for some automatic way to do this, there isn't one but there are several ways to get what you're looking for.


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
Waz
Expert
posted Hide Post
What we do is capture the variables, write them to a file and produce a report that is added to the output as a Parameters tab in Excel.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Anoop
Member
posted Hide Post
As Darin Lee, you can use the below loop to store all the values into one variable and then display it in the header.
If your variable name is &VAR

-SET &ALLVAR = '';
-REPEATE ENDREPEATE &CNTR FROM 0 TO &VAR0
-SET &ALLVAR = &ALLVAR | &VAR.&CNTR | ',';
-ENDREPEATE

You can use &AllVAR which contains all the selected values seperated with a "," seperator.


WebFOCUS 7.0.4
Windows XP
HTML
PDF
EXCEL
 
Posts: 7 | Registered: April 01, 2008Report This Post
Guy
Member
posted Hide Post
Darin or Waz,

Do you have an example of code that acomplishes this solution?

I am using the multiselected values for filtering that then creates a report that summarizes the data. Without displaying the multiselected values, you cannot be certian what items are summarized in the report.

I tried to use Anoop's but it just prompted me for &ALLVAR, &CNTR &VARO I am not quite sure how to put the code in to get this to work.

Thanks again in advance.


WebFOCUS 7.6.4
Windows XP against an Oracle Database mainly SCT Banner Higher Education ODS and EDW
Various output formats


Guy Brenckle
Budget Analyst
University of Northern Colorado
 
Posts: 25 | Location: Greeley Colorado | Registered: October 08, 2007Report This Post
Anoop
Member
posted Hide Post
Hi Guy,

Can you paste your code and explain what you want to acomplish.


WebFOCUS 7.0.4
Windows XP
HTML
PDF
EXCEL
 
Posts: 7 | Registered: April 01, 2008Report This Post
<JG>
posted
Guy,

add
-? &
-EXIT

to the beginning of your report, then you can see how your variables are being presented.

it will either be

&VAR 'xx' OR 'yy' etc.

OR

&VAR0 'xx'
&VAR1 'yy' etc.

If it's option 1 then just add &VAR to the heading
If its option 2 then you need to construct it.
 
Report This Post
Guy
Member
posted Hide Post
JG,

Your simple solution was perfect for these reports. Thank you.

I was able to add &VAR in the heading and it worked.

Thanks again.


WebFOCUS 7.6.4
Windows XP against an Oracle Database mainly SCT Banner Higher Education ODS and EDW
Various output formats


Guy Brenckle
Budget Analyst
University of Northern Colorado
 
Posts: 25 | Location: Greeley Colorado | Registered: October 08, 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     [Solved] Multi Select variable values displayed in an excel report header

Copyright © 1996-2020 Information Builders