В помощь по BI Publisher
SELECT s.code, s.name, s.unit, h.a_val a_val, h.tstamp
FROM svod_code s
LEFT OUTER JOIN h2 h ON (s.code=h.code)
WHERE
h.a_stat='1'
AND
s.type=:pType AND s.nserv=:pServ AND h.tstamp=:pStamp
ORDER BY 1
select
CONCAT(
SUBSTRING(tstamp,1,4),"-",
SUBSTRING(tstamp,5,2),"-",
SUBSTRING(tstamp,7,2)," ",
SUBSTRING(tstamp,9,2),":",
SUBSTRING(tstamp,11,2)
) label,
tstamp from th2 order by 2 desc;
Образец отчета "Журнал недостоверных значений"
