cancel
Showing results for 
Search instead for 
Did you mean: 

Compare Fields

sam85
Explorer
0 Kudos
360

Hi,

I am comparing two fields from two different tables. field is the article number, one from the ordertable which can have several articles and one from the origin table which has all articles. now i want all articles shown from the origin and the article quantity from the ordertable. how do i manage this task?

i can show all articles but after i put in the quantity, all articles not in the ordertable are supressed or hide away, can i avoid this behaviour?

thanks for any reply. if you have further question or need the report let me know.

greetings

sam

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor

Assuming that you're linking tables in Crystal, try this:

1. Link FROM origin TO ordertable on ArticleNumber.

2. Right-click on the link and select Link Options.

3. Set the join type to "Left Outer Join".

If you don't need the order details, just the total quantity, do this:

1. Group on the Article Number from the origin table.

2. Add a sum on the order quantity per article and move it to the Article Number group header.

3. Suppress the details and group footer sections.

-Dell

sam85
Explorer
0 Kudos

Awesome, I was trying some linkings but it seems I missed the right one. Thanks a lot.

Answers (2)

Answers (2)

sam85
Explorer
0 Kudos

Hi,

afterall it doesn't work. The final constellation are the following tables:

1. Order Position (Link Article Number and Order Number)

2. Order Header (Link Order Number and Company Name)

3. Article Origin (Link Article Number)

4. Company Data (Link Company Name)

5. Company Logo Path (Link Company Name)

6. Special Table, with Two Dates (from and to) and a value (guess no linking is possible)

In the end all articles should been shown (article origin) with the quantity (order position) and the company data and logo. the value from table 6 should been shown once in the header. The Left Join with Article Origin and Order Position works fine but the link between order header and position doesn't. hope somebody can help.

Kind regards

Sam

sam85
Explorer
0 Kudos

Now I am facing another problem. I have a Order Header aswell with a Order Number. The Order Position Table which is now connected with the Origin Table of Articles, must been connected to the Order Header. Both have the Order Number. What Connection do I need to run and in which order? Tried some options but only get empty Order Header Fields.


Thanks a lot.

DellSC
Active Contributor
0 Kudos

Left join from Order Position to Order Header on order number. Group by order number from the Order Position.

-Dell

sam85
Explorer
0 Kudos

So if I get ths correctly:

1. Left Join from Order Position to Order Header with Order Number

2. Left Join from Article Origin to Order Position with Article Number

3. GroupBy Order Number from Order Position

Now I am missing the complete Article Set. It's just those which have a amount. Is it possible to get all Articles from the Origin Table and still have this configuration?

Greetings

Sam