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.
The reports that need to be developed have selection criterion. I don't want my user to see two files (one fex file and another html file). I want to have only one file per report. I tried to include the HTML code in the procedure between HTMLFORM BEGIN and and HTMLFORM END. If I did this and try to run the procedure only on the second pass correct values are prompted into the HTML controls.
Is it possible to avoid the first pass?
If not possible what are the ways to avoid the end users from seeing multiple files i.e. when they login into MRE they should see just one file(either an HTML or a procedure) per standard report.
Posts: 38 | Location: India | Registered: May 18, 2005
venu, I'm not quite sure what you mean but I think adding a -RUN command on the line before the -HTMLFORM BEGIN may get you what you are looking for. I assume the code in the FEX before the -HTMLFORM BEGIN is creating information to be used for the selection boxes in the HTML? Not sure if this will help but if it a try.
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003
You can have multiple files for each report but only show the Fex. When you are in Web Studio, if you click on the properties of a file, you have a "show on user's list" check box. If you uncheck it, users won't see that file in MRE.
Thanks for all the suggestions. The suggestion 1 did not work. I think webfocus first tries identify all the prompts in the report before it does any thing.
Suggestion 2 does the trick(from the user perspective).
However I found that there is another option in the File==>properties ==>prompt for parameters. If you unckeck this option, webfocus on its own does not show the paramaters. So pass one can be avoided even if you embed your own HTML form (with selction controls) in the focus procedure.
Posts: 38 | Location: India | Registered: May 18, 2005