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.
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, 2005
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.
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, 2003
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, 2005
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, 2005
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, 2003