Skip to Content
0
Former Member
Jun 07, 2011 at 02:44 PM

crystal report weekly summaries

183 Views

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