Plateau Knowledge Services Organization
Eclipse BIRT Designer Version 2.3.0.v20080606 Build <2.3.0.v20080618-0630>
in
ApplicationResources
Copyright (c) 2008 Plateau Systems, Ltd.
DESIGNER NOTES:
KSO created this report for use in training. It is a simplified version of a legacy Plateau report.
Works in Plateau on the admin side.
Display an error message if the admin does not enter any user criteria.
Plateau.Plateau_stylesheet
Account Data with Error Message If Null
/templates/simple_listing.gif
org.eclipse.birt.report.designer.ui.cheatsheet.simplelisting
fixed layout
Plateau.rptlibrary
Plateau
static
string
simple
label.Student
false
text-box
true
Unformatted
oracle.jdbc.OracleDriver
jdbc:oracle:thin:@192.168.126.126:1521:TMS62
plateau
cGxhdGVhdQ==
STUD_ID
STUD_ID
HIRE_DTE
HIRE_DTE
NOTACTIVE
NOTACTIVE
SUPER
SUPER
CITY
CITY
STATE
STATE
RESUME_LOCN
RESUME_LOCN
JP_ID
JP_ID
JL_ID
JL_ID
EMP_STAT_ID
EMP_STAT_ID
DMN_ID
DMN_ID
ORG_ID
ORG_ID
EMAIL_ADDR
EMAIL_ADDR
POSTAL
POSTAL
Active Status
Active Status
1
STUD_ID
string
2
HIRE_DTE
date-time
3
NOTACTIVE
string
4
SUPER
string
5
CITY
string
6
STATE
string
7
RESUME_LOCN
string
8
JP_ID
string
9
JL_ID
string
10
EMP_STAT_ID
string
11
DMN_ID
string
12
ORG_ID
string
13
EMAIL_ADDR
string
14
POSTAL
string
15
Active Status
string
PlateauDataSource
1
STUD_ID
STUD_ID
string
12
2
HIRE_DTE
HIRE_DTE
date-time
93
3
NOTACTIVE
NOTACTIVE
string
12
4
SUPER
SUPER
string
12
5
CITY
CITY
string
12
6
STATE
STATE
string
12
7
RESUME_LOCN
RESUME_LOCN
string
12
8
JP_ID
JP_ID
string
12
9
JL_ID
JL_ID
string
12
10
EMP_STAT_ID
EMP_STAT_ID
string
12
11
DMN_ID
DMN_ID
string
12
12
ORG_ID
ORG_ID
string
12
13
EMAIL_ADDR
EMAIL_ADDR
string
12
14
POSTAL
POSTAL
string
12
15
Active Status
Active Status
string
12
SELECT st.stud_id, st.hire_dte, st.notactive,st.super,
st.city, st.state, st.resume_locn, st.jp_id,st.jl_id,
st.emp_stat_id,st.dmn_id, st.org_id,
st.email_addr,st.postal, DECODE(st.notactive,'Y','No','Yes') as "Active Status"
FROM pa_student st
WHERE 1 = 1
/**AND st.stud_id in [UserSearch] AND [security:PA_STUDENT st] */
"Arial"
100%
AccountData
STUD_ID
User ID
dataSetRow["STUD_ID"]
string
HIRE_DTE
dataSetRow["HIRE_DTE"]
date-time
NOTACTIVE
dataSetRow["NOTACTIVE"]
string
SUPER
dataSetRow["SUPER"]
string
CITY
dataSetRow["CITY"]
string
STATE
dataSetRow["STATE"]
string
RESUME_LOCN
dataSetRow["RESUME_LOCN"]
string
JP_ID
dataSetRow["JP_ID"]
string
JL_ID
dataSetRow["JL_ID"]
string
EMP_STAT_ID
dataSetRow["EMP_STAT_ID"]
string
DMN_ID
dataSetRow["DMN_ID"]
string
ORG_ID
dataSetRow["ORG_ID"]
string
EMAIL_ADDR
dataSetRow["EMAIL_ADDR"]
string
POSTAL
dataSetRow["POSTAL"]
string
Active Status
dataSetRow["Active Status"]
string
1.9166666666666667in
Account
none
asc
row["STUD_ID"]
row["STUD_ID"]
true
false
auto
auto
auto
#8080FF
"Arial"
bold
white
USER
|
|
"Arial"
medium
bold
left
User ID:
|
scroll
0%
0%
repeat
"Arial"
medium
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
STUD_ID
|
"Arial"
medium
bold
left
Organization:
|
"Arial"
medium
ORG_ID
|
"Arial"
medium
bold
left
Job Location ID:
|
scroll
0%
0%
repeat
"Arial"
medium
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
JL_ID
|
"Arial"
medium
bold
left
Hire Date:
|
"Arial"
medium
HIRE_DTE
|
"Arial"
medium
bold
left
Active:
|
scroll
0%
0%
repeat
"Arial"
medium
normal
normal
normal
black
none
none
none
black
none
medium
black
none
medium
black
none
medium
black
none
medium
0pt
0pt
0pt
0pt
1pt
1pt
1pt
1pt
normal
normal
2
none
normal
2
normal
block
auto
auto
auto
false
false
Active Status
|
"Arial"
medium
bold
left
Supervisor ID:
|
"Arial"
medium
SUPER
|
"Arial"
medium
bold
left
City:
|
"Arial"
medium
CITY
|
"Arial"
medium
bold
left
Zip Code:
|
"Arial"
medium
POSTAL
|
100%
#FFFF00
"Arial"
10pt
6pt
6pt
Error message goes here - You must enter criteria to limit this report to one or more users
|
logo.gif
R0lGODlhzAA2APcAAAAAAIAAAACAAICAAAAAgIAAgACAgMDAwMDcwKbK8BYq8Bwk9xgx1hcz5Bk81xxJ
xhxCzyYh8iRtkiZ3gjQu4UcZ4FAxzDxFyU9SvEtcrk1jpFEW2VghzlIhzlZIu1BzjVN/e1J7e1wV01k0
w1tisWYRzl81wGI5u2VDs2RNr28QyW4dwWZtqmqAfXsjt3YttH8/pHdHp3dZpXNgrG50lmh5h3d3m3eF
iXYOxXw8rntvnn56k3+WbnmdXXycZHqkWX+vUXq6PX29QYVhnIVwloV+h4R7hIWHgISEe4WBjYekWYil
YoezUYG+PIjEPopFmotZjoxrlIuEhIuMfY+IioyKl46ec5QHtJYym5R8h5SDhJWNkpKdZ5icd5aak5C5
S5XKO54Fr55clJx0kph7j5yGe56ObJ+Vd5iTjZyVm52kbp6dlZuapaRdm6dyjKJ7aKh4dKV9e6Z6hKeI
ca6kaKWeoaG3TKW2Uq5elK5rhK5tjq1zc66Ka6mmpaynrK2sprhAnrhMqbVKtbVjhbVubbV0W7Nye7OE
ZrWEa7aIVraQYbaTYLGvsbK3ULOyrre1trw1pLg0qr0xtbw4q8FQm71ffr5cisJlcr1sZb1rY72EV7+Z
VbybVr24Ubq4wbvMQb7dLMZAsb4/u8VLhcxXbMNdhMdhV8R3UcSAVsSQU8XSP8LgLsvkLc5Cp89Nlc1e
dNFafM5kY8lpY8h7VNGETM+QTM6MSs/LRM3Nzc/YPNVGe9dEntdMatNWX9ZVc9RlWtNfatvb29bW1tXo
J+A+ft5BiN1Fl99XcNpPi+FeWt+GRN2eQt3cONztKedCc+ZHjuZPTuVLWOZJY+hTR+1Pc+xNeudaTuuP
O+vlMenyIer1JuxJhe5TZe5RbOlTTu9XWe9SWu9aMe9aT+liNutrNvKCOe6PL/SlMuvr6+/3GPT6I/Fu
PPSONvWcM/etL/etKfjlH/r4IPrALP3nJP70Iv7+/vf396OinYCAgP8AAAD/AP//AAAA//8A/wD/////
/yH5BAAAAAAALAAAAADMADYAhwAAAIAAAACAAICAAAAAgIAAgACAgMDAwMDcwKbK8BYq8Bwk9xgx1hcz
5Bk81xxJxhxCzyYh8iRtkiZ3gjQu4UcZ4FAxzDxFyU9SvEtcrk1jpFEW2VghzlIhzlZIu1BzjVN/e1J7
e1wV01k0w1tisWYRzl81wGI5u2VDs2RNr28QyW4dwWZtqmqAfXsjt3YttH8/pHdHp3dZpXNgrG50lmh5
h3d3m3eFiXYOxXw8rntvnn56k3+WbnmdXXycZHqkWX+vUXq6PX29QYVhnIVwloV+h4R7hIWHgISEe4WB
jYekWYilYoezUYG+PIjEPopFmotZjoxrlIuEhIuMfY+IioyKl46ec5QHtJYym5R8h5SDhJWNkpKdZ5ic
d5aak5C5S5XKO54Fr55clJx0kph7j5yGe56ObJ+Vd5iTjZyVm52kbp6dlZuapaRdm6dyjKJ7aKh4dKV9
e6Z6hKeIca6kaKWeoaG3TKW2Uq5elK5rhK5tjq1zc66Ka6mmpaynrK2sprhAnrhMqbVKtbVjhbVubbV0
W7Nye7OEZrWEa7aIVraQYbaTYLGvsbK3ULOyrre1trw1pLg0qr0xtbw4q8FQm71ffr5cisJlcr1sZb1r
Y72EV7+ZVbybVr24Ubq4wbvMQb7dLMZAsb4/u8VLhcxXbMNdhMdhV8R3UcSAVsSQU8XSP8LgLsvkLc5C
p89Nlc1edNFafM5kY8lpY8h7VNGETM+QTM6MSs/LRM3Nzc/YPNVGe9dEntdMatNWX9ZVc9RlWtNfatvb
29bW1tXoJ+A+ft5BiN1Fl99XcNpPi+FeWt+GRN2eQt3cONztKedCc+ZHjuZPTuVLWOZJY+hTR+1Pc+xN
eudaTuuPO+vlMenyIer1JuxJhe5TZe5RbOlTTu9XWe9SWu9aMe9aT+liNutrNvKCOe6PL/SlMuvr6+/3
GPT6I/FuPPSONvWcM/etL/etKfjlH/r4IPrALP3nJP70Iv7+/vf396OinYCAgP8AAAD/AP//AAAA//8A
/wD//////wj+AOsJHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHGkQXbCTKINFDPYo
jcsDwdAlNJkSpcyCNGvGJKizZ82bF3uSHHrQnhQySJNmYeTwgBQ5l4ABi0UojpZHCPGV2cp1qxSgAqWc
GUt27FeBwaaUHdulrdu3XY6AnXgA3427d/EdIMoXLZlWrXYJNuaKCkN7aQxR68aN27fHjwltmVsP37rL
68ppLjdH5UB0UtyJdievtLwznnHRmceanmt68dSp09asNitWq7p4rngAxITfEiR82NuX6CM8gAXvMmbs
rMI0r7pJbwwZcjItcy1j3lxOE9aBwc7+jCZtGrVA1aznvYYtm7Zt3Lov9v49Ifjw4kS3UEo+2JgbXAr1
ccli0zlW3TfiyNJHQdpdxh0tdRB0wCLjmXZaaqu19lpss9XWzG257UbRfMAJRxx+ItlTBGCB9WeJHwkF
Iwc1BDJmYHXiiBOHiA1mtpkyhg3kSCoVlodheutx6N6H8IlIl28l3oeiSMH8xd9yhAV50BbH0CidjQci
KI41UhDUI3fl4EMQGssUWZp59aCnoWtKeghifBaRWJ+JU4p0HIvKMdccZXHmQWON1B2Yozhl7HYmd2UA
JcU5bl54XobqbdienU3KB+WeUvb50RaBANqffwAalAYsh35JjSH+UmhxCWSLKjjQo5t1JhBolI5mIZxy
ZnoLPsQWayw+zvH2qX0nisqRiiwC5gqWxrxokFHVtNoNNVocgA46fhjy2KJk3orZOrPMsZl3aJ3R6yac
/Hqkhrf8MZKezDaEDi7e6hvMATARSqWVgOGRBbXIaDkQLnJk62U3cqQqUB2yiJljowL1OIsUm9Vyj0AT
9kpHvEZeiiQ99d67LJ8CVXEsG/Wgw8YOJJCwQxIC1xNMGknsIEMMROyAz3dDPdJGtGPgQ+0zyQr0SCUO
L/ZKGjhJgWAymGjhnMb4/BjkkL1OQfKb8wprr0j4slzZAw9A4AAESdhTxQUL1B0BBVUQ6on+DiZssIEI
JQReQgx5D0VqtFq7Iugz/xW0atTdGNKsQFsQovUjYHGtjGbsqFkPm73iM7alcWLqWsporxwqPmy7DXcV
DihQ9wIR3F2FQZ7M4LffgAuuggs4j6RiKNHiwwgei1tLkBTVQI6dQbhgfhDXqHAeaWXnULqM6PKaTC8V
a4Qv/vg5P5T26q2/jQ8JCshud+02iBiMDhXs/rfgJaiAwwtUD0w8YJTYAi7csLiEMah5rfLcQ7h2CM7x
ARfo0EI7tMe9kpXuZOpghgZzwUFVfOKDXZCYsuiTr4ylDwI0aED7Zle7CFwARgOpggXqt7veBU5/OBiC
CD1itP+1Ag/+mNPC4pgGFGxBToEO0RgVysC5VDwiPBN0xyYqSDbvZYpOm3qPGnb4JBKqjXVtc4ADGqBC
99GudhRIAnjoR0Pe4Q+HLtiCSEjlwzEASGnMeQbjJAYaBNLoGApriMbuwbFysKMWaziAIqJ4Bi+MDlim
01SHtMhFiZzvRGB02xjLyMIWKlCGFWjjCISWhBXkDweoDN5HhufD5+knj89QXsyYFzVARkRjfygkO64h
hT7UIopT8MMjy5akLDJpixi55K3SN0YHCI0F76tdEexRDxWFkoYcqIJK0FFKHOLgCZPbSDDGEAofeu44
sDTgrmh5KFtCBJdroIUh2SEFKixjguf+0MswrVjMSR6zkhFRpgnDOMYdyOQRGDhj7QyqMzbSUAe7OYAM
VvACoBWBKR/p4f8CeJ4xwJKI6/QjNdy5wHPN4g+P0MQ8y4CPdkxwGWg4wD4vOCf2+PM2yPSUF9FH0Av0
Dx07UGgE4lePA6TgmhvggBo/g48kpCFgIaHj/4C4zo82LmMiJSlOsmLSP+CCD/PkgwQnWIs+yLR7NM0U
NtQAl7dMwUldjBImmZmB79gjCUIlqh88gNQTRAg/rPzfGJ54EnwoTo/PKAUM68FOLyFxIHWpA2VwiQ4m
soMdqeCDS8+xCIDNNFinu4dPTpIRga6NoCTAZF5VslekomCxfRn+ZzmnmhQyeNQYiFVnPagg0m40bWKx
iIUW1sCjrhplnte4xmZRc1YLghZlZwuJaTMpRhZIDB+rrUcaZhjKDaQgnEVrw2yjFaiPglS7sICcHOAq
hWTk6BdlQMNNcMnYa1zWpZudAjqaW8W0ni66IJkuM4masexuF6nfRZFUfdiipSE2Yk6DWqskhxMtWEwc
mPgOfeN5X/zms6ifjSTqpKu6uRKUwJXJbmu7iwKM9iWwDC4vbhGrWLQ0rFXHkCNBGIGJC8MhVfRNaYdd
ClMQo/W5I17IPcTnhSYDtCACPrGjVMzX7vq1IFVw6iMgKBB7UOFYeqGIbMdrKgfrUbfM09b+JRZk43Et
6nmV6Wqc+DDkdpTVyM4VsWhH6xl0HOELX2ACE4DgAwAnJMqaRDF2WzhUlTziqN1VKkGAStEYDIEIhkFH
Ea7A6TCEAQuwhYhGy0neUyFWj85ZlbYih480PIVWOSpXxuRc2Tp3Fs/9fS4z2NpWt0zBETGbAhjA4AQn
COEHhkYIosWo6OzOD6kbgOhAGBEDb8YxZpvu9KdD/ZAFx9jUp4ZwUQ31MBsBIxk4ylGGzYWZk1ZTCnU2
D39J91ws3hQ3d7AXOoRNbGMjuyHLdkCzGU1UbkJbqbhgCRFOiUoYMEXTnL6Cp0H9mZ9QsyhFKOckJgEJ
QICZWHoohsj+i0GMSkg2LIuRhspVHo3qeOPl1piGFBJe2HGMgxzkcHd92YHfdugX16eByb8iae8lgSjf
wR52sY+d7IMEfOAtJDAbRtBdv3FABkSIwQ1RiQMibDPbEt/2pHFB9rLvpCDjnEQkIMF2Mdyj7An/lhb0
SHJi6GLmCWdYylkejb67fBqmQAPc8WFznJ/iHjJZQy14vlnPzfsMeWcEHeABjyva1Oj41je/l/5vhjx9
ygTv8w6q7kbfodIFt8N2xCce6mDA3exg6eHa2T5Ymrue7PgoxqmJIYUDlJ0KvviSNPpOfGi8PEd4Lzvh
cU6OU0gWHY7QBOPbUWSgw+kAk6c8POL+UXROrQLp+1a6v5tukM/fKrsCmXob72f6rvcZ7Kw3yO3JPv+z
S5XjkOi9iExChVHoHrF5wAhwpwW8IA3TQXzRAA0KCA1wsBf2cHuENw6XoXPBMAfTlwrAZn1Hon3bFw91
MgzDgBugcAdvhwubN3674no28S3oYA/mV2Ch9xk7YD/st3U5sFgQp20UJ39w9y1wFwxFIAqzNQkeR38F
8QiDcGrbUAp9sC9lpwWksHKO0XfGZw1w0AdxtysRaHjE5XplYA5g2A6KQByPR0yw4YHqkA3ZUBshuAqg
YAdvdwBHQGxN0ATH9jEp+Hpl1wcltkxSdn4xuEYcUENvlAP9syv+8Cd21/J6MuGEj1AEYtAGktgGYiBA
ZQcUuJAFeZAHg9CJeRAkTngAW5AFl9ALfvcNvUAIUoA589eC+FAIsFgIb7AGyqcJiXCLU9AvB2AGnNCL
nPBW53EGnTCMxEiMjXCMd5CMycgFcXgESvCMdtgDbxcTMmEPJvF6j9ACILCNH/ABNUA0+KAB4pgBGbAD
joIBGOAB6miOaFcFMnACImBDL0AEf/UZRfAE+IiPUMBtXcaIu4ILfRCQfvAIABMTP1iNAJOQACNCoZgG
X1YsVOAHsDd/j0CQB/AIA1l2jNAHftCRjJASCgkwA+GCIRmSj7CRAdkHjCA96PAIfXAP+GD+hz7gLSdB
f99ijbd3ACuZkBWJiSV5cUVVkgiBC2xwLGkAV0EZkjnjhGaHEq93djHjjzhBjS34j5f4LfN3iThpk12W
lVC5EdcIe9SUFk0QBDzwRNUYlnGHlWLpLBLBlHoYl8FwcXCZhZ8hlWo5l2p5iTFTfzexl1+ZENbIguVT
TXnpCEtgbLkIe3lokyzol0C5K1U5aYQZmXxRl3H5lH+ZlTS3l/RHl37Zl/74gIxZTZxJmKjJgqJZmoJp
EgcwBXUoBGWylTZJTbQZd4Ppl2mpmzTRlnzBmVRJmF55E7eZmXzZmFnomZtZmp5pnMk5nAqBDmjwBU7Q
BD9Ai2eXl9/KgpzUGDOAKZdV2ZudaZkgAZwHoZyTxpl66CTaiZxctpp2SZrOqZnwaZcFIQVf0G+LyZzt
6Z2QaZjN+YMXd5snUZgYoRMCkxM2gROPeXsFWhQ1MaAKOqA/UXF8hqCGmRL2WQ/3kJ9OsATfoaAxIaEp
MZk4WaIMmhNmZ5knuqBu+aIicY1nFwxWAAZM4AUwmqM6WhxMGRNHsARrQJ47OqRECpY1iQtrkIFFuqRM
uhEn2qRQGqVSOqVUWqVWeqVYmqVauqVc2qVeyhcBAQA7