|
my work is web application
and i have one page before crystal report page
that's for the user search by using from date and to date
and View By dropdownlist
and then i have a button "View Report"
when user click on this button
i keep from date, to date, and view by into
3 sessions: Session["FDATE"] , Session["TDATE"] ,Session["VIEWBY"]
and link to crystal report page
in my crystal report job, i need to design report like this
From : 05 May, 2009
To : 10 May, 2009
View By : Product
===============================================
Barcode Ship ID Ship Date Order ID Qty
------------------------------------------------------------------------------------
0001 0001 05 May 09 0001 5
07 May 09 0003 5
0004 05 May 09 0011 2
0012 10 May 09 0002 2
-------------------------------------------------------------------------------------
Total : 3 ships 14 items
-------------------------------------------------------------------------------------
0002 0002 05 May 09 0001 2
0003 05 May 09 0001 1
0004 1
-------------------------------------------------------------------------------------
Total : 2 ships 4 items
===============================================
Summary: 2 Products 5 ships 18 items
how can i design my report to display this infomation
any information retrieve from my MS-SQL SERVER database
---- 1 product can have many ships
---- 1 ship can have many orders
when display above
i need to sort by this
----- barcode
----- ship id
----- ship date
----- order id
respectively.
for qty column, i must use aggregate SUM function
to SUM qty that related with left 4 columns
how can i design this report ?
thanks a lot for the answers
|