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     [CLOSED] show hide two set of parameters for user input to webfocus report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] show hide two set of parameters for user input to webfocus report
 Login/Join
 
Abu
Member
posted
Hi I have a different kind of request from our payroll customer. We have a payroll report that runs by year from, year to, pay no from, pay no to. But now she wants to add effective date from and effective date to. She wants to have an opotion in the launch page like 1)by year or 2)by effective date. Then based on either 1) or 2) option these input fields will appear on the launch page, 1) year from, year to, payno from, payno to. For 2) effective date from, effective date to. and then run the report with different selection criteria. How do I design this user interface?

Thanks
Abu

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 14 | Registered: October 27, 2011Report This Post
David Briars
Master
posted Hide Post
The following thread contains an example of hiding/showing user web page controls, based on user triggered events: http://forums.informationbuild...657043036#7657043036

The example uses the jQuery show() / hide() methods.




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
 
Posts: 822 | Registered: April 23, 2003Report This Post
Alex
Platinum Member
posted Hide Post
You can add a Sorting parameter to your report, e.g. &SORTBY, and add a "BY &SORTBY" in the appropriate position. On your Launch page add the &SORTBY with the sort choices passing the sort field to the report.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
JL
Silver Member
posted Hide Post
If you are using the HTML Composer and do not have jQuery to create your launch page, you can use a radio button (say radio1) with the option for (1) by year or (2) by effective date. Then create two panels - panel1 with the year label and the year text field or year dropdown list; panel2 with the effective date labels and the text/calendar fields for start and end date.

You can use javascript to hide the panels:
document.getElementById('panel_name').style.display="none";


You can use javascript to show the panels:
document.getElementById('panel_name').style.display="block";


On the radio button, you can add an onclick event to check the selection made using:
if ( document.getElementById('radio1').value == 1 ) {
  document.getElementById('panel1').style.display="block";
  document.getElementById('panel2').style.display="none";
}
else { ... }


You can also set the x and y coordinates of the panels if you want them to appear in the same spot:
document.getElementById('panel1').style.top=y_coordinate;
document.getElementById('panel1').style.left=x_coordinate;

y and x_coordinate are numbers in pixels


Year(s) of experience in WebFOCUS: 5+. Using WebFOCUS 7.7.03 on Windows platform with Oracle/SQL Server.
 
Posts: 41 | Registered: September 08, 2008Report This Post
Abu
Member
posted Hide Post
Thanks David, Alex and JL. I am trying to implement as JL proposed. I will try the jQuery one also but need to learn the jQuery a bit before that.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 14 | Registered: October 27, 2011Report 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     [CLOSED] show hide two set of parameters for user input to webfocus report

Copyright © 1996-2020 Information Builders