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.
Hello, I've created the form in maintain and added combo boxes. Currently I don't have value for the combo box. I need populate the value from the report.For example: Fanrpt has a field "Division". I want this field show in my form as combo box. I looked at the help manual, I could n't find anything related this problem..
Please let me know if anyone has suggestion regarding this....
Report output is easily used to populate a stack, but in the case on a combo box, why don't you just load a stack with the values from the DB to populate the combo box?
Kevin
WF 7.6.10 / WIN-AIX
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005
Kevin , Earlier I also tried just like you suggested. But it was just populating the values from the combo box. But I want the report to show when the user selected the value from the combobox.Please let me know if have any other suggestion regarding this....
Hello Alan, I do know it is easy to populating the combobox from launch page to Report.
But I have problem in Maintain form. I have Created a form with combobox with values coming from divisionStack. When I run the application and select the value from the combobox and hit the search button . It should give output from the HTML Stack depends on the user selceted from the combo box. For Example: If I select "Technology " From the drop down and hit the search button. The HTML Stack should only show Technology Division. Please let me know if you have suggestion regarding this problem...
Vijaya When you select a value from the Combobox, you can retrieve it in two ways. The first is to use the notation: Stack().selection, or in your case DivisionStack().Division. That value contains the currently selected item in the combo box. You can THEN pass that value to the procedure performing the Table. For example:
COMPUTE SEL/A10 = DivisionStk().Divistion EXEC REPORT1 FROM SEL Into HTMLStack
In the REPORT1.FEX you would have:
TABLE FILE file PRINT fields WHERE DIVISION = '&1'; ON TABLE PCHOLD FORMAT HTML END -RUN
Notice that we are passing in the variable SEL, but we are retrieving it as &1. Values passed to an EXEC'd procedure are retreived sequentially; &1, &2, etc... Also, since I am assuming that DIVISION is an alpha, the amper value is in quotes. I hope this helps.
Mark Derwin
PS The second way to retrieve the values is by using the SelectedItem parm from the properties sheet, but I would rather use the notation above.
Posts: 663 | Location: New York | Registered: May 08, 2003