on 2022 Jan 11 2:21 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.