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     All option in Dynamic Prompts

Read-Only Read-Only Topic
Go
Search
Notify
Tools
All option in Dynamic Prompts
 Login/Join
 
<Sengott>
posted
HI,

I had developed an report which contains a pair cascading prompt from 1 table and one more pair of cascading prompt from other table.

For my report i should have All option as a default in all the prompt.

but when i try to include "ALL" option in the prompts by selecting the All option in the parameters tab ( available in properties) and then run the report i get a wrong result, i.e when i select ALL any one of the prompt and then run the report i get an output as though ALL option is selected for all the 4 prompts.

I tried to do some mannual coding but i was not successful.

I have also have to implement drill down in my report.

My other problem is when i select ALL option my drill down does not work, if i dont select all optin the drill down works.

I am fetching my value for the prompts dynamically.

Kindly help me with a suitable solution
 
Report This Post
texascyclone
Member
posted Hide Post
The 'ALL' option returns FOC_NONE. Try to look into this link and see if it will help you.

https://forums.informationbuilders.com/eve/forums/a/tpc/...781098331#1781098331

Good Luck!
 
Posts: 24 | Registered: June 16, 2006Report This Post
Piipster
Guru
posted Hide Post
Remember that FOC_NONE causes the entire line that it appears on to be ignored. Put your WHERE statements on separate lines.

WHERE field1 EQ '&VAR1';
WHERE field2 EQ '&VAR2';


ttfn, kp


Access to most releases from R52x, on multiple platforms.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
<Sengott>
posted
Thank you guys for your reply.

Now I am able to get proper report output, when i select all.

But i think you missed my other question

Question : If i select All option in any one of the prompt the Drill down does not work,
How to overcome this problem

Kindly give me a sutiable solution

Regards
Sengot
 
Report 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     All option in Dynamic Prompts

Copyright © 1996-2020 Information Builders