Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Question on Business View

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question