linking problem

[BJD]

I have 3 tables linked as follows:
OPERATION with an equal join to OPERATION BINARY , and OPERATION with a left outer join to REQUIREMENT. This was working fine but I need to add one more table. I need to add a table called PART as an equal join to REQUIREMENT. When I do this, the report acts like my left outer join between OPERATION and REQUIREMENT is set to be an equal join. (Only records from OPERATION with matching records in REQUIREMENT show up.)

 

[IdoMillet]

Operation records with no matching Requirement would have Null values in the Requirement columns and hence would fail to match to a Part. If you want the outer join to be retained you need to apply outer join to the next join as well.

Alternatively (some DBMSs and connection types don't allow a sequence of outer joins), create a Query/View and use it as the data source.

Cheers,
- Ido ixm7@psu.edu

 

[BJD]

using a Query/View as a data source is something I've never done. How does this get me around my problem of needing more than one outer join? How do you create one of these?

 

[Guest_imported]

In Crystal Reort, How the Picture can be displayed dynamically.

In fact, we are working with VB-Oracle and Crystal Report,
Suppose we are displaying any Photo depneding on user's information in VB form, same image we want to paste in Crystal report for priting purpose (e.g. Employee Indentity Card)

- How to insert picture in a Oracle table. Pls describe step by step procedure

 

[Ngolem]

I would make a subport of Requirement and Part tables and using shared variable pass the values back to the main report.

Use an initialization formula to set the shared variables to null or zero. In your details write your formulas like

If not isnull({Table.field})then
sharedvaraiable := {Table.Field}

this way the formulas don't choke when nothing is returned...the subreport will execute once even though there is no data so you will get a return of the initialized values for your variables

Left Outter joins can be a pain

 

[LMRollins]

I have done this type of report myself. I had to write a subreport in order to pull all the info. We are also running Visual. If you still need help, let me know and I'll try to help as best as I can? What kind of report are you trying to write?

 

[BJD]

Hi
I am re-writing our Traveller. Here is the gory detaisl of what I have.

My container report has workorder with an equal join to part and workorder also has a left outer join to workorder_binary.

My 1st subreport has customer order information:
Customer_order with an equal join to customer_order_line, customer_order_line has a left outer join to cust_line_del.

My 2nd subreport is where the problem comes in. I have operation with an equal join to operation_binary (all our operations have notes so we can get away with an equal join), and then operation with a left outer join to requirement. I need to link part to requirement so I can get the description, unit of measure, warehouse and location of our material requirement. That is the point I cannot get past. When I link part to requirement with an equal join, it makes my link between operation and requirement act like an equal join. I can't have an outer join between part and requirement because I already have one between operation and requirement.