nick_mi,

Так работать будет, в hytech нельзя сравнивать поля после where. Только в select.
Еще закомментировал три таблицы которые есть в select, но нигде не используются.

// Отличие профиля в заявке и в путевке

fix all;

var @d1=$31-12-2014, @d2=today();
// @mask="%`NNN|-|NNN|-|NNN| |NN `s",
// @y=year(@d1)-2000;

fix all;
select

ID_FSS as "Филиал:",
SCTREAT as "",
PCTREAT,
FIO as "ФИО",
REQNUM as "№ заявки",
REQDATE as "Дата заявки",
DOCNUM as "путевка №",
DAYINS as "заезд: ",
PROFZ as "Профиль по заявке",
CNAME as "Профиль по путевке"

from (
select SQ.ID_FSS as ID_FSS ,
SQ.CTREAT as SCTREAT,
PT.CTREAT as PCTREAT,
char(SQ.LNAME + " " + SQ.FNAME + " " + SQ.MNAME, 50) as FIO,
SQ.REQNUM as REQNUM,
SQ.REQDATE as REQDATE,
SQ.DOCNUM as DOCNUM ,
PT.DAYINS as DAYINS,
CT.NAME as PROFZ,
CT.NAME as CNAME ,
SQ.CTREAT-PT.CTREAT as R

from SQUEUE SQ, PTOUR PT, CTREATM CT//, LQUEUE LQ, PFRO PF, TRNPMF TRN
where SQ.STATE=1 //распределенная заявка на этот год
and SQ.REQYEAR=15 // год заявки - 20000
and PT.BDAT between @d1 and @d2 // дата накладной
and SQ.ID_OWN=PT.IDL )

where R != 0
;