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.

 All Forums
 Development Tools
 Reporting Services Development
 How to make the report to display weekwise data

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 also

i.e Mar 29 2013 to Apr 4 2013 - this week data will also be included

So data from Mar 29 2013 - Apr 4 2013 to today() minus 8 days need to be displayed

How 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.
Go to Top of Page
   

- Advertisement -