|
Rasik1999
Starting Member
1 Posts |
 Posted - 10/12/2012 : 16:09:55
|
How to do month to date and previous week to dat order total IN SQL reporting service
here is my sample
Previous week to date and month to date in SQL reporting service
This question about SQL reporting service
I do have a following formula in Crystal report. do samething in SQL reporting service. Please help me.
I would like to count total orderamount if order date in Month to date. sameway find out total order amount if ordrdate is in Previous week( start sunday )
following is a crystal report syntax. I want to do same for SQL reporting service
Provide current month to date Total
if {Table1.orderDate} in MonthToDate then
{table1.orderAmount} else 0
-- Previous week to date Total
if {Table1.orderDate} in lastfullweek then
{table1.orderAmount} else 0 |
|
Month to date and previous week total in SQL repor
