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))