Re: Run control prompt

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

Allen,

There is certainly more to creating views than just the step by step how
to.  Chris has it here, but a good source for PeopleSoft questions is
PeopleBooks also.  Failing PeopleBooks
http://groups.yahoo.com/group/peoplesoft-fans is the PeopleSoft equivalent
to this Users Group.

You have to understand that to trained consultants what you are doing makes
as much sense as step-by-step bomb disposal. There is a lot that can go
wrong when you don't know what you're doing.

-Alan.




                    Chris Bennett
                    <chris@SYMBIOI        To:     SQR-USERS@list.iex.net
                    NC.COM>               cc:
                    Sent by:              Subject:     Re: Run control prompt
                    "Discussion of     Expire On:
                    SQR, Brio
                    Software's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


                    09/27/2002
                    05:53 PM
                    Please respond
                    to sqr-users





Allen,

Probably just about everyone on this mailing list could answer your
question (even though it is a very PeopleSoft specific question and this
is, obstensibly anyway, an SQR list), but I really think you should
consider taking a PeopleTools class.

For one thing, this is a very basic element of working with PeopleSoft,
and this list would get very noisy if everyone just asked every simple
question here instead of taking classes.  But also very importantly, if
you get step by step instructions here to do this one task, without
understanding what you are really doing in the "big picture", you could
end up severely damaging your system.

So please take a course, or hire a consultant to help you out.  That said,
this is what you do to create a view: open a new record, add the fields
that need (must match the columns in the SQL), select 'View' as the record
type in the record properties, click on the 'View SQL' button, paste the
SQL into there, save the record, and build it.

Chris


On Fri, 27 Sep 2002, Allen Cunningham wrote:

> 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
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
>