C# Fast Report The filtering problem

I am creating a Fastreport Report I need to get a report according to the query below Lakin I did not do the parameter analysis Query should be as below

SELECT SatisDetaylari.UrunID, Urunler.UrunAdi, SatisDetaylari.Miktar, SatisDetaylari.Tutari, SatisDetaylari.OdemeTuru, SatisDetaylari.Tarih
FROM SatisDetaylari INNER JOIN
Urunler ON SatisDetaylari.UrunID = Urunler.UrunId WHERE SatisDetaylari.UrunID=@id AND SatisDetaylari.Tarih >= @baslangic AND SatisDetaylari.Tarih < @bitis AND SatisDetaylari.Durum=2


Note:I am sorry if english is bad or I am sorry

Comments

Leave a Comment