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] Cascading Parameters in App Studio

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Cascading Parameters in App Studio
 Login/Join
 
Dave H.
Member
posted
Using App Studio 8009

Trying to create a report where the user selects the 'Sales Rep' as the first 'Dynamic Parameter_1'
Next 'Parameter_2' is an auto populated drop down list of the Customers assigned to the Parameter 1 selected Sales Rep.
The user would then go on to select any other parameter values and run the report.

Right now even after I select the Sales Rep from a drop down list for Parameter_1; the entire list of Customers is still displayed.
I would like to see the contents of the Parameter_2 drop down be populated based on the user drived selection in Prameter_1.

Below is a paraphrased version of a portion of the current WHERE statement which is not dynamic....
WHERE ( Sales_Rep EQ '&SalesRep.(FIND Sales_Rep IN Sales).Sales_Rep:.' ) AND( Customer EQ '&Cust.(FIND Customer IN Sales).Customer:.' );

Any help on how to do this in App Studio would be great!

Thanks.

This message has been edited. Last edited by: Dave H.,


WebFOCUS 8.009
Windows, All Outputs
 
Posts: 13 | Registered: January 15, 2014Report This Post
eric.woerle
Master
posted Hide Post
Dave,

From my understanding the FIND Syntax does not allow for filtering of data. What you would want to do is create a HTML page and chain your drop downs together. Do you have any experience with the HTML Composer?


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Dave H.
Member
posted Hide Post
Yes, I have built Self Service reports using the HTML Composer. But was hoping to build this as an App Studio report since I will also need to do a few report caster jobs against this report as well and was looking to make double use of the report.
Thanks for the suggestion.


WebFOCUS 8.009
Windows, All Outputs
 
Posts: 13 | Registered: January 15, 2014Report 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] Cascading Parameters in App Studio

Copyright © 1996-2020 Information Builders