Linking Tables, Can't Index, No Data Generated 1

[BHERNANDEZ]

I am using CR 7 with a SQL database. I have two tables to link:

oelinhst and oehdrhst


Smart Linking links them by ord_no and ord_typ. I want to show these fields on the report from these tables:

oelinhst: oehdrhst:
item no state
qty inv date

My report generates no data no matter what my selection criteria is. I can't index through the visual linking expert b/c the buttons are grayed out. I've read other threads that talk about a left outer join, but I've no clue what to do with that info. I have looked at my SQL Query and am guessing it would go in there? If so, how do I do that? Can I make this report work at all? Oh yeah, these two tables are from the same database.

Any helps, tips, or suggestions are greatly aprpeciated.

B

 

[Turkbear]

Hi,
If you click on one of the links, the buttons should become active, then select Options to designate the link type.

 

[RobbieB]

First make sure that ord_no and ord_typ are the same type of data. you should be joining something like "Customer.no" from one table to "customer.no" on another table. Sometimes databases are not set up very well (ok, most of the time) and the customer table may have a field called "number" and another table (lets say sales order table) will have "customerNumber" and these two fields would join. If you were to join these two tables and wanted all the salesorders even if it did not have a customer number in it you would want a left outer join which you would get by going to your linking expert, right clicking on the link and selecting "left outer". Make sense?

 

[dgillz]

Bridget,

You want to link those 2 tables on Order_Type, Order_no and Invoice_No. This should NEVER change for those 2 tables. the reason is if you have multiple shipments against an order, and you do not link on invoice_no, then you will be picking up all of these shipments and not just the one on that single invoice.

Also, for what it is worth, don't ever use smart linking, it isn't that smart, especially with Macola tables. In fact I tell my customers to turn it off altogether.

On the rest of your post, I am not sure what you are trying to accomplish, so call me if I can help.

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

http://www.trianglepartners.com

 

[BHERNANDEZ]

I am showing data now. THanks!

Don,

I have made an 'item sales by state' report showing how many of what item was sold in what state for a specified period of time. I did what you said and linked only those three fields. My report is now showing data. THanks so much!

B