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     [CLOSED] Prompted report on defined value
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Prompted report on defined value
 Login/Join
 
Member
posted
I have a report that has two text fields. I want the capability so that the user is prompted to enter one value. The report will return results if either of the two fields has that prompted value. Does anyone know how to do that?

thanks!

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 11 | Location: Tacoma, WA | Registered: August 20, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I hope that you just start using WebFOCUS because this is a very basic question.

Look documents in Creating Content or Reference section : Documentation
Don't know which version you are working with but even the latest version documentation will answer you questions.

You should update your profile to provide which version of WebFOCUS you are using


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2328 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
MartinY,

I appreciate your candor and sending me to a huge documentation.

Yes, it probably is basic for you, but clearly I don't know how, so I posted it here hoping someone could provide some thoughts.

I am assuming you didn't look at my profile, else you would have seen that I am new and indicated that my WebFOCUS version is 8.2.04.

quote:
Originally posted by MartinY:
I hope that you just start using WebFOCUS because this is a very basic question.

Look documents in Creating Content or Reference section : Documentation
Don't know which version you are working with but even the latest version documentation will answer you questions.

You should update your profile to provide which version of WebFOCUS you are using
 
Posts: 11 | Location: Tacoma, WA | Registered: August 20, 2019Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Here is an example. You could run the following code:
TABLE FILE ibisamp/car
PRINT MODEL BODYTYPE LENGTH
WHERE MODEL CONTAINS '&SEARCH'
OR BODYTYPE CONTAINS '&SEARCH'
END  

And then, when prompted enter:

ER

and click the run button. You would see output for search of both fields.


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 173 | Registered: October 19, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Thank you dbeagan!

I was thinking it was that simple also, but had problems getting that to work. My parameter '%SEARCH' didn't retain the values to pass over for some reason.

I ended up combining the values of the two fields into one field using "Define". I was then able to put that "Define" field into a "Simple Parameter".


quote:
Originally posted by dbeagan:
Here is an example. You could run the following code:
TABLE FILE ibisamp/car
PRINT MODEL BODYTYPE LENGTH
WHERE MODEL CONTAINS '&SEARCH'
OR BODYTYPE CONTAINS '&SEARCH'
END  

And then, when prompted enter:

ER

and click the run button. You would see output for search of both fields.
 
Posts: 11 | Location: Tacoma, WA | Registered: August 20, 2019Reply With QuoteReport This Post
Master
posted Hide Post
quote:
My parameter '%SEARCH' didn't retain the values to pass over for some reason


%SEARCH is not a valid parameter. You need to use a leading ampersand ( & ) on parameter names.


Hallway

Prod: 8202M1   Test: 8202M4
OS:
 
Outputs:
 
 
 
 
Posts: 596 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Prompted report on defined value

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