HELP!! CR 8.5 BUSINESS WORKS GOLD - PROBLEM

[Kimcox]

Hi Guys,

I need desperate help. We are doing a report that shows ItemID, any customer that purchased that ItemID (custid) and the ShpQty. The problem is that when you preview the report it is doubling some of the shipped qty and applying that to records that it does not apply to? DOes this make sense to anyone? The Databases we are using are OELineitem and OEshipto. All we really want is a report that we can run by item # for a specified period of time that shows who bought it and how many they bought? You would think we were doing brain surgery, although at this point that might be easier

 

[synapsevampire]

You are probably experiencing row inflation, which is VERY common.

Unless someone has worked with your database, they won't be able to help much unless you post meaningful technical information:

Database/connectivity used
Example data
Expected output

The latter part of this:

"the report it is doubling some of the shipped qty and applying that to records that it does not apply to?"

doesn't make sense if it is showing shipped qtys for things not shipped. This means that the joins or the data is wrong, or that you aren't understanding the results.

You may be able to create a MAXIMUM on the shipped qty to show the maximum if that's what you're after, but without understanding the tables/columns/data I can't suggest specifics.

-k

 

[dgillz]

What are your table structures and how are the tables linked?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Kimcox]

Thank you. I'm sorry I didn't give you the info you needed here it is.
Im using the following databases (however i can change it if need be)
OELineitem and OEShipto
They are linked with NextRecord to NextRecord (which might be wrong im not sure)The fields within those databases that are on the report are
LineitemID (From OElineitem)
OrdQty (from OELineitem)
Name (from OEshipto)

Database/connectivity used - ODBC - Business works

Example data -
TITLE: Items sold by customer for 1/5/05 - 4/15/05
Header - Item ID Customers Name Qty
Details - CB 1091 Art & Frame 25

Expected output- The expected output would be who bought the item CB 1091 and how many they bought in a specified period of time.

Is that what you were looking for. Thank you for your help

 

[Kimcox]

HI Dgilz,

Im not sure if I am giving you the right info but as you can see from the post above i think i pretty much covered everything.

Does that help??

 

[dgillz]

I cannot speak to BusinessWorks databases, but in Macola the relationship between these 2 files must add a third file, order header. The order header cust # and ship to cide should be linked to the ship to code file.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz