hello
i am using oracle 11g /crystal reports 10 version
i have the following tables
users ======= user_id number username varchar2 orders ======== order_id number user_id number order_date date select u.username,o.order_id,o.order_date from orders o,users u where o.user_id=u.user_id and order_date between '11-MAY-2011' and '30-MAY-2011'
i have the three columns in my crystal report and users will be prompted to enter date range they need to generate the report
when they do
it has to calculte the following
username,week_1_orders,week_2 orders,rest_orders
week_1_orders=first 7 days orders(in the above example ,its 11,12,13,14,15,16,17 of may 2011 total orders) week2_2_orders=8-14 days of orders (in the above example ,18,19,20,21,22,23,24 of may 2011) week_3_orders=rest of the date range
how do i get these summaries
any help is appreciated
thanks