Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Optional parameters in IA - how to force them to show
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Optional parameters in IA - how to force them to show
 Login/Join
 
Platinum Member
posted
When I create a report in InfoAssist with an optional parameter, when I run the report, it doesn't prompt me for that parameter. Sometimes I may want to run it with a value in the parameter and sometimes not. How do I force it to show the parameter prompt? I'm sure there is a way to do this I just can't seem to remember/find it.

(NOTE: this is for reports created solely with InfoAssist, no manual coding.)

Thanks!

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


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 142 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
In a purely InfoAssist environment, your only option is to uncheck Optional in the WHERE test. Alternatively, you could create a Designer Page, where Optional Parameters will be exposed in a very nice finished drop down with ALL as the default value.


WebFOCUS 8206, Unix, Windows
 
Posts: 1716 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Just found it -- you have to right-click on the saved report name in the WebFOCUS home page. Open properties and choose the Advanced tab. There is an option near the bottom: "Prompt for Parameters". If that is checked, it will always prompt for parms even if they are optional.

That seems a weird place to put that but this is WebFOCUS! Wink


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 142 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Master
posted Hide Post
quote:
That seems a weird place to put that but this is WebFOCUS!


#BecauseIBI


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 493 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
And what's more, if you make a change to the report, it resets that option so you have to go back and re-check the box! Mad


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 142 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Optional parameters in IA - how to force them to show

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.