Link to home
Create AccountLog in
Avatar of susan1978
susan1978Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of dportas
dportas

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of nmcdermaid
nmcdermaid

If you want to do reports with SQL Server with drops downs etc. you are best of checking out Reporting Services.