CODEWITHSUNDEEP
vb.netvisual-studio-2010crystal-reportsms-access-2010oledb
Jason 8
Jason 8

Reputation: 221

How To Properly Sort This By Date? (With Image)

enter image description here

The table's name is tblFuelTransactionLogs, and the data I'm summing up is Price. The query I use to populate the fields which works just fine in the report is:

MyCommand.CommandText = "SELECT Price, Created_Date FROM tblFuelTransactionLogs" & _
"WHEREYear(Created_Date)='" & year & "' and Month(Created_Date)='" & month & "'"

The formula I use for the "$60" is just:

Sum ({tblFuelTransactionLogs.Price})

How do I filter the summation by date? Any ideas will be very helpful!

Upvotes: 1

Views: 72

Answers (1)

Siva
Siva

Reputation: 9101

Ok problem I see is simple...

1.Don't take the formula as Sum ({tblFuelTransactionLogs.Price}) instead use only ({tblFuelTransactionLogs.Price}) and as it is place in detail section.

2.Right click the formula in detail and go to Insert ---> summary --> insert summary in footer

Upvotes: 1

Related Questions