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     [CASE_OPENED] Dynamic Prompt behavior different in WF8 from WF7.7.03

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE_OPENED] Dynamic Prompt behavior different in WF8 from WF7.7.03
 Login/Join
 
eric.woerle
Master
posted
I have moved over a series of reports from my WF7703 environment that were made by my users using infoassist to WF8.0.08. I've noticed that the prompting works differently between the two versions. The syntax is the same 
 '&variable.(FIND return_fieldname [,display_fieldname] IN datasource).[description.]'


But in WF7, the prompt will return the distinct records where in WF8 it is returning all of the records as if its doing a Print instead of a SUM/BY. Is there a setting or parameter that needs to be adjusted in the WF8 to have the same functionality as in WF7?

Thanks!

This message has been edited. Last edited by: eric.woerle,


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
eric.woerle
Master
posted Hide Post
I've done some more digging on this. It appears that in WF 8, the change has been made that if you only supply the [return_fieldname] it will issue a print verb, but when you add the [display_fieldname] WF will issue the SUM verb. In WF7 it was always the SUM verb that was issued. Now as a developer I can handle this because I know how to code it, and I use HTML pages and reference procedures for all of my reporting. Unfortunately, my users that utilize InfoAssist can't do this. InfoAssist does not provide the ability to select both the return_fieldname and the display_fieldname. What makes it worse, when you update the code with the display_fieldname, IA no longer recognizes the code and errors out when trying to open the fex for editing.

Is anyone aware of any SET command or configuration that would allow for me to revert that functionality back to WF7? So the prompt command always issues a SUM verb?


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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE_OPENED] Dynamic Prompt behavior different in WF8 from WF7.7.03

Copyright © 1996-2020 Information Builders