Здравствуйте.
Есть следующий запрос в ADOQuery в fastreport:

SELECT
T1.ID_CAR,
T1.NUMBER_TC,
T1.SIGNAL,
SUM_DISTANCE = ROUND(T3.SUM_DISTANCE*0.001, 3), -- ÏÐÎÁÅÃ
SUM_FUEL = ROUND(T3.SUM_FUEL, 3), -- ÐÀÑÕÎÄ ÒÎÏËÈÂÀ
SUM_STOP_TIME = CONVERT(VARCHAR, DATEADD(SS, T1.SUM_STOP_TIME, 0), 108), -- ÂÐÅÌß ÑÒÎßÍÊÈ
SUM_RUN_TIME = CONVERT(VARCHAR, DATEADD(SS,(DATEDIFF (SS, T3.MIN_DATE, T3.MAX_DATE) - T1.SUM_STOP_TIME), 0), 108) -- ÂÐÅÌß ÄÂÈÆÅÍÈß
FROM
( SELECT
ID_CAR,
NUMBER_TC,
SIGNAL,
SUM_STOP_TIME = dbo.Calc_CarStopTime(ID_CAR, :BEGINDATE, :ENDDATE) -- ÂÐÅÌß ÑÒÎßÍÊÈ
FROM CARS
WHERE DELETE_DATE IS NULL
) AS T1
JOIN
(-- ÐÀÑ×ÈÒÛÂÀÅÌ ÒÎÏËÈÂÎ È ÐÀÑÑÒÎßÍÈÅ
SELECT DISTINCT
T2.ID_CAR,
SUM_DISTANCE = SUM (T2.DISTANCE) OVER (PARTITION BY T2.ID_CAR),
SUM_FUEL = SUM (T2.FUEL) OVER (PARTITION BY T2.ID_CAR),
MAX_DATE = MAX (T2.RECV_DATE) OVER (PARTITION BY T2.ID_CAR),
MIN_DATE = MIN (T2.RECV_DATE) OVER (PARTITION BY T2.ID_CAR)
FROM
NAVIGATIONS AS T2
WHERE
T2.RECV_DATE > :BEGINDATE AND
T2.RECV_DATE <= :ENDDATE
) AS T3 ON T1.ID_CAR = T3.ID_CAR
INNER JOIN CARGROUPS AS T4 ON T1.ID_CAR = T4.ID_CAR
INNER JOIN CLIENTS_GROUPS AS T5 ON T4.ID_GROUP = T5.ID_GROUP
INNER JOIN CLIENTS AS T6 ON T5.ID_CLIENT = T6.ID_CLIENT
WHERE
T6.WORK_STATE = 1 AND
T4.DELETE_DATE IS NULL AND
T5.DELETE_DATE IS NULL AND
T6.DELETE_DATE IS NULL

Подскажите, пожалуйста, в каком виде задать параметры :DEGINDATE и :ENDDATE (они как Datetime) и как сделать, чтобы в банде отображались ID_CAR и т.д. (На данный момент не отображаются)

Модератор: Тема перенесена из форума "Microsoft SQL Server".