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     [SOLVED] How to run the reports listed in the dropdown list

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] How to run the reports listed in the dropdown list
 Login/Join
 
Puja Shetty
Member
posted
Hi,

We have this new requirement where the user wants to be provided a list of
reports in the HTML dropdown list and when the user selects a particular report
in the dropdown and clicks ok,that report is run and displayed.

For eg,the user is provided with a list of report names in the dropdown like
ReportA,ReportB,ReportC and when the user selects ReportB and clicks Ok,The
ReportB runs and is displayed.Do you have any examples/code for this?

To start with ,I created a HTML page and tried to insert a dropdown list and
clicked on properties.I was populate this dropdown with static values like
ReportA,ReportB etc and click on Parameters tab in the properties and click on
static control values,I only see add ignore value or add values from external
file.How do I add values statically like ReportA,ReprtB

All your help and efforts towards this is highly appreciated.

Regards,
Puja

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.8
Linux
AHTML
 
Posts: 7 | Registered: August 04, 2009Report This Post
Darin Lee
Virtuoso
posted Hide Post
You will not be able to do this with the HTML painter. It is used for launching a specified procedure, passing the parameters that have been populated from that form.

However, there are several different ways you could accomplish this. You could create your own HTML page a couple of different ways to do what you need like just having a list of procedures that contains links that are the URL string to run a fex or you could use javascript to set the variables (like IBIMR_ex or IBIF_ex) needed to launch the procedure.

Probably the easiest way would be to have a shell fex that dynamically -INCLUDEs the appropriate fex based on the value of an &var that references the selected procedure. For example if you select reportA then you could-INCLUDE reportA. It always runs the same shell fex, but that fex includes different code based on what is selected. Now if you have to populate additional parameters for the individual procedures, it sounds like you need to come up with your own menuing application.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Doug
Expert
posted Hide Post
As long as you have a funtioning fex that successfully does a -INCLUDE of an amperVARIABLE (wher "amperVARIABLE" is the legitimate name of a functioning fex), then you should be able to create a static dropdown list of fex names that gets passed to the calling procedure (the one with the "-INCLUDE amperVARIABLE" in it) which is executed via the "run button"... I've done it... And, oddly enough, I need to do it again for my current client in the next week or so.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Puja Shetty
Member
posted Hide Post
Doug,Darin,

Thanks for your response.Could you provide me a sample code using INCLUDE amperVariable so that I get an idea of how to use it.I'm a newbie to webfocus and all your help with this is highly appreciated.

Regards,
Puja


WebFOCUS 7.6.8
Linux
AHTML
 
Posts: 7 | Registered: August 04, 2009Report This Post
Tony A
Expert
posted Hide Post
One of the easiest methods (imho) is to create your combobox and set the values for the options to be the focexec names (e.g. report1.fex, report2.fex etc.). Then on form submission just change the value of IBIF_ex to be the value of the current combobox selection -

document.getElementById("IBIF_ex").value = document.getElementById("combobox1").value;

Simple and effective ... and ... (sorry Darin Wink) can be achieved quite easily from HTML painter (or what ever the name is this month Razzer).

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Darin Lee
Virtuoso
posted Hide Post
Looks like you need to check out the documentation on -INCLUDE and Using Variables. The sample code would be a fex that has

-INCLUDE &fexname

where &fexname is populated from your launch page, It's evident that you need a little better understanding of how both of those concepts work. The information that Doug and I have given pretty much covers all that is necessary to get this to work, except for an understanding of those two basic concepts, which you need to get for yourself.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Darin Lee
Virtuoso
posted Hide Post
quote:
Simple and effective ... and ... can be achieved quite easily from HTML painter


As long as you know the necessary Javascript and how/where to use it. There isn't anything in the painter that would build this for you. The painter is just going to build you a static line that says

input type='hidden' name='IBIMR_fex' value="app/report1.fex"

Sounds like a good option, though. We also use a Javascript technique where the control has an onClick event which calls a function:
function RptSelect() {
if (document.form.RPTFEX[0].checked)
 {
document.form.IBIMR_fex.value="app/report1.fex";
    document.form.IBIF_ex.value="app/report1.fex";
 }
else
if (document.form.RPTFEX[1].checked)
 { document.form.IBIMR_fex.value="app/report2.fex";
    document.form.IBIF_ex.value="app/report2.fex";
 }
 }


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Puja Shetty
Member
posted Hide Post
Thanks everyone.I shall try applying all your tips and advise.

Appreciate all your feedback.

Have a great week!
Puja


WebFOCUS 7.6.8
Linux
AHTML
 
Posts: 7 | Registered: August 04, 2009Report This Post
Tony A
Expert
posted Hide Post
quote:
As long as you know the necessary Javascript and how/where to use it.
Darin,

That's where the forum comes into play - you just get someone to write the solution for you Wink Razzer

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Doug
Expert
posted Hide Post
Good One Tony... that's why I stopped where I did... As Darin said "The information that Doug and I have given pretty much covers all that is necessary to get this to work"... It covers it, right? I need to do something like this myself, and it'll all be done via HTML Layout Painter (I'm still in 713)... Does RTFM fit here?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report 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     [SOLVED] How to run the reports listed in the dropdown list

Copyright © 1996-2020 Information Builders