Re: Have SQR-Want to know panel

["Schelske, Steve K." <SKSchelske@AAAMICHIGAN.COM>]

Or here's some SQL that will give you the menu navigation.

Run the following SQL
--NAVIGATION TO GET TO A PROCESS
  SELECT
         B.PRCSNAME
       , C.MENUGROUP
       , C.MENULABEL
       , A.BARLABEL
       , A.ITEMLABEL
   FROM
         PSMENUITEM     A
       , PS_PRCSDEFNPNL B
       , PSMENUDEFN     C
   WHERE A.PNLGRPNAME = B.PNLGRPNAME
     AND A.MENUNAME   = C.MENUNAME
     and prcsname = 'xxxxxxx'

SQCs are included within an SQR program, so you wouldn't be executing them
directly.


-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Allen Cunningham
Sent: Thursday, March 21, 2002 12:41 PM
To: SQR-USERS@list.iex.net
Subject: Have SQR-Want to know panel


If I have a PeopleSoft-deliverd SQR or SQC, and I want to know what panel it
is called out of, what is the best way to find this out??

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Allen Cunningham
Sonoma State University
Administrative Information Systems
allen.cunningham@sonoma.edu
ph 707.664.2052
fx 707.664.2505
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*