Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: How can i design my report Post Reply Post New Topic
Author Message
mixarstudio
Newbie
Newbie
Avatar

Joined: 11 May 2009
Online Status: Offline
Posts: 3
Quote mixarstudio Replybullet Topic: How can i design my report
    Posted: 11 May 2009 at 6:29am

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
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.014 seconds.