×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Prompt Based on List Of Values

Prompt Based on List Of Values

Prompt Based on List Of Values

(OP)
New to Web Focus.  A consultant set up a report for us that allows user to select terms.  Unfortunately, the list is too big and confusing.  We have a range of terms and there is also a situation where we need to report off of combined terms.  Rather than having the user need to click on multiple terms, we were trying to see how we could set up the list so that the user could select the term or combined term once.  Examples...

Currently the list would be something like:
Spring
Summer
Fall

User would need to click on Summer and Fall, but the way the consultant set up the parameter screen, these items are not sorted/near each next to each other as shown above.

Below is closer to what we'd like:

Spring
Summer
Summer/Fall
Fall

User would only need to click on Summer/Fall if they wanted to see the combined report data.

I created a procedure and hold file that filters down the data to the range of terms that we want the user to see, but not sure how to implement it into the actual report.  

When I tried to edit the parameter prompt, the hold file "LOVTerms" does not show up.

I may be going about this the wrong way, but not sure how to proceed.  The current parameter is based on an oracle sql table (view?) called LOV_ACADEMIC_PERIOD which contains all the terms.

Not sure how much code to put in, so showing the define I wrote and the consultant's parameter prompt.

CODE

DEFINE FILE LOV_ACADEMIC_PERIOD ADD
TERMS/A10=
IF EDIT(LOV_ACADEMIC_PERIOD.VALUE, '$$$$99') EQ '30' THEN
EDIT(LOV_ACADEMIC_PERIOD.VALUE, '9999$$') || '40' ELSE
LOV_ACADEMIC_PERIOD.LOV_ACADEMIC_PERIOD.VALUE;
TERMS_DESC/A40=
IF EDIT(LOV_ACADEMIC_PERIOD.VALUE, '$$$$99') EQ '30' THEN
'Summer/Fall ' | EDIT(LOV_ACADEMIC_PERIOD.VALUE, '9999$$') ELSE
LOV_ACADEMIC_PERIOD.LOV_ACADEMIC_PERIOD.VALUE_DESCRIPTION;
END
Output is like:

VALUE  VALUE_DESC   TERMS  TERMS_DESC
201020 Spring       201020 Spring
201030 Summer       201030 Summer
201030 Summer       201040 Summer/Fall
201040 Fall         201040 Fall


I have 4 cols as I thought that I might need to join to the actual data table in order to be able to grab the single as well as combined terms.

This is the prompt from the report the way it is currently.

CODE

WHERE ( ACADEMIC_PERIOD EQ &TERM.(OR(FIND VALUE,VALUE_DESCRIPTION IN lov_academic_period)).Academic Period. );

Hope it makes sense what I'm trying to do.  If this were SQL it would be something like

Summer/Fall:
Where academic_period between '201030' and 201040'

Others:
Where academic_period = '201030'

-------------
We need to also do combination prompts for other groupings of codes that are not dates or ranges, so hopefully I could apply the technique to the other prompts.
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close