susan1978
asked on
Group by days weeks or months
I would like to group date by weeks within a date range. For example i would like the user to specify a date range and if that date range is a 4 week period i would ike to show the history by week. sorted descending by the latest week first. Here is an example:
week 4 10
week 3 20
week 2 30
week 1 5
I would like to the same for days month and year. I have the following fields
vendorid
quantity
rate
itemid
date
I would like to show a history of what was purchased from the vendors purchase grouped by day, week, month, year. Unless someone knows of a better way of doing this i will build sepperate reports for each type of grouping. THe best scenario would be if i could give the customer a way to choose how he wants it grouped for example a drop down showing group by
day
month
week
year
thank you
week 4 10
week 3 20
week 2 30
week 1 5
I would like to the same for days month and year. I have the following fields
vendorid
quantity
rate
itemid
date
I would like to show a history of what was purchased from the vendors purchase grouped by day, week, month, year. Unless someone knows of a better way of doing this i will build sepperate reports for each type of grouping. THe best scenario would be if i could give the customer a way to choose how he wants it grouped for example a drop down showing group by
day
month
week
year
thank you
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
If you want to do reports with SQL Server with drops downs etc. you are best of checking out Reporting Services.