Show sum of columns in RDLC Report using C# and VB.Net in ASP.Net

vail

Hi,

In my Database i have orderIncome table.

OrderIncome:(Fields)

1.OrderDate

2.OrderNo

3.PaymentMethod

4.Amount

5.OrderClosingDate

PaymentMethod have following types:

1.Cash,Online,Cheque,Foc

How i want separately display sum(cash),Sum(online),etc.. using orderclosingdate range in RDLC report.

vail

0 4

I need this Cash, Online, Cheque based on Orderclosingdate.

Ex:

Select Sum(Amount) from OrderIncome where Paymentmethod='Cash' and Orderclosingdate between '01/24/2017' and '09/14/2017'

like that,

And how i display inside the rdlc report

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html