I have a report and Sql Query but my report cant read fields.
WITH
T
AS
(
SELECT
P.PARAMETRE_ADI
AS
ID,HI.ISTASYON_ADI,HTS.TUR_ID
AS
TID
FROM
HALKALAMA_CALISMALARI t
JOIN
HALKALAMA_TUR_SAYILARI HTS
ON
HTS.HALKALAMA_CALISMA_ID = T.ID
JOIN
HALKALAMA_ISTASYONLARI HI
ON
HI.ID = T.HALKALAMA_ISTASYON_ID
JOIN
PARAMETRELER P
ON
P.ID = T.PARAM_HALKALAMA_DONEMI_ID)
SELECT
ISTASYON_ADI,ILKBAHAR_TUR, ILKBAHAR_BIREY,SONBAHAR_TUR,SONBAHAR_BIREY
FROM
T PIVOT(
COUNT
(
DISTINCT
TID)
AS
TUR,
COUNT
(*)
AS
BIREY
FOR
ID
IN
(
'İlkbahar'
AS
ILKBAHAR,
'Sonbahar'
AS
SONBAHAR))