Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rasik1999
Starting Member
1 Post |
 Posted - 2012-10-12 : 16:09:55
|
| How to do month to date and previous week to dat order total IN SQL reporting servicehere is my samplePrevious week to date and month to date in SQL reporting serviceThis question about SQL reporting serviceI 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 serviceProvide current month to date Totalif {Table1.orderDate} in MonthToDate then{table1.orderAmount} else 0-- Previous week to date Totalif {Table1.orderDate} in lastfullweek then{table1.orderAmount} else 0 |
|
|
|
|
|
Month to date and previous week total in SQL repor