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 |
|
aarthirsk
Starting Member
5 Posts |
 Posted - 2014-04-11 : 06:24:44
|
| Hi,I want my report to fetch data from Financial year starting to till date.i.e Apr 2013 to till date.till date means Today() minus 8 days and @Fromdate includes last week of march alsoi.e Mar 29 2013 to Apr 4 2013 - this week data will also be includedSo data from Mar 29 2013 - Apr 4 2013 to today() minus 8 days need to be displayedHow to fetch data for this.Pls advise.The column corresponding to this looks like "2013-11-01 ~~ 2013 - 11- 07" |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-11 : 08:55:32
|
| You could either filter the data in the query (using a where clause for the dates) or in the filter for the tablix. I'd probably go with the former since it reduces load on the server and the network. |
 |
|
|
|
|
|
How to make the report to display weekwise data