BOS
list
LOL_CODE,System.String
30
list
BOS
select LOL_CODE
from LOT_LIST
where SPE_CODE='PE'
and BUN_CODE='C'
and LLT_CODE='PT'
lot_data
SPE_CODE,System.String
BUN_CODE,System.String
PRG_CODE,System.String
LOL_CODE,System.String
LOL_LABEL,System.String
LGI_MASTER_LOT_CODE,System.String
LGI_FAMILY,System.String
LGI_SELECTION_HISTORY,System.String
LGI_HYBRID_FORMULA,System.String
CUL_CODE,System.String
STT_CODE,System.String
STT_BASE_PEDIGREE,System.String
LOT_PARENT_MALE,System.String
PRG_CODE_MALE,System.String
LGI_SELECTION_HISTORY_PARENT_MALE,System.String
LGI_HYBRID_FORMULA_PARENT_MALE,System.String
CUL_CODE_PARENT_MALE,System.String
STT_CODE_PARENT_MALE,System.String
STT_BASE_PEDIGREE_PARENT_MALE,System.String
LOT_PARENT_FEMALE,System.String
PRG_CODE_FEMALE,System.String
LGI_FAMILY_PARENT_MALE,System.String
LGI_SELECTION_HISTORY_PARENT_FEMALE,System.String
LGI_HYBRID_FORMULA_PARENT_FEMALE,System.String
CUL_CODE_PARENT_FEMALE,System.String
STT_CODE_PARENT_FEMALE,System.String
STT_BASE_PEDIGREE_PARENT_FEMALE,System.String
LLI_ORDER_NR,System.Int16
TRV_CODE,System.String
TRV_LABEL,System.String
TEN_VALUE,System.String
LTR_NUMBER,System.Double
LTR_DATE,System.DateTime
LTR_TEXT,System.String
LPL_SOWING_NR,System.Int32
PLOT_NR,System.Int32
LGI_FAMILY_PARENT_FEMALE,System.String
30
False
lot_data
BOS
SELECT
pl.SPE_CODE
,pl.BUN_CODE
,pl.PRG_CODE
,pl.LOL_CODE
,ll.LOL_LABEL
,lgi.LGI_MASTER_LOT_CODE
,lgi.LGI_FAMILY
,lgi.LGI_SELECTION_HISTORY
,lgi.LGI_HYBRID_FORMULA
,cul.CUL_CODE
,stt.STT_CODE
,stt.STT_BASE_PEDIGREE
,lgi_m.LGI_MASTER_LOT_CODE LOT_PARENT_MALE
,l_m.PRG_CODE_OWNER PRG_CODE_MALE
,lgi_m.LGI_FAMILY LGI_FAMILY_PARENT_MALE
,lgi_m.LGI_SELECTION_HISTORY LGI_SELECTION_HISTORY_PARENT_MALE
,lgi_m.LGI_HYBRID_FORMULA LGI_HYBRID_FORMULA_PARENT_MALE
,cul_m.CUL_CODE CUL_CODE_PARENT_MALE
,stt_m.STT_CODE STT_CODE_PARENT_MALE
,stt_m.STT_BASE_PEDIGREE STT_BASE_PEDIGREE_PARENT_MALE
,lgi_f.LGI_MASTER_LOT_CODE LOT_PARENT_FEMALE
,l_f.PRG_CODE_OWNER PRG_CODE_FEMALE
,lgi_f.LGI_FAMILY LGI_FAMILY_PARENT_FEMALE
,lgi_f.LGI_SELECTION_HISTORY LGI_SELECTION_HISTORY_PARENT_FEMALE
,lgi_f.LGI_HYBRID_FORMULA LGI_HYBRID_FORMULA_PARENT_FEMALE
,cul_f.CUL_CODE CUL_CODE_PARENT_FEMALE
,stt_f.STT_CODE STT_CODE_PARENT_FEMALE
,stt_f.STT_BASE_PEDIGREE STT_BASE_PEDIGREE_PARENT_FEMALE
--,lill.LLI_ORDER_NR
,lip.LPL_PLOT_NR PLOT_NR
,tv.TRV_CODE
,tv.TRV_LABEL
,ltv.TEN_VALUE
,ltv.LTR_NUMBER
,ltv.LTR_DATE
,ltv.LTR_TEXT
FROM PLOT_LIST pl
JOIN LOT_LIST ll ON ll.SPE_CODE = pl.SPE_CODE AND ll.BUN_CODE = pl.BUN_CODE AND ll.LOL_CODE = pl.LOL_CODE
JOIN LOT_IN_LOT_LIST lill ON lill.SPE_CODE = pl.SPE_CODE AND lill.BUN_CODE = pl.BUN_CODE AND lill.LOL_CODE = pl.LOL_CODE
JOIN LOT_IN_PLOT lip ON lip.SPE_CODE = lill.SPE_CODE AND lip.BUN_CODE = lill.BUN_CODE AND lip.LLI_ID = lill.LLI_ID
LEFT JOIN TRAIT_PROFILE tp ON tp.SPE_CODE = lill.SPE_CODE AND tp.BUN_CODE = pl.BUN_CODE AND tp.TPF_NAME = '{plot_profile}'
LEFT JOIN TRAIT_PROFILE_VARIABLE tpv ON tpv.SPE_CODE = tp.SPE_CODE AND tpv.TPF_ID = tp.TPF_ID
LEFT JOIN LOT_TRAIT_VALUE ltv ON ltv.SPE_CODE = lill.SPE_CODE AND ltv.BUN_CODE = lill.BUN_CODE AND ltv.LOT_ID = lill.LOT_ID AND ltv.TRV_ID = tpv.TRV_ID --AND pov.TRV_ID IN (SELECT TRV_ID FROM tmp_PROF_PLOT_PLANT)
LEFT JOIN TRAIT_VARIABLE tv ON tv.SPE_CODE = tpv.SPE_CODE AND tv.TRV_ID = tpv.TRV_ID
JOIN LOT_GENETIC_INFORMATION lgi ON lill.SPE_CODE = lgi.SPE_CODE AND lill.BUN_CODE = lgi.BUN_CODE AND lgi.LOT_ID_MASTER_LOT = lill.LOT_ID
LEFT JOIN CULTIVAR cul ON cul.SPE_CODE = lgi.SPE_CODE AND cul.GSU_CODE = lgi.BUN_CODE AND cul.CUL_ID = lgi.CUL_ID
LEFT JOIN START stt ON stt.SPE_CODE = lgi.SPE_CODE AND stt.BUN_CODE = lgi.BUN_CODE AND stt.STT_ID = lgi.STT_ID
LEFT JOIN LOT_GENETIC_INFORMATION lgi_m ON lill.SPE_CODE = lgi_m.SPE_CODE AND lill.BUN_CODE = lgi_m.BUN_CODE AND lgi_m.LGI_ID = lgi.LGI_ID_MALE_PARENT
LEFT JOIN LOT l_m ON l_m.SPE_CODE = lgi_m.SPE_CODE AND l_m.BUN_CODE = lgi_m.BUN_CODE AND l_m.LGI_ID = lgi_m.LGI_ID
LEFT JOIN CULTIVAR cul_m ON cul_m.SPE_CODE = lgi_m.SPE_CODE AND cul_m.GSU_CODE = lgi_m.BUN_CODE AND cul_m.CUL_ID = lgi_m.CUL_ID
LEFT JOIN START stt_m ON stt_m.SPE_CODE = lgi_m.SPE_CODE AND stt_m.BUN_CODE = lgi_m.BUN_CODE AND stt_m.STT_ID = lgi_m.STT_ID
LEFT JOIN LOT_GENETIC_INFORMATION lgi_f ON lill.SPE_CODE = lgi_f.SPE_CODE AND lill.BUN_CODE = lgi_f.BUN_CODE AND lgi_f.LGI_ID = lgi.LGI_ID_PARENT
LEFT JOIN LOT l_f ON l_f.SPE_CODE = lgi_f.SPE_CODE AND l_f.BUN_CODE = l_f.BUN_CODE AND l_f.LGI_ID = lgi_f.LGI_ID
LEFT JOIN CULTIVAR cul_f ON cul_f.SPE_CODE = lgi_f.SPE_CODE AND cul_f.GSU_CODE = lgi_f.BUN_CODE AND cul_f.CUL_ID = lgi_f.CUL_ID
LEFT JOIN START stt_f ON stt_f.SPE_CODE = lgi_f.SPE_CODE AND stt_f.BUN_CODE = lgi_f.BUN_CODE AND stt_f.STT_ID = lgi_f.STT_ID
WHERE pl.SPE_CODE = 'PE'
AND pl.BUN_CODE = 'C'
AND pl.LOL_CODE = '{lol_code}'
ORDER BY 4,5,8
scoring_data
SPE_CODE,System.String
BUN_CODE,System.String
PRG_CODE,System.String
LOL_CODE,System.String
LOL_LABEL,System.String
LGI_MASTER_LOT_CODE,System.String
LGI_FAMILY,System.String
LGI_SELECTION_HISTORY,System.String
LGI_HYBRID_FORMULA,System.String
CUL_CODE,System.String
STT_CODE,System.String
STT_BASE_PEDIGREE,System.String
LOT_PARENT_MALE,System.String
PRG_CODE_MALE,System.String
LGI_FAMILY_PARENT_MALE,System.String
LGI_SELECTION_HISTORY_PARENT_MALE,System.String
LGI_HYBRID_FORMULA_PARENT_MALE,System.String
CUL_CODE_PARENT_MALE,System.String
STT_CODE_PARENT_MALE,System.String
STT_BASE_PEDIGREE_PARENT_MALE,System.String
LOT_PARENT_FEMALE,System.String
PRG_CODE_FEMALE,System.String
LGI_FAMILY_PARENT_FEMALE,System.String
LGI_SELECTION_HISTORY_PARENT_FEMALE,System.String
LGI_HYBRID_FORMULA_PARENT_FEMALE,System.String
CUL_CODE_PARENT_FEMALE,System.String
STT_CODE_PARENT_FEMALE,System.String
STT_BASE_PEDIGREE_PARENT_FEMALE,System.String
PLOT_NR,System.Int32
PLANT_NR,System.Int16
TRV_CODE,System.String
TRV_LABEL,System.String
TEN_VALUE,System.String
PLV_NUMERIC_VALUE,System.Single
PLV_TEXT_VALUE,System.String
PLV_DATE_VALUE,System.DateTime
30
False
scoring_data
BOS
SELECT
pl.SPE_CODE
,pl.BUN_CODE
,pl.PRG_CODE
,pl.LOL_CODE
,ll.LOL_LABEL
,lgi.LGI_MASTER_LOT_CODE
,lgi.LGI_FAMILY
,lgi.LGI_SELECTION_HISTORY
,lgi.LGI_HYBRID_FORMULA
,cul.CUL_CODE
,stt.STT_CODE
,stt.STT_BASE_PEDIGREE
,lgi_m.LGI_MASTER_LOT_CODE LOT_PARENT_MALE
,l_m.PRG_CODE_OWNER PRG_CODE_MALE
,lgi_m.LGI_FAMILY LGI_FAMILY_PARENT_MALE
,lgi_m.LGI_SELECTION_HISTORY LGI_SELECTION_HISTORY_PARENT_MALE
,lgi_m.LGI_HYBRID_FORMULA LGI_HYBRID_FORMULA_PARENT_MALE
,cul_m.CUL_CODE CUL_CODE_PARENT_MALE
,stt_m.STT_CODE STT_CODE_PARENT_MALE
,stt_m.STT_BASE_PEDIGREE STT_BASE_PEDIGREE_PARENT_MALE
,lgi_f.LGI_MASTER_LOT_CODE LOT_PARENT_FEMALE
,l_f.PRG_CODE_OWNER PRG_CODE_FEMALE
,lgi_f.LGI_FAMILY LGI_FAMILY_PARENT_FEMALE
,lgi_f.LGI_SELECTION_HISTORY LGI_SELECTION_HISTORY_PARENT_FEMALE
,lgi_f.LGI_HYBRID_FORMULA LGI_HYBRID_FORMULA_PARENT_FEMALE
,cul_f.CUL_CODE CUL_CODE_PARENT_FEMALE
,stt_f.STT_CODE STT_CODE_PARENT_FEMALE
,stt_f.STT_BASE_PEDIGREE STT_BASE_PEDIGREE_PARENT_FEMALE
--,lill.LLI_ID
,lip.LPL_PLOT_NR PLOT_NR
,NULL PLANT_NR -- PLANT_VALUE.PTV_PLANT_NR
--,tpv.TRV_ID
,tv.TRV_CODE
,tv.TRV_LABEL
,pov.TEN_VALUE
,pov.PLV_NUMERIC_VALUE
,pov.PLV_TEXT_VALUE
,pov.PLV_DATE_VALUE
FROM PLOT_LIST pl
JOIN LOT_LIST ll ON ll.SPE_CODE = pl.SPE_CODE AND ll.BUN_CODE = pl.BUN_CODE AND ll.LOL_CODE = pl.LOL_CODE
JOIN LOT_IN_LOT_LIST lill ON lill.SPE_CODE = pl.SPE_CODE AND lill.BUN_CODE = pl.BUN_CODE AND lill.LOL_CODE = pl.LOL_CODE
LEFT JOIN TRAIT_PROFILE tp ON tp.SPE_CODE = lill.SPE_CODE AND tp.BUN_CODE = pl.BUN_CODE AND tp.TPF_NAME = '{plot_profile}'
LEFT JOIN TRAIT_PROFILE_VARIABLE tpv ON tpv.SPE_CODE = tp.SPE_CODE AND tpv.TPF_ID = tp.TPF_ID
JOIN LOT_IN_PLOT lip ON lip.SPE_CODE = lill.SPE_CODE AND lip.BUN_CODE = lill.BUN_CODE AND lip.LLI_ID = lill.LLI_ID
LEFT JOIN PLOT_VALUE pov ON pov.SPE_CODE = lill.SPE_CODE AND pov.BUN_CODE = lill.BUN_CODE AND pov.LLI_ID = lill.LLI_ID AND pov.TRV_ID = tpv.TRV_ID --AND pov.TRV_ID IN (SELECT TRV_ID FROM tmp_PROF_PLOT_PLANT)
LEFT JOIN TRAIT_VARIABLE tv ON tv.SPE_CODE = tpv.SPE_CODE AND tv.TRV_ID = tpv.TRV_ID
JOIN LOT_GENETIC_INFORMATION lgi ON lill.SPE_CODE = lgi.SPE_CODE AND lill.BUN_CODE = lgi.BUN_CODE AND lgi.LOT_ID_MASTER_LOT = lill.LOT_ID
LEFT JOIN CULTIVAR cul ON cul.SPE_CODE = lgi.SPE_CODE AND cul.GSU_CODE = lgi.BUN_CODE AND cul.CUL_ID = lgi.CUL_ID
LEFT JOIN START stt ON stt.SPE_CODE = lgi.SPE_CODE AND stt.BUN_CODE = lgi.BUN_CODE AND stt.STT_ID = lgi.STT_ID
LEFT JOIN LOT_GENETIC_INFORMATION lgi_m ON lill.SPE_CODE = lgi_m.SPE_CODE AND lill.BUN_CODE = lgi_m.BUN_CODE AND lgi_m.LGI_ID = lgi.LGI_ID_MALE_PARENT
LEFT JOIN LOT l_m ON l_m.SPE_CODE = lgi_m.SPE_CODE AND l_m.BUN_CODE = lgi_m.BUN_CODE AND l_m.LGI_ID = lgi_m.LGI_ID
LEFT JOIN CULTIVAR cul_m ON cul_m.SPE_CODE = lgi_m.SPE_CODE AND cul_m.GSU_CODE = lgi_m.BUN_CODE AND cul_m.CUL_ID = lgi_m.CUL_ID
LEFT JOIN START stt_m ON stt_m.SPE_CODE = lgi_m.SPE_CODE AND stt_m.BUN_CODE = lgi_m.BUN_CODE AND stt_m.STT_ID = lgi_m.STT_ID
LEFT JOIN LOT_GENETIC_INFORMATION lgi_f ON lill.SPE_CODE = lgi_f.SPE_CODE AND lill.BUN_CODE = lgi_f.BUN_CODE AND lgi_f.LGI_ID = lgi.LGI_ID_PARENT
LEFT JOIN LOT l_f ON l_f.SPE_CODE = lgi_f.SPE_CODE AND l_f.BUN_CODE = l_f.BUN_CODE AND l_f.LGI_ID = lgi_f.LGI_ID
LEFT JOIN CULTIVAR cul_f ON cul_f.SPE_CODE = lgi_f.SPE_CODE AND cul_f.GSU_CODE = lgi_f.BUN_CODE AND cul_f.CUL_ID = lgi_f.CUL_ID
LEFT JOIN START stt_f ON stt_f.SPE_CODE = lgi_f.SPE_CODE AND stt_f.BUN_CODE = lgi_f.BUN_CODE AND stt_f.STT_ID = lgi_f.STT_ID
WHERE pl.SPE_CODE = 'PE'
AND pl.BUN_CODE = 'C'
AND pl.LOL_CODE = '{lol_code}'
and lip.LPL_PLOT_NR between {plot1} and {plot2}
UNION ALL
SELECT
pl.SPE_CODE
,pl.BUN_CODE
,pl.PRG_CODE
,pl.LOL_CODE
,ll.LOL_LABEL
,lgi.LGI_MASTER_LOT_CODE
,lgi.LGI_FAMILY
,lgi.LGI_SELECTION_HISTORY
,lgi.LGI_HYBRID_FORMULA
,cul.CUL_CODE
,stt.STT_CODE
,stt.STT_BASE_PEDIGREE
,lgi_m.LGI_MASTER_LOT_CODE LOT_PARENT_MALE
,l_m.PRG_CODE_OWNER PRG_CODE_MALE
,lgi_m.LGI_FAMILY LGI_FAMILY_PARENT_MALE
,lgi_m.LGI_SELECTION_HISTORY LGI_SELECTION_HISTORY_PARENT_MALE
,lgi_m.LGI_HYBRID_FORMULA LGI_HYBRID_FORMULA_PARENT_MALE
,cul_m.CUL_CODE CUL_CODE_PARENT_MALE
,stt_m.STT_CODE STT_CODE_PARENT_MALE
,stt_m.STT_BASE_PEDIGREE STT_BASE_PEDIGREE_PARENT_MALE
,lgi_f.LGI_MASTER_LOT_CODE LOT_PARENT_FEMALE
,l_f.PRG_CODE_OWNER PRG_CODE_FEMALE
,lgi_f.LGI_FAMILY LGI_FAMILY_PARENT_FEMALE
,lgi_f.LGI_SELECTION_HISTORY LGI_SELECTION_HISTORY_PARENT_FEMALE
,lgi_f.LGI_HYBRID_FORMULA LGI_HYBRID_FORMULA_PARENT_FEMALE
,cul_f.CUL_CODE CUL_CODE_PARENT_FEMALE
,stt_f.STT_CODE STT_CODE_PARENT_FEMALE
,stt_f.STT_BASE_PEDIGREE STT_BASE_PEDIGREE_PARENT_FEMALE
--,lill.LLI_ID
,lip.LPL_PLOT_NR PLOT_NR
,pav.PTV_PLANT_NR PLANT_NR
--,tpv.TRV_ID
,tv.TRV_CODE
,tv.TRV_LABEL
,pav.TEN_VALUE
,pav.PTV_NUMERIC_VALUE
,pav.PTV_TEXT_VALUE
,pav.PTV_DATE_VALUE
FROM PLOT_LIST pl
JOIN LOT_LIST ll ON ll.SPE_CODE = pl.SPE_CODE AND ll.BUN_CODE = pl.BUN_CODE AND ll.LOL_CODE = pl.LOL_CODE
JOIN LOT_IN_LOT_LIST lill ON lill.SPE_CODE = pl.SPE_CODE AND lill.BUN_CODE = pl.BUN_CODE AND lill.LOL_CODE = pl.LOL_CODE
LEFT JOIN TRAIT_PROFILE tp ON tp.SPE_CODE = lill.SPE_CODE AND tp.BUN_CODE = pl.BUN_CODE AND tp.TPF_NAME = '{plot_profile}'
LEFT JOIN TRAIT_PROFILE_VARIABLE tpv ON tpv.SPE_CODE = tp.SPE_CODE AND tpv.TPF_ID = tp.TPF_ID
JOIN LOT_IN_PLOT lip ON lip.SPE_CODE = lill.SPE_CODE AND lip.BUN_CODE = lill.BUN_CODE AND lip.LLI_ID = lill.LLI_ID
LEFT JOIN PLANT_VALUE pav ON pav.SPE_CODE = lill.SPE_CODE AND pav.BUN_CODE = lill.BUN_CODE AND pav.LLI_ID = lill.LLI_ID AND pav.TRV_ID = tpv.TRV_ID --AND pov.TRV_ID IN (SELECT TRV_ID FROM tmp_PROF_PLOT_PLANT)
LEFT JOIN TRAIT_VARIABLE tv ON tv.SPE_CODE = tpv.SPE_CODE AND tv.TRV_ID = tpv.TRV_ID
JOIN LOT_GENETIC_INFORMATION lgi ON lill.SPE_CODE = lgi.SPE_CODE AND lill.BUN_CODE = lgi.BUN_CODE AND lgi.LOT_ID_MASTER_LOT = lill.LOT_ID
LEFT JOIN CULTIVAR cul ON cul.SPE_CODE = lgi.SPE_CODE AND cul.GSU_CODE = lgi.BUN_CODE AND cul.CUL_ID = lgi.CUL_ID
LEFT JOIN START stt ON stt.SPE_CODE = lgi.SPE_CODE AND stt.BUN_CODE = lgi.BUN_CODE AND stt.STT_ID = lgi.STT_ID
LEFT JOIN LOT_GENETIC_INFORMATION lgi_m ON lill.SPE_CODE = lgi_m.SPE_CODE AND lill.BUN_CODE = lgi_m.BUN_CODE AND lgi_m.LGI_ID = lgi.LGI_ID_MALE_PARENT
LEFT JOIN LOT l_m ON l_m.SPE_CODE = lgi_m.SPE_CODE AND l_m.BUN_CODE = lgi_m.BUN_CODE AND l_m.LGI_ID = lgi_m.LGI_ID
LEFT JOIN CULTIVAR cul_m ON cul_m.SPE_CODE = lgi_m.SPE_CODE AND cul_m.GSU_CODE = lgi_m.BUN_CODE AND cul_m.CUL_ID = lgi_m.CUL_ID
LEFT JOIN START stt_m ON stt_m.SPE_CODE = lgi_m.SPE_CODE AND stt_m.BUN_CODE = lgi_m.BUN_CODE AND stt_m.STT_ID = lgi_m.STT_ID
LEFT JOIN LOT_GENETIC_INFORMATION lgi_f ON lill.SPE_CODE = lgi_f.SPE_CODE AND lill.BUN_CODE = lgi_f.BUN_CODE AND lgi_f.LGI_ID = lgi.LGI_ID_PARENT
LEFT JOIN LOT l_f ON l_f.SPE_CODE = lgi_f.SPE_CODE AND l_f.BUN_CODE = l_f.BUN_CODE AND l_f.LGI_ID = lgi_f.LGI_ID
LEFT JOIN CULTIVAR cul_f ON cul_f.SPE_CODE = lgi_f.SPE_CODE AND cul_f.GSU_CODE = lgi_f.BUN_CODE AND cul_f.CUL_ID = lgi_f.CUL_ID
LEFT JOIN START stt_f ON stt_f.SPE_CODE = lgi_f.SPE_CODE AND stt_f.BUN_CODE = lgi_f.BUN_CODE AND stt_f.STT_ID = lgi_f.STT_ID
WHERE pl.SPE_CODE = 'PE'
AND pl.BUN_CODE = 'C'
AND pl.LOL_CODE = '{lol_code}'
and lip.LPL_PLOT_NR between {plot1} and {plot2}
ORDER BY 4,5,9,10,11
trait_profiles
TPF_NAME,System.String
30
trait_profiles
BOS
select TPF_NAME
from TRAIT_PROFILE
where BUN_CODE='C'
and SPE_CODE='PE'
and PRG_CODE='PSRY'
plots
LOL_CODE,System.String
LOL_LABEL,System.String
PLOT_NR,System.Int32
LOT_CODE,System.String
30
False
plots
BOS
SELECT
pl.LOL_CODE
,ll.LOL_LABEL
,lip.LPL_PLOT_NR PLOT_NR
,LOT.LOT_CODE
FROM PLOT_LIST pl
JOIN LOT_LIST ll ON ll.SPE_CODE = pl.SPE_CODE AND ll.BUN_CODE = pl.BUN_CODE AND ll.LOL_CODE = pl.LOL_CODE
JOIN LOT_IN_LOT_LIST lill ON lill.SPE_CODE = pl.SPE_CODE AND lill.BUN_CODE = pl.BUN_CODE AND lill.LOL_CODE = pl.LOL_CODE
JOIN LOT_IN_PLOT lip ON lip.SPE_CODE = lill.SPE_CODE AND lip.BUN_CODE = lill.BUN_CODE AND lip.LLI_ID = lill.LLI_ID
JOIN LOT on lill.SPE_CODE = LOT.SPE_CODE AND lill.BUN_CODE = LOT.BUN_CODE AND lill.LOT_ID = LOT.LOT_ID
WHERE pl.SPE_CODE = 'PE'
AND pl.BUN_CODE = 'C'
AND pl.LOL_CODE = '{lol_code}'
and lip.LPL_PLOT_NR between {plot1} and {plot2}
plants
SPE_CODE,System.String
BUN_CODE,System.String
PRG_CODE,System.String
LOL_CODE,System.String
LOL_LABEL,System.String
LGI_MASTER_LOT_CODE,System.String
LGI_FAMILY,System.String
LGI_SELECTION_HISTORY,System.String
LGI_HYBRID_FORMULA,System.String
CUL_CODE,System.String
STT_CODE,System.String
STT_BASE_PEDIGREE,System.String
LOT_PARENT_MALE,System.String
PRG_CODE_MALE,System.String
LGI_FAMILY_PARENT_MALE,System.String
LGI_SELECTION_HISTORY_PARENT_MALE,System.String
LGI_HYBRID_FORMULA_PARENT_MALE,System.String
CUL_CODE_PARENT_MALE,System.String
STT_CODE_PARENT_MALE,System.String
STT_BASE_PEDIGREE_PARENT_MALE,System.String
LOT_PARENT_FEMALE,System.String
PRG_CODE_FEMALE,System.String
LGI_FAMILY_PARENT_FEMALE,System.String
LGI_SELECTION_HISTORY_PARENT_FEMALE,System.String
LGI_HYBRID_FORMULA_PARENT_FEMALE,System.String
CUL_CODE_PARENT_FEMALE,System.String
STT_CODE_PARENT_FEMALE,System.String
STT_BASE_PEDIGREE_PARENT_FEMALE,System.String
PLOT_NR,System.Int32
PLANT_NR,System.Int16
30
False
plants
BOS
SELECT distinct
pl.SPE_CODE
,pl.BUN_CODE
,pl.PRG_CODE
,pl.LOL_CODE
,ll.LOL_LABEL
,lgi.LGI_MASTER_LOT_CODE
,lgi.LGI_FAMILY
,lgi.LGI_SELECTION_HISTORY
,lgi.LGI_HYBRID_FORMULA
,cul.CUL_CODE
,stt.STT_CODE
,stt.STT_BASE_PEDIGREE
,lgi_m.LGI_MASTER_LOT_CODE LOT_PARENT_MALE
,l_m.PRG_CODE_OWNER PRG_CODE_MALE
,lgi_m.LGI_FAMILY LGI_FAMILY_PARENT_MALE
,lgi_m.LGI_SELECTION_HISTORY LGI_SELECTION_HISTORY_PARENT_MALE
,lgi_m.LGI_HYBRID_FORMULA LGI_HYBRID_FORMULA_PARENT_MALE
,cul_m.CUL_CODE CUL_CODE_PARENT_MALE
,stt_m.STT_CODE STT_CODE_PARENT_MALE
,stt_m.STT_BASE_PEDIGREE STT_BASE_PEDIGREE_PARENT_MALE
,lgi_f.LGI_MASTER_LOT_CODE LOT_PARENT_FEMALE
,l_f.PRG_CODE_OWNER PRG_CODE_FEMALE
,lgi_f.LGI_FAMILY LGI_FAMILY_PARENT_FEMALE
,lgi_f.LGI_SELECTION_HISTORY LGI_SELECTION_HISTORY_PARENT_FEMALE
,lgi_f.LGI_HYBRID_FORMULA LGI_HYBRID_FORMULA_PARENT_FEMALE
,cul_f.CUL_CODE CUL_CODE_PARENT_FEMALE
,stt_f.STT_CODE STT_CODE_PARENT_FEMALE
,stt_f.STT_BASE_PEDIGREE STT_BASE_PEDIGREE_PARENT_FEMALE
--,lill.LLI_ID
,lip.LPL_PLOT_NR PLOT_NR
,pav.PTV_PLANT_NR PLANT_NR
FROM PLOT_LIST pl
JOIN LOT_LIST ll ON ll.SPE_CODE = pl.SPE_CODE AND ll.BUN_CODE = pl.BUN_CODE AND ll.LOL_CODE = pl.LOL_CODE
JOIN LOT_IN_LOT_LIST lill ON lill.SPE_CODE = pl.SPE_CODE AND lill.BUN_CODE = pl.BUN_CODE AND lill.LOL_CODE = pl.LOL_CODE
LEFT JOIN TRAIT_PROFILE tp ON tp.SPE_CODE = lill.SPE_CODE AND tp.BUN_CODE = pl.BUN_CODE AND tp.TPF_NAME = '{plot_profile}'
LEFT JOIN TRAIT_PROFILE_VARIABLE tpv ON tpv.SPE_CODE = tp.SPE_CODE AND tpv.TPF_ID = tp.TPF_ID
JOIN LOT_IN_PLOT lip ON lip.SPE_CODE = lill.SPE_CODE AND lip.BUN_CODE = lill.BUN_CODE AND lip.LLI_ID = lill.LLI_ID
LEFT JOIN PLANT_VALUE pav ON pav.SPE_CODE = lill.SPE_CODE AND pav.BUN_CODE = lill.BUN_CODE AND pav.LLI_ID = lill.LLI_ID AND pav.TRV_ID = tpv.TRV_ID --AND pov.TRV_ID IN (SELECT TRV_ID FROM tmp_PROF_PLOT_PLANT)
LEFT JOIN TRAIT_VARIABLE tv ON tv.SPE_CODE = tpv.SPE_CODE AND tv.TRV_ID = tpv.TRV_ID
JOIN LOT_GENETIC_INFORMATION lgi ON lill.SPE_CODE = lgi.SPE_CODE AND lill.BUN_CODE = lgi.BUN_CODE AND lgi.LOT_ID_MASTER_LOT = lill.LOT_ID
LEFT JOIN CULTIVAR cul ON cul.SPE_CODE = lgi.SPE_CODE AND cul.GSU_CODE = lgi.BUN_CODE AND cul.CUL_ID = lgi.CUL_ID
LEFT JOIN START stt ON stt.SPE_CODE = lgi.SPE_CODE AND stt.BUN_CODE = lgi.BUN_CODE AND stt.STT_ID = lgi.STT_ID
LEFT JOIN LOT_GENETIC_INFORMATION lgi_m ON lill.SPE_CODE = lgi_m.SPE_CODE AND lill.BUN_CODE = lgi_m.BUN_CODE AND lgi_m.LGI_ID = lgi.LGI_ID_MALE_PARENT
LEFT JOIN LOT l_m ON l_m.SPE_CODE = lgi_m.SPE_CODE AND l_m.BUN_CODE = lgi_m.BUN_CODE AND l_m.LGI_ID = lgi_m.LGI_ID
LEFT JOIN CULTIVAR cul_m ON cul_m.SPE_CODE = lgi_m.SPE_CODE AND cul_m.GSU_CODE = lgi_m.BUN_CODE AND cul_m.CUL_ID = lgi_m.CUL_ID
LEFT JOIN START stt_m ON stt_m.SPE_CODE = lgi_m.SPE_CODE AND stt_m.BUN_CODE = lgi_m.BUN_CODE AND stt_m.STT_ID = lgi_m.STT_ID
LEFT JOIN LOT_GENETIC_INFORMATION lgi_f ON lill.SPE_CODE = lgi_f.SPE_CODE AND lill.BUN_CODE = lgi_f.BUN_CODE AND lgi_f.LGI_ID = lgi.LGI_ID_PARENT
LEFT JOIN LOT l_f ON l_f.SPE_CODE = lgi_f.SPE_CODE AND l_f.BUN_CODE = l_f.BUN_CODE AND l_f.LGI_ID = lgi_f.LGI_ID
LEFT JOIN CULTIVAR cul_f ON cul_f.SPE_CODE = lgi_f.SPE_CODE AND cul_f.GSU_CODE = lgi_f.BUN_CODE AND cul_f.CUL_ID = lgi_f.CUL_ID
LEFT JOIN START stt_f ON stt_f.SPE_CODE = lgi_f.SPE_CODE AND stt_f.BUN_CODE = lgi_f.BUN_CODE AND stt_f.STT_ID = lgi_f.STT_ID
WHERE pl.SPE_CODE = 'PE'
AND pl.BUN_CODE = 'C'
AND pl.LOL_CODE = '{lol_code}'
and lip.LPL_PLOT_NR between {plot1} and {plot2}
ORDER BY 4,5,9,10,11
Name
PLOT_NR
Name
Relation2
PLOT_NR
,lol_code,lol_code,,System.String,,False,False,False,False
,plot_profile,plot_profile,,System.String,,False,False,False,False
,plot1,plot1,,System.String,,False,False,False,False
,plot2,plot2,,System.String,,False,False,False,False
,lot_profile,lot_profile,,System.String,,False,False,False,False
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
0.25
Transparent
0,0.4,27.7,0.6
Transparent
0,0,2.79,0.6
Arial,12,Bold
e9597d9f5f6e4bcfb0f80ecd7dbc985e
0,0,0,0
Text2
{plots.PLOT_NR}
Black
Expression
{plots.PLOT_NR}
3e080e007b454e229d8eda4e80f0935f
GroupHeaderBand2
Transparent
0,1.8,27.7,0.8
Transparent
0,0,2.8,0.8
Transparent
0,0.4,2.8,0.4
Arial,8
dc8bc859713646478957ccf9bb365930
0,0,0,0
Text3
{plots.LOT_CODE}
Black
Expression
Transparent
0,0,2.8,0.4
Arial,8
7e7871ab94e84d9eb11e572dd9c54d44
0,0,0,0
Text5
Reference
Black
Expression
1af6994241914421b92a30bef92b1569
CrossHeaderBand1
StiDataHelper.SetData(CrossDataBand1, true);
Transparent
2.8,0,1.4,0.8
[229:185:183]
0,0,1.4,0.4
Arial,8
70cb18b484c6463baf4fc02ac57e6ba9
0,0,0,0
Text1
{lot_data.TRV_CODE}
Black
Expression
[242:220:219]
0,0.4,1.4,0.4
Arial,8
c677c4daf0af4d119bb0ac92444d2114
0,0,0,0
Text4
{lot_data.TEN_VALUE}
Black
Expression
lot_data
_x007B_plots.PLOT_NR_x003D__x003D_lot_data.PLOT_NR_x007D_
32f81218fb914f4d9d56c0f40b6ee1f6
CrossDataBand1
{plots.LOT_CODE}
05b24b5e3b9747d3aa8256a44e2800e1
GroupHeaderBand3
Transparent
0,3.4,27.7,0
plots
6bfef84626bf43ec84d09ebebb36d27f
DataSheet1
Transparent
0,4.2,27.7,0
9fb9bec635a142d0bbd0a4a283156564
GroupFooterBand2
Transparent
True
0,5,27.7,4.07
Transparent
True
0,0,19.56,4.06
Transparent
0,0.4,19.56,0.8
Transparent
0,0,2.8,0.8
All;Black;1;Solid;False;4;Black
Transparent
1.4,0.4,1.4,0.4
Arial,8
3163c59f935a4fdbb3f5200d674c7a7d
0,0,0,0
Text7
{plants.PLANT_NR}
Black
DataColumn
All;Black;1;Solid;False;4;Black
Transparent
0,0.4,1.4,0.4
Arial,8
6d7b87367ed648eeb175b630c6d6e378
0,0,0,0
Text10
{plants.PLOT_NR}
Black
DataColumn
9deba671162c40128852d59fc0b5c2a9
CrossHeaderBand2
StiDataHelper.SetData(CrossDataBand2, true);
Transparent
2.8,0,1.4,0.8
All;Black;1;Solid;False;4;Black
[141:179:226]
0,0,1.4,0.4
Arial,8
57d1fcf2c430449aa1a378390704ac2e
0,0,0,0
Text6
{scoring_data.TRV_CODE}
Black
Expression
All;Black;1;Solid;False;4;Black
[219:229:241]
0,0.4,1.4,0.4
Arial,8
b2efe6aa1d8e4512bfe9873922204ca2
0,0,0,0
Text9
{scoring_data.TEN_VALUE}
Black
Expression
scoring_data
_x007B_scoring_data.PLOT_NR_x0020__x003D__x003D__x0020_plants.PLOT_NR_x0020__x0026__x0026__x0020_scoring_data.PLANT_NR_x0020__x003D__x003D__x0020_plants.PLANT_NR_x007D_
fb2f4d46516f454b8af727eac4eb1cda
CrossDataBand2
Relation2
plants
_x007B_plants.PLOT_NR_x003D__x003D_plots.PLOT_NR_x007D_
dc76eb9211c442ff971d49b65963e95d
DataDataSource1
6c24a931314f460e9201d61c6ad10af7
Panel1
eb33efaf73014df99701f72109e60ff0
GroupFooterBand3
False
570a1a7193dd4975ba739ecc83a94c03
1,1,0.4,0.4
Page2
Landscape
21
29.7
A4
False
True
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
0.25
Transparent
0,0.4,27.7,0.6
Transparent
0,0,2.79,0.6
Arial,12,Bold
e9597d9f5f6e4bcfb0f80ecd7dbc985e
0,0,0,0
Text11
{plots.PLOT_NR}
Black
Expression
{plots.PLOT_NR}
3e080e007b454e229d8eda4e80f0935f
GroupHeaderBand4
Transparent
0,1.8,27.7,0.8
Transparent
0,0,2.8,0.8
Transparent
0,0.4,2.8,0.4
Arial,8
dc8bc859713646478957ccf9bb365930
0,0,0,0
Text12
{plots.LOT_CODE}
Black
Expression
Transparent
0,0,2.8,0.4
Arial,8
7e7871ab94e84d9eb11e572dd9c54d44
0,0,0,0
Text13
Reference
Black
Expression
1af6994241914421b92a30bef92b1569
CrossHeaderBand3
StiDataHelper.SetData(CrossDataBand1, true);
Transparent
2.8,0,1.4,0.8
[229:185:183]
0,0,1.4,0.4
Arial,8
70cb18b484c6463baf4fc02ac57e6ba9
0,0,0,0
Text14
{lot_data.TRV_CODE}
Black
Expression
[242:220:219]
0,0.4,1.4,0.4
Arial,8
c677c4daf0af4d119bb0ac92444d2114
0,0,0,0
Text15
{lot_data.TEN_VALUE}
Black
Expression
lot_data
_x007B_plots.PLOT_NR_x003D__x003D_lot_data.PLOT_NR_x007D_
32f81218fb914f4d9d56c0f40b6ee1f6
CrossDataBand3
{plots.LOT_CODE}
05b24b5e3b9747d3aa8256a44e2800e1
GroupHeaderBand5
Transparent
0,3.4,27.7,0
plots
6bfef84626bf43ec84d09ebebb36d27f
DataBand2
Transparent
0,4.2,27.7,0
9fb9bec635a142d0bbd0a4a283156564
GroupFooterBand4
Transparent
True
0,5,27.7,4.07
Transparent
True
0,0,19.56,4.06
Transparent
0,0.4,19.56,0.8
Transparent
0,0,6.8,1.4
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
1.6,1.3,0,0
Arial,8
1aaae99612794b45b510036564dcf849
0,0,0,0
CrossTab3_RowTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0.45,1.6,0.4
Arial,8
3b73357e1f754fe4abdf5e5a9911727d
0,0,0,0
CrossTab3_Row1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
PLANT_NR
[105:105:105]
Row:CrossTab3_Row1
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
3.65,0.45,0,0.4
Arial,8
de6f20de351145d8931f35748258f3ec
0,0,0,0
CrossTab3_ColTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0,3.2,0.4
Arial,8
c6e3053ee76d45d28f08bbe415e0835e
0,0,0,0
CrossTab3_LeftTitle
AllowMove, AllowResize, AllowSelect, AllowChange
scoring_data
[105:105:105]
LeftTitle
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
0,1.3,3.2,0
Arial,8
c437b3cc6c30471aa1b8a2d1816d9fc7
0,0,0,0
CrossTab3_RowTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
1.6,0.45,1.6,0.4
Arial,8
767c5543799e4fe2aea08b33ab636cf8
0,0,0,0
CrossTab3_Row2_Title
AllowMove, AllowResize, AllowSelect, AllowChange
PLANT_NR
[105:105:105]
Row:CrossTab3_Row2
All;[155:155:155];1;Solid;False;4;Black
White
3.25,0,1.8,0.4
Arial,8
b1d19f6b5a414d6baf0f0ef04a676f5e
0,0,0,0
CrossTab3_RightTitle
AllowMove, AllowResize, AllowSelect, AllowChange
TRV_CODE
[105:105:105]
RightTitle
PLOT_NR
All;[155:155:155];1;Solid;False;4;Black
White
0,0.9,1.6,0.4
{scoring_data.PLOT_NR}
Arial,8
2d6c56d97bd343c68bb9cc89523c9d12
0,0,0,0
CrossTab3_Row1
AllowMove, AllowResize, AllowSelect, AllowChange
False
PLOT_NR
[105:105:105]
c437b3cc6c30471aa1b8a2d1816d9fc7
{scoring_data.PLOT_NR}
PLANT_NR
All;[155:155:155];1;Solid;False;4;Black
White
1.6,0.9,1.6,0.4
{scoring_data.PLANT_NR}
Arial,8
11558a9e4a0d4160b2d6ffdf1bd3d862
0,0,0,0
CrossTab3_Row2
AllowMove, AllowResize, AllowSelect, AllowChange
False
PLANT_NR
[105:105:105]
1aaae99612794b45b510036564dcf849
{scoring_data.PLANT_NR}
TRV_CODE
All;[155:155:155];1;Solid;False;4;Black
White
3.25,0.45,1.8,0.4
{scoring_data.TRV_CODE}
Arial,8
48e0606aa71442c483aa76f1862e663e
0,0,0,0
CrossTab3_Column1
AllowMove, AllowResize, AllowSelect, AllowChange
False
TRV_CODE
[105:105:105]
de6f20de351145d8931f35748258f3ec
{scoring_data.TRV_CODE}
TEN_VALUE
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
3.25,0.9,1.8,0.4
Arial,8
0261a621a58b4b489698301748dfc840
0,0,0,0
CrossTab3_Sum1
AllowMove, AllowResize, AllowSelect, AllowChange
0
Black
{scoring_data.TEN_VALUE}
scoring_data
_x007B_scoring_data.PLOT_NR_x0020__x003D__x003D__x0020_plants.PLOT_NR_x0020__x0026__x0026__x0020_scoring_data.PLANT_NR_x0020__x003D__x003D__x0020_plants.PLANT_NR_x007D_
CrossTab3
Relation2
plants
_x007B_plants.PLOT_NR_x003D__x003D_plots.PLOT_NR_x007D_
dc76eb9211c442ff971d49b65963e95d
DataBand4
6c24a931314f460e9201d61c6ad10af7
Panel2
eb33efaf73014df99701f72109e60ff0
GroupFooterBand5
e9d56a1948d24e20a76bd2341b365d67
1,1,0.4,0.4
Page3
Landscape
21
29.7
A4
False
True
Arial,100
[50:0:0:0]
None;Black;2;Solid;False;4;Black
Transparent
0.25
Transparent
0,19.8,27.7,0.4
Transparent
6.2,0,14,0.4
Arial,10
e7c56ffee1c54c1bb29bf946abf762d9
Right
0,0,0,0
Text8
{"Printed on: "+ Format("{0:yyyy-MM-dd}", Today)+", "+PageNofM}
Black
Expression
PageFooterBand1
Transparent
0,0.4,27.7,1.2
Transparent
0,0,7.6,1.4
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
0,0.9,1.4,0
Arial,8
df5fb790205247c1ba0ceb82366b1de0
0,0,0,0
CrossTab1_RowTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0.45,1.4,0.4
Arial,8
ea70eab369214660bb630f84493cefcb
0,0,0,0
CrossTab1_Row1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
PLOT_NR
[105:105:105]
Row:CrossTab1_Row1
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
1.4,0.9,1.8,0
Arial,8
92c5de6439c643efba08f76b551147b1
0,0,0,0
CrossTab1_RowTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
1.4,0.45,1.8,0.4
Arial,8
d491795944ed4c2bb17190d89a5c48f3
0,0,0,0
CrossTab1_Row2_Title
AllowMove, AllowResize, AllowSelect, AllowChange
LGI_FAMILY
[105:105:105]
Row:CrossTab1_Row2
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
5.05,0.45,0,0.4
Arial,8
8b3c39e5d2054983afed51ac9801322e
0,0,0,0
CrossTab1_ColTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0,3.2,0.4
Arial,8
835792facab24579a3107f12ecdf7703
0,0,0,0
CrossTab1_LeftTitle
AllowMove, AllowResize, AllowSelect, AllowChange
lot_data
[105:105:105]
LeftTitle
All;[155:155:155];1;Solid;False;4;Black
White
3.25,0,1.8,0.4
Arial,8
b0839b2056164a78b33d20ef275aed0a
0,0,0,0
CrossTab1_RightTitle
AllowMove, AllowResize, AllowSelect, AllowChange
TRV_CODE
[105:105:105]
RightTitle
PLOT_NR
All;[155:155:155];1;Solid;False;4;Black
White
0,0.9,1.4,0.4
{lot_data.PLOT_NR}
Arial,8
bb78e8993364415886d12bbca04ff648
0,0,0,0
CrossTab1_Row1
AllowMove, AllowResize, AllowSelect, AllowChange
False
PLOT_NR
[105:105:105]
df5fb790205247c1ba0ceb82366b1de0
{lot_data.PLOT_NR}
LGI_FAMILY
All;[155:155:155];1;Solid;False;4;Black
White
1.4,0.9,1.8,0.4
{lot_data.LGI_FAMILY}
Arial,8
64362812543649d89438d3002f458b3c
0,0,0,0
CrossTab1_Row2
AllowMove, AllowResize, AllowSelect, AllowChange
False
LGI_FAMILY
[105:105:105]
92c5de6439c643efba08f76b551147b1
{lot_data.LGI_FAMILY}
TRV_CODE
All;[155:155:155];1;Solid;False;4;Black
White
3.25,0.45,1.8,0.4
{lot_data.TRV_CODE}
Arial,8
6086b0a1074240f1a6efcf1bd2acc4b6
0,0,0,0
CrossTab1_Column1
AllowMove, AllowResize, AllowSelect, AllowChange
False
TRV_CODE
[105:105:105]
8b3c39e5d2054983afed51ac9801322e
{lot_data.TRV_CODE}
TEN_VALUE
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
3.25,0.9,1.8,0.4
Arial,8
7703b4640a344240a010ef7ac5bf1601
0,0,0,0
CrossTab1_Sum1
AllowMove, AllowResize, AllowSelect, AllowChange
None
0
Black
{lot_data.TEN_VALUE}
lot_data
_x007B_plots.PLOT_NR_x003D__x003D_lot_data.PLOT_NR_x007D_
CrossTab1
ASC
PLOT_NR
{plots.PLOT_NR}
GroupHeaderBand1
Transparent
0,2.4,27.7,0
plots
DataBand1
Transparent
0,3.2,27.7,1.4
[242:220:219]
0,0,6.4,1.4
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
0,0.9,1.4,0
Arial,8
81d5c82a8c284e3387d5b7e04d06f7f7
0,0,0,0
CrossTab2_RowTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0.45,1.4,0.4
Arial,8
2ed302005f6741f2ad8fa2aa9cacbbee
0,0,0,0
CrossTab2_Row1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
PLOT_NR
[105:105:105]
Row:CrossTab2_Row1
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
1.4,0.9,1.6,0
Arial,8
5605d964e18149c587f233a953dd27b7
0,0,0,0
CrossTab2_RowTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
1.4,0.45,1.6,0.4
Arial,8
eed4376f23d3421a9acf690f3d11dcfa
0,0,0,0
CrossTab2_Row2_Title
AllowMove, AllowResize, AllowSelect, AllowChange
PLANT_NR
[105:105:105]
Row:CrossTab2_Row2
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
4.85,0.45,0,0.4
Arial,8
4c17bcecb4aa4a8fbb82314e8554d859
0,0,0,0
CrossTab2_ColTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0,3,0.4
Arial,8
bcfe844b75094f1290f17134979d4f46
0,0,0,0
CrossTab2_LeftTitle
AllowMove, AllowResize, AllowSelect, AllowChange
scoring_data
[105:105:105]
LeftTitle
All;[155:155:155];1;Solid;False;4;Black
White
3.05,0,1.8,0.4
Arial,8
7dd425c4b60247f8814a9ae47f97490a
0,0,0,0
CrossTab2_RightTitle
AllowMove, AllowResize, AllowSelect, AllowChange
TRV_CODE
[105:105:105]
RightTitle
PLOT_NR
All;[155:155:155];1;Solid;False;4;Black
White
0,0.9,1.4,0.4
{scoring_data.PLOT_NR}
Arial,8
bc27b288cd62431aa46a1b7d3ceb938c
0,0,0,0
CrossTab2_Row1
AllowMove, AllowResize, AllowSelect, AllowChange
False
PLOT_NR
[105:105:105]
81d5c82a8c284e3387d5b7e04d06f7f7
{scoring_data.PLOT_NR}
PLANT_NR
All;[155:155:155];1;Solid;False;4;Black
White
1.4,0.9,1.6,0.4
{scoring_data.PLANT_NR}
Arial,8
9255c01b37e140349fb7cb0f42238c60
0,0,0,0
CrossTab2_Row2
AllowMove, AllowResize, AllowSelect, AllowChange
False
PLANT_NR
[105:105:105]
5605d964e18149c587f233a953dd27b7
{scoring_data.PLANT_NR}
TRV_CODE
All;[155:155:155];1;Solid;False;4;Black
White
3.05,0.45,1.8,0.4
{scoring_data.TRV_CODE}
Arial,8
dba3847aa64a424ca388eb4c5db807cf
0,0,0,0
CrossTab2_Column1
AllowMove, AllowResize, AllowSelect, AllowChange
False
TRV_CODE
[105:105:105]
4c17bcecb4aa4a8fbb82314e8554d859
{scoring_data.TRV_CODE}
TEN_VALUE
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
3.05,0.9,1.8,0.4
Arial,8
f535f514d3994f48bcd3e1643352249f
0,0,0,0
CrossTab2_Sum1
AllowMove, AllowResize, AllowSelect, AllowChange
None
0
Black
{scoring_data.TEN_VALUE}
Relation
scoring_data
_x007B_plots.PLOT_NR_x003D__x003D_scoring_data.PLOT_NR_x007D_
CrossTab2
GroupFooterBand1
Transparent
0,5.4,27.7,1.6
Relation
scoring_data
False
DataBand3
False
4b573c785fc6412a9c476476d5de6a39
1,1,0.4,0.4
Page1
Landscape
21
29.7
A4
False
True
Arial,100
[50:0:0:0]
Control
Window
40,32,280,20
Microsoft Sans Serif,8
Black
list.LOL_CODE
40, 32
ComboBoxControl1
list.LOL_CODE
list.LOL_CODE
280, 20
True
list.LOL_CODE
PT19-00069
list.LOL_CODE
lol_code=ComboBoxControl1.Control.Text;
lot_profile=ComboBoxControl2.Control.Text;
plot_profile=ComboBoxControl2.Control.Text;
plot1=TextBoxControl1.Text;
plot2=TextBoxControl2.Text;
lot_data.Connect();
lot_data.ConnectOnStart=true;
scoring_data.Connect();
scoring_data.ConnectOnStart=true;
plots.Connect();
plots.ConnectOnStart=true;
plants.Connect();
plants.ConnectOnStart=true;
48,168,104,32
True
OK
Microsoft Sans Serif,8
Black
48, 168
ButtonControl1
104, 32
OK
160,168,104,32
Cancel
Microsoft Sans Serif,8
Black
22d2cb5fc6284f0793dbf9876a3eac37
160, 168
ButtonControl2
104, 32
Cancel
Control
0,32,40,16
Microsoft Sans Serif,8
Black
0, 32
LabelControl1
40, 16
Liste
Window
144,72,176,20
Microsoft Sans Serif,8
Black
62fd7c962cd24a39bce654b6aae46788
trait_profiles.TPF_NAME
144, 72
ComboBoxControl2
trait_profiles.TPF_NAME
trait_profiles.TPF_NAME
176, 20
True
trait_profiles.TPF_NAME
Combo Box
trait_profiles.TPF_NAME
Control
0,72,104,16
Microsoft Sans Serif,8
Black
41842d344c304d71b0c308fbb33e3427
0, 72
LabelControl2
104, 16
Profile for lot values
Window
144,104,176,20
Microsoft Sans Serif,8
Black
b371d7879f4642c7b8983d4b0b6cf45f
trait_profiles.TPF_NAME
144, 104
ComboBoxControl3
trait_profiles.TPF_NAME
trait_profiles.TPF_NAME
176, 20
True
trait_profiles.TPF_NAME
Combo Box
trait_profiles.TPF_NAME
Control
0,104,136,16
Microsoft Sans Serif,8
Black
7bbdbb1dd9b14fa18c4097f5c236968a
0, 104
LabelControl3
136, 16
Profile for plot/plant values
Window
72,136,96,20
Microsoft Sans Serif,8
Black
72, 136
TextBoxControl1
96, 20
3351
Window
184,136,96,20
Microsoft Sans Serif,8
Black
184, 136
TextBoxControl2
96, 20
Microsoft Sans Serif,8
e062eb0dfdf1472e92df93217d160c13
0, 0
Form1
336, 232
Form1
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Report
6/28/2019 12:19:43 PM
9/18/2012 11:03:34 PM
C:\Users\jennifer.pouillard\Desktop\Field book draft.mrt
593c4d5f40ca40ccbe4ea7090cf3cc0a
Report
Centimeters
2018.2.3.0
CSharp