cancel
Showing results for 
Search instead for 
Did you mean: 

Question on Business View

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos

Please post this query to the Crystal Reports Design forum:

That forum is monitored by qualified technicians and you will get a faster response there. Also, all BOE queries remain in one place and thus can be easily searched in one place.

Thank you for your understanding,

Ludek

BasicTek
Active Contributor
0 Kudos

I moved the thread to CR design, please don't double post.

Former Member
0 Kudos

Ok. Thanks.

Former Member
0 Kudos

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

Former Member
0 Kudos

And what about the metadata-layer?

Answers (1)

Answers (1)

Former Member
0 Kudos

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