Select records, mutltiplr orders..

[bpodolak]

I am a newbie, and hope I am not asking a simple quesytion, but I am stuck. I have an orders table that useses the below example:

ItemOrderid OrderID ItemID
159 77885 152
160 77885 5
161 77885 750
162 77886 152
163 77886 5

The pupose of the bale is to track multible items in a shopping cart scenario. Howver, when i select the records in Crystal, I only get the first item on the unique orderid, and then it skips to the next. I need to get all the items in a ORderdID to get a total cost of items. Have no idea, and this goes to a MS SQL table. Hope I am using this forum wisely. Thanks very much to nay help i can get

 

[synapsevampire]

I don't see a *bale* referenced, nor are there any costs referenced, but it sounds like you want:

Group by OrderID, and then place the costs you want to sum in the details section.

Right click the costs and select Insert Summary->Sum. You can select the Insert Summaries for all groups and the Insert Grand Totals if you need those.

Now you can delete the costs in the details section if you'd like, and you'll just have the sums for that group, or you can leave items at the details level.

If this doesn't help, post with the data items that you are asking about.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[IdoMillet]

I suspect your database also has an "Order_Detail" table that must be joined to the "ORDER" table in order to provide the details...

hth,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[bpodolak]

It is joined, howver, I only get the order 159 to show up, and then it skips to the next. You see, I have an orders table iwth an order number. I then have that order number in the above table (not bale..sorry about that typo earlier) with the differnt items order. The issue is when I am trying to get ALL the items refed to that order, I only get one, and then it skips. I think because in my order table, I have that order only one time. Does that makes sense ?

 

[synapsevampire]

Perhaps it's the join, go into Database->Visual Linking Expert and right click the line between the tables and select Options. Change the join type to Left Outer

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[IdoMillet]

Sounds like you may have suppressed the Detail section and are looking at information in the Group section...

hth,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com