Question on Business View
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
Please let me know your thoughts.
I tried contacting Business Objects and they seem to think a better solution to this problem would be to use Crystal reports directly and not use the business view.
Edited by: Manjula Kasturi on Sep 25, 2008 3:48 AM