on 09-24-2008 5:42 PM
Hi ,
I'm working on a building a crystal report which needs to get
information from 2 distinct datasources .
There fore I decided to use a business view. But here is what I need to
do. My report needs to show records which are in either of the
2 tables. In my datafoundation which combines the queries(I used add command) from the two datasources , I would either need to do right outer join or do a
table1 left outer join table2 and union/unionall of the resultset with table2 left
outer join table1. The problem is I don't know how to obtain a unionall
for two resultsets/queries in datafoundation.
Is it possible to obtain a unionall in DataFoundation or by somehow using a addcommand
in Crystal?
Please let me know your thoughts.
Thanks,
Manjula
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you do a full outer join between the two data sources? Doing two left outer joins then union-ing the two could be really slow if there are a lot of records...
HTH,
Carl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.