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     4 Options...one submit.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
4 Options...one submit.
 Login/Join
 
Virtuoso
posted
Anyone have any ideas on Creating a Launch Page�where the user can choose 1 to 4 Focexec Options�hit one Submit, and have the reports run one after the other and then display one after the other to the screen?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
The selected Focexecs could be a drop-down select list or a series of check boxes. The selected Focexecs could then be passed to a single focexec that -INCLUDEs the selected ones.

If the reports are HTML format, then simply run each of the Focexecs one at a time. If the reports are PDF or Excel, create a compound report. The wonders of Dialog Manager will help in all this.
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
But how do I tell them to run one at a time...
I'm just stumped on this.
The reports are in HTML. Any code examples would be great.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
Prairie, your launch page could have one single fex as its ACTION
and that host fex will launch each of the others
Your form will pass, as Francis says, a multi-select variable that is the list of chosen fexes.
If the var name in your list is, say, MYFEX, then
&MYFEX0 would equal the number chosen
(however check the special case where only 1 fex is chosen...i think there's no value for myfex0..argh!)
&MYFEX1
&MYFEX2
&MYFEX3
&MYFEX4 are the names of the other chosen ones.
Your host fex could default them all to blank, to begin.
then your host fex decides to execute them or not with a little bit of dialogmanager.
-SET &DOFEX1 = IF &MYFEX1 IS ' ' THEN ' ' ELSE
'EXEC ' | &MYFEX1 | ' PARM1 = ' | &myparm1 ...etc
...
then
&DOFEX1.EVAL
&DOFEX2.EVAL
&DOFEX3.EVAL
&DOFEX4.EVAL
then
-HTMLFORM BEGIN
!IBI.FIL.MYTAB1;
!IBI.FIL.MYTAB2;
!IBI.FIL.MYTAB3;
!IBI.FIL.MYTAB4;
-HTMLFORM END
...make sure that each of your exec'd fexes in your list of choices makes and saves an htmtable, not just runs live.
The nice thing about -htmlform syntax is that if one of the tables doesn't exist (because your user didnt' select it), nothing postal happens to you! focus just ignores it. Sweet!
Will this idea work for you?
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Virtuoso
posted Hide Post
Thanks...I'll give this a try..
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
I was off putting out another fire, Now back on this...how exactly would you make a Focexec a variable?...I just need a good push on this so a bell will go off and I'll say...oh I get it now.

Thanks
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Guru
posted Hide Post
Prarie, something like this maybe:

-INCLUDE &FEX1
-INCLUDE &FEX2
-INCLUDE &FEX3
-INCLUDE &FEX4

or EX &FEX1 etc

H�kan
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Report This Post
Virtuoso
posted Hide Post
I need this to be mulit-select where all Focexec's selectd run with One submit...and display one after the other. Is that going to be possible in all this?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
As Susannah explained, you have the reports created one after the other and then combine them in one HTMLFORM:

-HTMLFORM BEGIN
!IBI.FIL.MYTAB1;
!IBI.FIL.MYTAB2;
!IBI.FIL.MYTAB3;
!IBI.FIL.MYTAB4;
-HTMLFORM END

If you require PDF or Excel, you will have to make it a Compound Report.
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
yep, see the &DOFEX1.EVAL would be totally blank if the user didn't select that fex...so nothing would happen. See each one of the 4 choices
&DOFEX1.EVAL
&DOFEX2.EVAL
...etc
is either blank or it contains the name of the fex selected together with the EXEC command.
and when you display the output, if there is no table MYTAB1 because the user didn't select FEX1, then focus delightfully doesn't display anything at all. You can do it, we're all encouraging you...
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report 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     4 Options...one submit.

Copyright © 1996-2020 Information Builders