Re: Run control prompt

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

But if I did it this way, then the end-user would still be presented with
ALL oprid's, and I would like them to be presented with ONLY the oprid's
that exist in PS_GRP_AP.

ac

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Rick_Creel@AONCONS.COM
Sent: Friday, September 27, 2002 10:47 AM
To: SQR-USERS@list.iex.net
Subject: Re: Run control prompt


Within the SQR itself, could you use a sub-select to get the OPRIDs from
PS_GRP_AP?
That way the end user doesn't have to input any OPRID at all.

example:

begin-select
t1.field1
t1.field2
    do some_procedure
from tableone t1
where blah-blah
and t1.oprid in (select ap.Assigned_to_Oprid
                           from PS_GRP_AP ap
                           where ap.Assigned_to_Oprid = t1.oprid)
end-select







|--------+----------------------------->
|        |          Allen Cunningham   |
|        |          <allen.cunningham@S|
|        |          ONOMA.EDU>         |
|        |                             |
|        |          09/27/2002 01:34 PM|
|        |          Please respond to  |
|        |          sqr-users          |
|        |                             |
|--------+----------------------------->
  >--------------------------------------------------------|
  |                                                        |
  |      To:     SQR-USERS@list.iex.net                    |
  |      cc:     (bcc: Rick Creel/IT/Aon Consulting)       |
  |      Subject:     Run control prompt                   |
  >--------------------------------------------------------|





I would like to use 'Assigned_to_Oprid' field from PS_GRP_AP as a run
control prompt. It contains all of the oprid's of the data entry people who
have entered vouchers. However if I drag this field on to my run control
panel it becomes a single-entry input field rather than a drop-down. I don't
want to make the end-user have to know what oprid to type in, is there any
way to make it a drop down so that it populates with all of the
assigned_to_oprid's that are stored in the table??

Using:
P/S 7.5
SQR 4.3.4
Oracle 8i
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Allen Cunningham
Sonoma State University
Administrative Information Systems
allen.cunningham@sonoma.edu
ph 707.664.2052
fx 707.664.2505
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*