Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dberror

Status
Not open for further replies.
sudha001

sudha001

Programmer
Joined
Nov 15, 2006
Messages
6
Location
US
Hi,

When retrieving an sql, the dberror event of the datawindow gets triggered with sqlcode "2" and the sqlerrtext saying "Select error:" (no other description). I run the sqlsyntax(captured in the dberror and sqlpreview events) being submitted, against Oracle(in toad) and it runs fine. So there is nothing wrong with the sql. Anyone knows whats happening? March of this year, someone called Richard got a similar problem, if he reads this, can he tell me what the solution/problem was?

thanks,
Sudha
 
Sort by date Sort by votes
Hi,

a very abstract question.
If you could post the qery and db-table definitions the query is using plus the exported datawindow code It would be esear to examine your problem

Bernd
 
Upvote 0 Downvote
Hi,

Sorry about this long post..could not find a way to make it a hyper link..anyways..

below is the sql being submitted

Code: 
 SELECT	DISTINCT "JOB"."JOB_ID" "JOB_ID",  
			"JOB_CONTROL_SECTION"."CS_NUM" "CS_NUM", 
			"JOB_CONTROL_SECTION"."STRT_MP",
			"JOB_CONTROL_SECTION"."END_MP",
			"JOB_CONTROL_SECTION"."RTE_NAME" "ROUTE",
			"OBLG_LOG"."PFS_TYPE_CD" "PFS_TYPE",
 			"JOB"."RPT_LOC_DESC" "LOC_DESC", 
			"JOB"."CONSTR_LENGTH_QTY" "MILES",
			"JOB"."RPT_WK_DESC" "WK_DESC", 
			"JOB"."WK_TYPE_CD" "WK_TYPE_CD", 
			"JOB"."SCHLD_LET_DATE" "LET_DATE", 
			"JOB"."MDOT_REGN_CD" "REGN_CD", 
			get_code_desc('MDOT_REGN_CD',"JOB"."MDOT_REGN_CD") "REGN_DESC",
 			"JOB"."MDOT_CNTY_CD" "CNTY_CD", 
			get_code_desc('MDOT_CNTY_CD',"JOB"."MDOT_CNTY_CD") "CNTY_NAME", 
		   "PHASE"."PHAS_ID" "PHASE_ID", 
			"PHASE"."TMPL_CTG_CD" "TMPL_CD", 
			DECODE("JOB"."JOB_TYPE_CD",'T',get_code_desc('PHASE_TMPL_CTG_CD',"PHASE"."TMPL_CTG_CD"),'L',get_code_desc('LOCAL_TMPL_CTG_CD',"PHASE"."TMPL_CTG_CD"),' ') "TMPL_DESC",
			"PHASE_FINSYS"."FIN_SYS" "FIN_CD", 
			"PHASE"."PHAS_TYPE_CD" "PTYPE_CD", 
			DECODE("OBLG_LOG"."PFS_TYPE_CD",'F',"OBLG_LOG"."FA_CD",'S',"OBLG_LOG"."SA_EXPN_ACCT_CD",'L',"OBLG_LOG"."AO_TYPE_CD",'S') "FA_CD", 
			"OBLG_LOG"."SYST_ROW_TMSP" "SYS_DATE", 
			("OBLG_LOG"."END_AMT" - "OBLG_LOG"."BEG_AMT") as "TRANS_AMT", 
			get_code_desc('TRNS_TYPE_CD',"TRNS_LOG"."TRNS_TYPE_CD") "COMMENT" ,
			"JOB_CONTROL_SECTION"."CS_MAJ_IND",
			"JOB_PHYSICAL_REFERENCE"."PR_NUM",
			"JOB_PHYSICAL_REFERENCE"."PR_BEG_MP",
			"JOB_PHYSICAL_REFERENCE"."PR_END_MP",
			"JOB_PHYSICAL_REFERENCE"."PR_MAJ_IND" "PR_MAJ_IND"
 FROM		"MAP"."JOB", 
			"MAP"."JOB_CONTROL_SECTION", 
			"MAP"."PHASE",
			"MAP"."PHASE_FINSYS",
			"MAP"."OBLG_LOG", 
			"MAP"."TRNS_LOG",
			"MAP"."JOB_PHYSICAL_REFERENCE"
 WHERE	( "MAP"."OBLG_LOG"."JOB_ID" = "MAP"."JOB"."JOB_ID") 
 AND	   ( "MAP"."OBLG_LOG"."JOB_ID"	= "MAP"."JOB_CONTROL_SECTION"."JOB_ID" )   
 AND		( "MAP"."OBLG_LOG"."JOB_ID" = "MAP"."PHASE"."JOB_ID")
 AND      ( "MAP"."PHASE"."FUND_RLTN" NOT IN ('STDCHD','STPCHD'))   
 AND		( "MAP"."OBLG_LOG"."PHAS_ID" = "MAP"."PHASE"."PHAS_ID")  
 AND		( "MAP"."PHASE_FINSYS"."JOB_ID" (+) = "MAP"."PHASE"."JOB_ID")  
 AND		( "MAP"."PHASE_FINSYS"."PHAS_ID" (+) = "MAP"."PHASE"."PHAS_ID")  
 AND		( "MAP"."PHASE_FINSYS"."MAJ_FIN_FLAG" (+) = 'Y')  
 AND		( "MAP"."OBLG_LOG"."TRNS_NUM" = "MAP"."TRNS_LOG"."TRNS_NUM") 
 AND		( "MAP"."OBLG_LOG"."ENTY_TYPE_CD" = 'PFS') 
AND		( "MAP"."JOB"."JOB_ID" = "MAP"."JOB_PHYSICAL_REFERENCE"."JOB_ID" (+)) 
 AND  ( DECODE("OBLG_LOG"."PFS_TYPE_CD",'F',SUBSTR ("OBLG_LOG"."FA_CD" ,1,2),'S',SUBSTR ("OBLG_LOG"."SA_EXPN_ACCT_CD" ,1,2),'L',SUBSTR ("OBLG_LOG"."AO_TYPE_CD",1,2)) NOT IN ( '0A', '0B', '00'))  AND ("OBLG_LOG"."END_AMT" - "OBLG_LOG"."BEG_AMT") > 0   AND ("MAP"."JOB"."MDOT_REGN_CD" IN ('02'))  AND ("MAP"."OBLG_LOG"."SYST_ROW_TMSP" BETWEEN To_date ('06/01/2006','mm/dd/yyyy') AND To_date ('07/30/2006','mm/dd/yyyy'))  AND (  "MAP"."PHASE"."PHAS_ID" = ' ' OR  "MAP"."PHASE"."PHAS_ID" = 'C' OR  "MAP"."PHASE"."PHAS_ID" IN( 'D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y') OR  "MAP"."PHASE"."PHAS_ID" = 'A' OR  "MAP"."PHASE"."PHAS_ID" = 'B' ) AND "MAP"."JOB"."JOB_TYPE_CD"  IN ( 'T')

And below is the exported dw source code

Code: 
release 9;
datawindow(units=0 timer_interval=60000 color=16777215 processing=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 1 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no )
header(height=804 color="536870912" )
summary(height=464 color="536870912" )
footer(height=0 color="536870912" )
detail(height=52 color="536870912" )
table(column=(type=decimal(0) updatewhereclause=yes name=job_job_id dbname="job.job_id" )
 column=(type=char(5) updatewhereclause=yes name=job_control_section_cs_num dbname="job.cs_num" )
 column=(type=decimal(3) updatewhereclause=yes name=job_control_section_strt_mp dbname="job.strt_mp" )
 column=(type=decimal(3) updatewhereclause=yes name=job_control_section_end_mp dbname="job.end_mp" )
 column=(type=char(30) updatewhereclause=yes name=job_control_section_route dbname="job.route" )
 column=(type=char(1) updatewhereclause=yes name=cpfs_type dbname="job.pfs_type" )
 column=(type=char(30) updatewhereclause=yes name=job_loc_desc dbname="job.loc_desc" )
 column=(type=decimal(3) updatewhereclause=yes name=job_miles dbname="job.miles" )
 column=(type=char(30) updatewhereclause=yes name=job_wk_desc dbname="job.wk_desc" )
 column=(type=char(3) updatewhereclause=yes name=job_wk_type_cd dbname="job.wk_type_cd" )
 column=(type=datetime updatewhereclause=yes name=job_let_date dbname="job.let_date" )
 column=(type=char(2) updatewhereclause=yes name=job_regn_cd dbname="job.regn_cd" )
 column=(type=char(4000) updatewhereclause=yes name=lookup_regn_desc dbname="regn_desc" )
 column=(type=char(2) updatewhereclause=yes name=job_cnty_cd dbname="job.cnty_cd" )
 column=(type=char(4000) updatewhereclause=yes name=lookup_cnty_name dbname="cnty_name" )
 column=(type=char(2) updatewhereclause=yes name=phase_phase_id dbname="job.phase_id" values="EPE	 /CON	A/ROW	B/PE - C	C/PE - D	D/PE - E	E/PE - F	F/PE - G	G/PE - H	H/PE - I	I/PE - J	J/PE - K	K/PE - L	L/PE - M	M/PE - N	N/PE - O	O/PE - P	P/PE - Q	Q/PE - R	R/PE - S	S/PE - T	T/PE - U	U/PE - V	V/PE - W	W/PE - X	X/PE - Y	Y/UTL	Z/" )
 column=(type=char(3) updatewhereclause=yes name=phase_tmpl_cd dbname="job.tmpl_cd" )
 column=(type=char(4000) updatewhereclause=yes name=lookup_tmpl_desc dbname="tmpl_desc" )
 column=(type=char(6) updatewhereclause=yes name=phase_fin_cd dbname="job.fin_cd" )
 column=(type=char(3) updatewhereclause=yes name=phase_ptype_cd dbname="job.ptype_cd" )
 column=(type=char(4) updatewhereclause=yes name=oblg_log_100_fa_cd dbname="fa_cd" )
 column=(type=datetime updatewhereclause=yes name=oblg_log_100_sys_date dbname="job.sys_date" )
 column=(type=number updatewhereclause=yes name=trans_amt dbname="trans_amt" )
 column=(type=char(4000) updatewhereclause=yes name=ccomment dbname="comment" )
 column=(type=char(1) updatewhereclause=yes name=job_control_section_cs_maj_ind dbname="job.cs_maj_ind" )
 column=(type=decimal(0) updatewhereclause=yes name=job_physical_reference_pr_num dbname="job.pr_num" )
 column=(type=decimal(3) updatewhereclause=yes name=job_physical_reference_pr_beg_mp dbname="job.pr_beg_mp" )
 column=(type=decimal(3) updatewhereclause=yes name=job_physical_reference_pr_end_mp dbname="job.pr_end_mp" )
 column=(type=char(1) updatewhereclause=yes name=pr_maj_ind dbname="job.pr_maj_ind" )
 retrieve=" SELECT	DISTINCT ~"JOB~".~"JOB_ID~" ~"JOB_ID~",  
			~"JOB_CONTROL_SECTION~".~"CS_NUM~" ~"CS_NUM~", 
			~"JOB_CONTROL_SECTION~".~"STRT_MP~",
			~"JOB_CONTROL_SECTION~".~"END_MP~",
			~"JOB_CONTROL_SECTION~".~"RTE_NAME~" ~"ROUTE~",
			~"OBLG_LOG~".~"PFS_TYPE_CD~" ~"PFS_TYPE~",
 			~"JOB~".~"RPT_LOC_DESC~" ~"LOC_DESC~", 
			~"JOB~".~"CONSTR_LENGTH_QTY~" ~"MILES~",
			~"JOB~".~"RPT_WK_DESC~" ~"WK_DESC~", 
			~"JOB~".~"WK_TYPE_CD~" ~"WK_TYPE_CD~", 
			~"JOB~".~"SCHLD_LET_DATE~" ~"LET_DATE~", 
			~"JOB~".~"MDOT_REGN_CD~" ~"REGN_CD~", 
			get_code_desc('MDOT_REGN_CD',~"JOB~".~"MDOT_REGN_CD~") ~"REGN_DESC~",
 			~"JOB~".~"MDOT_CNTY_CD~" ~"CNTY_CD~", 
			get_code_desc('MDOT_CNTY_CD',~"JOB~".~"MDOT_CNTY_CD~") ~"CNTY_NAME~", 
		   ~"PHASE~".~"PHAS_ID~" ~"PHASE_ID~", 
			~"PHASE~".~"TMPL_CTG_CD~" ~"TMPL_CD~", 
			DECODE(~"JOB~".~"JOB_TYPE_CD~",'T',get_code_desc('PHASE_TMPL_CTG_CD',~"PHASE~".~"TMPL_CTG_CD~"),'L',get_code_desc('LOCAL_TMPL_CTG_CD',~"PHASE~".~"TMPL_CTG_CD~"),' ') ~"TMPL_DESC~",
			~"PHASE_FINSYS~".~"FIN_SYS~" ~"FIN_CD~", 
			~"PHASE~".~"PHAS_TYPE_CD~" ~"PTYPE_CD~", 
			DECODE(~"OBLG_LOG~".~"PFS_TYPE_CD~",'F',~"OBLG_LOG~".~"FA_CD~",'S',~"OBLG_LOG~".~"SA_EXPN_ACCT_CD~",'L',~"OBLG_LOG~".~"AO_TYPE_CD~",'S') ~"FA_CD~", 
			~"OBLG_LOG~".~"SYST_ROW_TMSP~" ~"SYS_DATE~", 
			(~"OBLG_LOG~".~"END_AMT~" - ~"OBLG_LOG~".~"BEG_AMT~") as ~"TRANS_AMT~", 
			get_code_desc('TRNS_TYPE_CD',~"TRNS_LOG~".~"TRNS_TYPE_CD~") ~"COMMENT~" ,
			~"JOB_CONTROL_SECTION~".~"CS_MAJ_IND~",
			~"JOB_PHYSICAL_REFERENCE~".~"PR_NUM~",
			~"JOB_PHYSICAL_REFERENCE~".~"PR_BEG_MP~",
			~"JOB_PHYSICAL_REFERENCE~".~"PR_END_MP~",
			~"JOB_PHYSICAL_REFERENCE~".~"PR_MAJ_IND~" ~"PR_MAJ_IND~"
 FROM		~"MAP~".~"JOB~", 
			~"MAP~".~"JOB_CONTROL_SECTION~", 
			~"MAP~".~"PHASE~",
			~"MAP~".~"PHASE_FINSYS~",
			~"MAP~".~"OBLG_LOG~", 
			~"MAP~".~"TRNS_LOG~",
			~"MAP~".~"JOB_PHYSICAL_REFERENCE~"
 WHERE	( ~"MAP~".~"OBLG_LOG~".~"JOB_ID~" = ~"MAP~".~"JOB~".~"JOB_ID~") 
 AND	   ( ~"MAP~".~"OBLG_LOG~".~"JOB_ID~"	= ~"MAP~".~"JOB_CONTROL_SECTION~".~"JOB_ID~" )   
 AND		( ~"MAP~".~"OBLG_LOG~".~"JOB_ID~" = ~"MAP~".~"PHASE~".~"JOB_ID~")
 AND      ( ~"MAP~".~"PHASE~".~"FUND_RLTN~" NOT IN ('STDCHD','STPCHD'))   
 AND		( ~"MAP~".~"OBLG_LOG~".~"PHAS_ID~" = ~"MAP~".~"PHASE~".~"PHAS_ID~")  
 AND		( ~"MAP~".~"PHASE_FINSYS~".~"JOB_ID~" (+) = ~"MAP~".~"PHASE~".~"JOB_ID~")  
 AND		( ~"MAP~".~"PHASE_FINSYS~".~"PHAS_ID~" (+) = ~"MAP~".~"PHASE~".~"PHAS_ID~")  
 AND		( ~"MAP~".~"PHASE_FINSYS~".~"MAJ_FIN_FLAG~" (+) = 'Y')  
 AND		( ~"MAP~".~"OBLG_LOG~".~"TRNS_NUM~" = ~"MAP~".~"TRNS_LOG~".~"TRNS_NUM~") 
 AND		( ~"MAP~".~"OBLG_LOG~".~"ENTY_TYPE_CD~" = 'PFS') 
AND		( ~"MAP~".~"JOB~".~"JOB_ID~" = ~"MAP~".~"JOB_PHYSICAL_REFERENCE~".~"JOB_ID~" (+)) 
" filter="job_control_section_cs_maj_ind = 'Y'  and  pr_maj_ind = 'Y'" sort="lookup_regn_desc A lookup_cnty_name A lookup_tmpl_desc A job_control_section_cs_num A job_job_id A oblg_log_100_sys_date A phase_phase_id A " )
group(level=1 header.height=0 trailer.height=92 by=("lookup_regn_desc" ) newpage=yes header.color="536870912" trailer.color="536870912" )
group(level=2 header.height=84 trailer.height=88 by=("lookup_cnty_name" ) header.color="536870912" trailer.color="536870912" )
group(level=3 header.height=76 trailer.height=96 by=("lookup_tmpl_desc" ) header.color="536870912" trailer.color="536870912" )
group(level=4 header.height=52 trailer.height=56 by=("job_job_id" ) header.color="536870912" trailer.color="536870912" )
bitmap(band=header filename="MDOT.BMP" x="23" y="24" height="288" width="1065" border="0"  name=p_mdot visible="1" )
text(band=header alignment="2" text="Date" border="0" color="0" x="3749" y="12" height="56" width="110" html.valueishtml="0"  name=t_1 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="Page" border="0" color="0" x="3735" y="88" height="56" width="123" html.valueishtml="0"  name=t_2 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=header alignment="0" expression="page() + ' of ' + pageCount()"border="0" color="0" x="3890" y="88" height="56" width="443" format="[general]" html.valueishtml="0"  name=compute_1 visible="1"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=header alignment="0" expression="today()"border="0" color="0" x="3890" y="12" height="56" width="443" format="mm-dd-yyyy" html.valueishtml="0"  name=compute_2 visible="1"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=header x1="0" y1="628" x2="4503" y2="628"  name=l_1 visible="1" pen.style="0" pen.width="9" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=header x1="9" y1="800" x2="4512" y2="800"  name=l_2 visible="1" pen.style="0" pen.width="9" pen.color="0"  background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="Location
Description" border="0" color="0" x="768" y="640" height="112" width="288" html.valueishtml="0"  name=job_loc_desc_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Route" border="0" color="0" x="421" y="640" height="56" width="146" html.valueishtml="0"  name=job_control_section_rte_name_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="WTC" border="0" color="0" x="2025" y="640" height="56" width="114" html.valueishtml="0"  name=t_3 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="Comments" border="0" color="0" x="3831" y="640" height="56" width="283" html.valueishtml="0"  name=t_4 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="Phase" border="0" color="0" x="2176" y="640" height="56" width="155" html.valueishtml="0"  name=project_mgr_empl_id_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="CS" border="0" color="0" x="242" y="640" height="56" width="69" html.valueishtml="0"  name=job_control_section_cs_num_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Job #" border="0" color="0" x="23" y="640" height="56" width="133" html.valueishtml="0"  name=job_job_id_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header id=13 alignment="0" tabsequence=32766 border="0" color="0" x="279" y="548" height="64" width="869" format="[general]" html.valueishtml="0"  name=lookup_regn_desc visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Region :" border="0" color="0" x="23" y="548" height="64" width="201" html.valueishtml="0"  name=st_distlabel visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="Transaction
Date" border="0" color="0" x="3511" y="640" height="112" width="297" html.valueishtml="0"  name=job_desn_plan_due_date_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Transaction
Amount " border="0" color="0" x="3109" y="640" height="112" width="297" html.valueishtml="0"  name=t_5 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="Fin Sys
(Appr Cd)" border="0" color="0" x="2697" y="640" height="112" width="242" html.valueishtml="0"  name=project_eis_finl_date_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Sch
Let Date" border="0" color="0" x="1806" y="640" height="112" width="206" html.valueishtml="0"  name=job_wk_desc_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Miles" border="0" color="0" x="1550" y="640" height="56" width="137" html.valueishtml="0"  name=job_control_section_strt_mp_t visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Fund
Type" border="0" color="0" x="2432" y="640" height="112" width="123" html.valueishtml="0"  name=t_6 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="System Jurisdiction" border="0" color="0" x="3355" y="160" height="56" width="503" html.valueishtml="0"  name=t_7 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="All" border="0" color="0" x="3890" y="160" height="56" width="443" html.valueishtml="0"  name=job_type visible="1"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="Phase" border="0" color="0" x="3703" y="236" height="56" width="155" html.valueishtml="0"  name=t_8 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="All" border="0" color="0" x="3890" y="236" height="56" width="443" html.valueishtml="0"  name=phase visible="1"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="Transaction Type" border="0" color="0" x="3424" y="312" height="56" width="434" html.valueishtml="0"  name=t_9 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="All" border="0" color="0" x="3890" y="312" height="56" width="443" html.valueishtml="0"  name=tran_type visible="1"  font.face="Arial" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="text" border="0" color="0" x="1262" y="112" height="80" width="2057" html.valueishtml="0"  name=trandate visible="1"  font.face="Times New Roman" font.height="-12" font.weight="700"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=header alignment="2" text="OBLIGATION TRANSACTION ACTIVITY : DETAIL" border="0" color="0" x="1120" y="12" height="92" width="2514" html.valueishtml="0"  name=title visible="1"  font.face="Arial" font.height="-14" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="Report Style : " border="0" color="0" x="1408" y="220" height="64" width="1783" html.valueishtml="0"  name=repstyle visible="1"  font.face="Times New Roman" font.height="-10" font.weight="700"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
compute(band=header.2 alignment="0" expression=" lookup_cnty_name "border="0" color="0" x="274" y="12" height="64" width="617" format="[general]" html.valueishtml="0"  name=st_cntyname visible="1~t1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header.2 alignment="2" text="County :" border="0" color="0" x="23" y="12" height="56" width="206" html.valueishtml="0"  name=st_cntylabel visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header.3 alignment="0" text="Template Category :" border="0" color="0" x="23" y="8" height="56" width="503" html.valueishtml="0"  name=t_10 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
column(band=header.3 id=18 alignment="0" tabsequence=32766 border="0" color="0" x="549" y="8" height="64" width="1152" format="[general]" html.valueishtml="0"  name=lookup_tmpl_desc visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.4 id=1 alignment="0" tabsequence=32766 border="0" color="0" x="23" y="4" height="44" width="183" format="[general]" html.valueishtml="0"  name=job_job_id visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.4 id=10 alignment="0" tabsequence=32766 border="0" color="0" x="2025" y="4" height="44" width="137" format="[general]" html.valueishtml="0"  name=job_wk_type_cd visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
column(band=header.4 id=2 alignment="0" tabsequence=32766 border="0" color="0" x="233" y="4" height="44" width="155" format="[general]" html.valueishtml="0"  name=job_control_section_cs_num visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.4 id=5 alignment="0" tabsequence=32766 border="0" color="0" x="411" y="4" height="44" width="338" format="[general]" html.valueishtml="0"  name=job_control_section_route visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.4 id=7 alignment="0" tabsequence=32766 border="0" color="0" x="768" y="4" height="44" width="672" format="[general]" html.valueishtml="0"  name=job_loc_desc visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.4 id=11 alignment="0" tabsequence=32766 border="0" color="0" x="1710" y="4" height="44" width="302" format="mm/dd/yyyy" html.valueishtml="0"  name=job_let_date visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.4 id=8 alignment="0" tabsequence=32766 border="0" color="0" x="1458" y="4" height="44" width="229" format="0.000" html.valueishtml="0"  name=job_miles visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="0" x="2167" y="4" height="44" width="178" format="[general]" html.valueishtml="0"  name=phase_phase_id visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 edit.codetable=yes  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=24 alignment="0" tabsequence=32766 border="0" color="0" x="3831" y="4" height="44" width="695" format="[general]" html.valueishtml="0"  name=ccomment visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=22 alignment="0" tabsequence=32766 border="0" color="0" x="3424" y="4" height="44" width="384" format="mm/dd/yyyy" html.valueishtml="0"  name=oblg_log_100_sys_date visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=detail alignment="0" expression="   phase_fin_cd  + ~" (~"  +  oblg_log_100_fa_cd   + ~")~" "border="0" color="0" x="2638" y="4" height="44" width="302" format="[general]" html.valueishtml="0"  name=compute_3 visible="1"  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="0" x="2528" y="4" height="44" width="27" format="[general]" html.valueishtml="0"  name=cpfs_type visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=23 alignment="1" tabsequence=32766 border="0" color="0" x="2958" y="4" height="44" width="448" format="$#,##0.00;($#,##0.00)" html.valueishtml="0"  name=trans_amt visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 criteria.override_edit=yes  font.face="Arial" font.height="-6" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=trailer.4 alignment="1" text="Total :" border="0" color="0" x="2830" y="4" height="44" width="110" html.valueishtml="0"  name=t_11 visible="1~tif (count(   phase_phase_id   for group 4 ) > 1,1,0)"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=trailer.4 alignment="1" expression=" sum(  trans_amt   for group 4 )"border="0" color="0" x="2958" y="4" height="44" width="448" format="$#,##0.00;($#,##0.00)" html.valueishtml="0"  name=compute_4 visible="1~tif (count(   phase_phase_id    for group 4 ) > 1,1,0)"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=trailer.3 x1="9" y1="4" x2="4507" y2="4"  name=l_3 visible="1" pen.style="0" pen.width="5" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=trailer.3 x1="9" y1="80" x2="4507" y2="80"  name=l_4 visible="1" pen.style="0" pen.width="5" pen.color="0"  background.mode="1" background.color="553648127" )
text(band=trailer.3 alignment="0" text="Total for Template Category :" border="0" color="0" x="18" y="16" height="56" width="731" html.valueishtml="0"  name=t_12 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=trailer.3 alignment="0" expression="sum( job_miles  for group 3 distinct   job_job_id  ) "border="0" color="0" x="1458" y="16" height="56" width="229" format="0.000" html.valueishtml="0"  name=compute_5 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="33554431" )
compute(band=trailer.3 alignment="1" expression=" sum(  trans_amt   for group 3 )"border="0" color="0" x="2958" y="8" height="64" width="448" format="$#,##0.00;($#,##0.00)" html.valueishtml="0"  name=compute_6 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=trailer.2 x1="5" y1="4" x2="4503" y2="4"  name=l_5 visible="1" pen.style="0" pen.width="5" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=trailer.2 x1="5" y1="84" x2="4503" y2="84"  name=l_6 visible="1" pen.style="0" pen.width="5" pen.color="0"  background.mode="1" background.color="553648127" )
text(band=trailer.2 alignment="0" text="Total for County :" border="0" color="0" x="18" y="16" height="56" width="430" html.valueishtml="0"  name=t_13 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=trailer.2 alignment="0" expression="sum( job_miles  for group 2 distinct   job_job_id  ) "border="0" color="0" x="1458" y="16" height="56" width="229" format="0.000" html.valueishtml="0"  name=compute_7 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="33554431" )
compute(band=trailer.2 alignment="1" expression="sum(  trans_amt   for group 2 )"border="0" color="0" x="2958" y="16" height="56" width="448" format="$#,##0.00;($#,##0.00)" html.valueishtml="0"  name=compute_8 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=trailer.1 x1="5" y1="80" x2="4507" y2="80"  name=l_7 visible="1" pen.style="0" pen.width="5" pen.color="0"  background.mode="1" background.color="553648127" )
text(band=trailer.1 alignment="0" text="Total  for Region :" border="0" color="0" x="18" y="16" height="56" width="439" html.valueishtml="0"  name=t_14 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=trailer.1 x1="5" y1="4" x2="4503" y2="4"  name=l_8 visible="1" pen.style="0" pen.width="5" pen.color="0"  background.mode="1" background.color="553648127" )
compute(band=trailer.1 alignment="0" expression="sum( job_miles  for group 1 distinct   job_job_id  ) "border="0" color="0" x="1458" y="16" height="56" width="229" format="0.000" html.valueishtml="0"  name=compute_9 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="33554431" )
compute(band=trailer.1 alignment="1" expression=" sum(  trans_amt   for group 1 )"border="0" color="0" x="2958" y="16" height="56" width="448" format="$#,##0.00;($#,##0.00)" html.valueishtml="0"  name=compute_10 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=summary alignment="0" text="JOB/PHASE OPER STATUS CODES" border="0" color="0" x="14" y="96" height="40" width="599" html.valueishtml="0"  name=t_15 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="AP - Approved/ Programmed
AC - Active
SP - Suspended
AB - Abandoned
CP - Completed" border="0" color="0" x="14" y="176" height="200" width="485" html.valueishtml="0"  name=t_16 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="SYSTEM JURISDICTION CODES" border="0" color="0" x="635" y="96" height="40" width="549" html.valueishtml="0"  name=t_17 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="T - Trunkline
U - Uptran
A - Aeronautics
L - Local" border="0" color="0" x="635" y="176" height="160" width="256" html.valueishtml="0"  name=t_18 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="CH - Chargeable
NC - Not chargeable
SP - Suspended
CP - Completed" border="0" color="0" x="1216" y="176" height="160" width="343" html.valueishtml="0"  name=t_19 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="PHASE FINANCIAL STATUS CODES" border="0" color="0" x="1216" y="96" height="40" width="608" html.valueishtml="0"  name=t_20 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="L - Let
N - Not Let Or
      Advertised" border="0" color="0" x="1842" y="176" height="120" width="238" html.valueishtml="0"  name=t_21 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="LET STATUS CODES" border="0" color="0" x="1842" y="96" height="40" width="357" html.valueishtml="0"  name=t_22 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="NON LET CODES" border="0" color="0" x="2226" y="96" height="40" width="297" html.valueishtml="0"  name=t_23 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="FA - Force Account
LO - Let by Others
LS - Lumpsum
NC - Negotiated
OT - Other
WA - Warranty 
         Administration" border="0" color="0" x="2226" y="176" height="280" width="334" html.valueishtml="0"  name=t_24 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="PHASE CODES" border="0" color="0" x="2583" y="96" height="40" width="256" html.valueishtml="0"  name=t_25 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="EPE - Early Preliminary Engineering
PER- Preliminary Engineering Road
PES - Preliminary Engineering Structure
ROW - Right Of Way
CON - Construction" border="0" color="0" x="2583" y="176" height="200" width="667" html.valueishtml="0"  name=t_26 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="AUT - AC Authorizations
CON- Conversions
OBL - Obligations
DEO - Deobligations" border="0" color="0" x="3291" y="176" height="160" width="416" html.valueishtml="0"  name=t_27 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="TRANSACTION TYPE CODES" border="0" color="0" x="3291" y="96" height="40" width="498" html.valueishtml="0"  name=t_28 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=summary x1="9" y1="4" x2="4512" y2="4"  name=l_9 visible="1" pen.style="0" pen.width="9" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=summary x1="9" y1="84" x2="4512" y2="84"  name=l_10 visible="1" pen.style="0" pen.width="9" pen.color="0"  background.mode="1" background.color="553648127" )
text(band=summary alignment="0" text="Grand Total :" border="0" color="0" x="18" y="16" height="56" width="315" html.valueishtml="0"  name=t_29 visible="1"  font.face="Arial" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=summary alignment="0" expression="sum( job_miles  for ALL distinct   job_job_id  ) "border="0" color="0" x="1458" y="16" height="56" width="229" format="0.000" html.valueishtml="0"  name=compute_11 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="33554431" )
compute(band=summary alignment="1" expression="sum(  trans_amt   for all )"border="0" color="0" x="2958" y="16" height="56" width="448" format="$#,##0.00;($#,##0.00)" html.valueishtml="0"  name=compute_12 visible="1"  font.face="Arial" font.height="-6" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
htmltable(border="0" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top