Merhabalar,

Stok cari analiz raporunu excele aldirabilirmiyiz.

Tesekkürler.

Excel raportördeki isleyisle.

Kodlara ulastim ama veri çekemiyorum.

SELECT     dbo.STHAR.SUBE_KODU, dbo.STHAR.STOK_KODU, dbo.STSABIT.STOK_ADI, dbo.STSABIT.GRUP_KODU AS SGRUP_KODU, dbo.STGRUP.GRUP_ISIM AS SGRUP_ISIM,
                       dbo.STSABIT.KOD_1 AS SKOD_1, dbo.STOKKOD1.GRUP_ISIM AS SKOD1_ISIM, dbo.STSABIT.KOD_2 AS SKOD_2, dbo.STOKKOD2.GRUP_ISIM AS SKOD2_ISIM,
                      dbo.STSABIT.SATICI_KODU, dbo.STHAR.STHAR_ACIKLAMA, dbo.CASABIT.CARI_ISIM, dbo.CASABIT.CARI_TIP, dbo.CASABIT.GRUP_KODU AS CGRUP_KODU,
                      dbo.CASABIT.RAPOR_KODU1 AS CKOD_1, dbo.CARIKOD1.GRUP_ISIM AS CKOD1_ISIM, dbo.CASABIT.RAPOR_KODU2 AS CKOD_2, dbo.CASABIT.CARI_IL,
                      dbo.CASABIT.CARI_ILCE, dbo.STHAR.STHAR_HTUR, dbo.STHAR.STHAR_KOD1, dbo.STHAR.STHAR_KOD2, dbo.STHAR.STHAR_TARIH,
                      dbo.STHAR.FISNO AS STHAR_FISNO, dbo.STHAR.AMBAR_KABULNO, dbo.STHAR.IRSALIYE_NO, dbo.STHAR.STHAR_ODEGUN, dbo.STHAR.STHAR_BF,
                      dbo.STHAR.STHAR_NF, dbo.STHAR.STHAR_IAF,
                      (dbo.STHAR.STHAR_BF - dbo.STHAR.STHAR_NF * (CASE WHEN FATUIRS.KDV_DAHILMI = 'E' THEN (1 + STHAR.STHAR_KDV / 100) ELSE 1 END))
                      * dbo.STHAR.STHAR_GCMIK AS ISKONTOTUT,
                      CASE WHEN STHAR.STHAR_SATISK < 0.00100 THEN STHAR.STHAR_SATISK * 100000 ELSE STHAR.STHAR_SATISK END AS STHAR_SATISK,
                      dbo.STHAR.STHAR_MALFISK, dbo.STSABIT.OLCU_BR1, dbo.STSABIT.OLCU_BR2, dbo.STSABIT.OLCU_BR3,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS GIRISM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS GRISIM2,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS GIRISM3,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_NF AS NETGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_BF AS BRUTGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_IAF AS IADEGIRISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) AS CIKISM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA_1 = 0 THEN 0 ELSE (STSABIT.PAY_1 / STSABIT.PAYDA_1) END) AS CIKISM2,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * (CASE WHEN STSABIT.PAYDA2 = 0 THEN 0 ELSE (STSABIT.PAY2 / STSABIT.PAYDA2) END) AS CIKISM3,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_NF AS NETCIKISTUT,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END) * dbo.STHAR.STHAR_BF AS BRUTCIKISTUT, dbo.STHAR.STHAR_KDV,
                      dbo.STHAR.STHAR_GCMIK * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS KDV_TUT, dbo.STHAR.STHAR_SIPNUM, dbo.STHAR.STHAR_DOVTIP,
                      dbo.STHAR.STHAR_DOVFIAT, dbo.STHAR.STHAR_GCMIK * dbo.STHAR.STHAR_DOVFIAT AS DOVIZ_TUTARI,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_GIRIS_MIKTAR,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK2 ELSE 0 END) AS IKINCI_CIKIS_MIKTAR,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * dbo.STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'G' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS ALIS_TOPLAM, (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * dbo.STHAR.STHAR_NF + (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN STHAR.STHAR_GCMIK ELSE 0 END)
                      * dbo.STHAR.STHAR_NF * dbo.STHAR.STHAR_KDV / 100 AS SATIS_TOPLAM, dbo.STHAR.CEVRIM,
                      (CASE WHEN STHAR.STHAR_GCKOD = 'C' THEN (STHAR.CEVRIM * STHAR.STHAR_GCMIK * STHAR.STHAR_NF) ELSE 0 END) AS BEKLEME_ADATI,
                      dbo.STSABITEK.TUR, dbo.STSABITEK.MGRUP AS MRUP, dbo.STSABITEK.INGISIM, dbo.STSABITEK.KULL1N, dbo.STSABITEK.KULL2N, dbo.STSABITEK.KULL1S,
                      dbo.STSABITEK.KULL2S, dbo.STHAR.DEPO_KODU, dbo.STHAR.PROMASYON_KODU, dbo.STHAR.BAGLANTI_NO, dbo.STHAR.VADE_TARIHI, dbo.STHAR.LISTE_NO,
                      dbo.STHAR.LISTE_FIAT, dbo.CARIKOD2.GRUP_ISIM AS CKOD2_ISIM, dbo.STHAR.PLASIYER_KODU AS PLAS_KOD, dbo.STHAR.PROJE_KODU,
                      dbo.STHAR.EKALAN_NEDEN, dbo.STHAR.EKALAN, dbo.STHAR.EKALAN1 AS EKALAN2, dbo.STHAR.MUH_KODU AS MUHKODU, dbo.PROJE.PROJE_ACIKLAMA,
                      ISKONTIP1.ACIKLAMA AS ISKONTO1_ACIKLAMA, ISKONTIP2.ACIKLAMA AS ISKONTO2_ACIKLAMA, ISKONTIP3.ACIKLAMA AS ISKONTO3_ACIKLAMA,
                      (CASE WHEN (STSABIT.B_YEDEK7 = 1) OR
                      (STSABIT.B_YEDEK7 = 2) THEN 'E' ELSE 'H' END) AS KITSTOGU,
                      (CASE WHEN STHAR.L_YEDEK9 = - 1 THEN 'K' ELSE (CASE WHEN STHAR.L_YEDEK9 > 0 THEN 'B' ELSE 'N' END) END) AS KITHAREKETI,
                      dbo.STSABIT.KOD_3 AS KOD3, dbo.STSABIT.KOD_4 AS KOD4, dbo.STSABIT.KOD_5 AS KOD5, dbo.CASABIT.RAPOR_KODU3 AS CKOD_3,
                      dbo.CASABIT.RAPOR_KODU4 AS CKOD_4, dbo.CASABIT.RAPOR_KODU5 AS CKOD_5, dbo.STHAR.YAPKOD,
                      CASE WHEN STSABIT.YAPILANDIR = 'E' THEN DBO.NSF_YAPACIK(STHAR.YAPKOD, STOKPARAM.C_YEDEK8, ESNYAPMAS.YAPACIK) ELSE NULL
                      END AS YAPACIK
FROM         dbo.STHAR INNER JOIN
                      dbo.STSABIT ON dbo.STHAR.STOK_KODU = dbo.STSABIT.STOK_KODU INNER JOIN
                      dbo.NETCONTEXT ON 1 = 1 INNER JOIN
                      dbo.TBLSTOKPARAM AS STOKPARAM WITH (NOLOCK) ON STOKPARAM.ISLETME_KODU = dbo.NETCONTEXT.V$ISLETME_KODU LEFT OUTER JOIN
                      dbo.STGRUP ON dbo.STSABIT.GRUP_KODU = dbo.STGRUP.GRUP_KOD LEFT OUTER JOIN
                      dbo.CASABIT ON dbo.STHAR.STHAR_ACIKLAMA = dbo.CASABIT.CARI_KOD INNER JOIN
                      dbo.STSABITEK ON dbo.STSABIT.STOK_KODU = dbo.STSABITEK.STOK_KODU LEFT OUTER JOIN
                      dbo.STOKKOD1 ON dbo.STSABIT.KOD_1 = dbo.STOKKOD1.GRUP_KOD LEFT OUTER JOIN
                      dbo.CARIKOD1 ON dbo.CASABIT.RAPOR_KODU1 = dbo.CARIKOD1.GRUP_KOD LEFT OUTER JOIN
                      dbo.CARIKOD2 ON dbo.CASABIT.RAPOR_KODU2 = dbo.CARIKOD2.GRUP_KOD LEFT OUTER JOIN
                      dbo.STOKKOD2 ON dbo.STSABIT.KOD_2 = dbo.STOKKOD2.GRUP_KOD LEFT OUTER JOIN
                      dbo.PROJE ON dbo.STHAR.PROJE_KODU = dbo.PROJE.PROJE_KODU LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP1 ON dbo.STHAR.SATISK1TIP = ISKONTIP1.ISKONTOTIP LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP2 ON dbo.STHAR.SATISK2TIP = ISKONTIP2.ISKONTOTIP LEFT OUTER JOIN
                      dbo.ISKONTIP AS ISKONTIP3 ON dbo.STHAR.SATISK3TIP = ISKONTIP3.ISKONTOTIP LEFT OUTER JOIN
                      dbo.TBLESNYAPMAS AS ESNYAPMAS WITH (NOLOCK) ON ESNYAPMAS.YAPKOD = dbo.STHAR.YAPKOD LEFT OUTER JOIN
                      dbo.FATUIRS ON dbo.FATUIRS.CARI_KODU = dbo.STHAR.STHAR_ACIKLAMA AND dbo.STHAR.STHAR_FTIRSIP = dbo.FATUIRS.FTIRSIP AND
                      dbo.STHAR.FISNO = dbo.FATUIRS.FATIRS_NO

not (NETCONTEXT tablosu netsis içinde oturum açmis iseniz iliski kurabileceginiz bir yapidadir. o yüzden benim yazdigimda bu TBLSTOKPARAM tablosu'nu almadim)