how to calculate daily,weekly,monthly,yearly sales report for retail stores

Hello sonalthorat,
In Database side you can create a query for SUM(filed) and calculate between startdate and enddate.
For your requirement you will need to calculated the different start and end date depending on selection.

At last you can populate that info on Crystal report or by any other means of idea.

If you have any doubts then reply.

Regards,
Jitendra

It sounds to me like you need to look at some form of reporting system (assuming you want to provide this as more than a one off function), possibly supporting OLAP functionality as you want cumulative information which can be rolled up across multiple dimensions. What you want would typically look like this in output:

       2010
       January
       Week 1
       01/01 02/01
Store    
ABC      200   300
DEF      250   400

Total    450   700

There are several excellent components available that provide this type of functionality. I suggest that you have a search and review those against your requirements.

My favourite (for WPF development) is this this[^]. They have an ASP.NET version available here[^] and a WinForms version here[^].

You can use Ms. SQL server which comprises database and Reporting Engine.
And its easy to connect with SSRS and get reports using SP or queries.