Re: Run control prompt

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

How about some steps??

ac

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Ashish Bhatt
Sent: Friday, September 27, 2002 2:23 PM
To: SQR-USERS@list.iex.net
Subject: Re: Run control prompt


using Application Designer.

----- Original Message -----
From: "Allen Cunningham" <allen.cunningham@SONOMA.EDU>
To: <SQR-USERS@list.iex.net>
Sent: Friday, September 27, 2002 1:41 PM
Subject: Re: Run control prompt


> How do you create a view in PeopleSoft, I've never done this?
>
> 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 12:32 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: Run control prompt
>
>
> Create a view a 'select distinct Assigned_to_Oprid from PS_GRP_AP'
> Then use this view as your prompt table.
>
>
>
>
> |--------+----------------------------->
> |        |          Allen Cunningham   |
> |        |          <allen.cunningham@S|
> |        |          ONOMA.EDU>         |
> |        |                             |
> |        |          09/27/2002 03:19 PM|
> |        |          Please respond to  |
> |        |          sqr-users          |
> |        |                             |
> |--------+----------------------------->
>   >--------------------------------------------------------|
>   |                                                        |
>   |      To:     SQR-USERS@list.iex.net                    |
>   |      cc:     (bcc: Rick Creel/IT/Aon Consulting)       |
>   |      Subject:     Re: Run control prompt               |
>   >--------------------------------------------------------|
>
>
>
>
>
> 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
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
>