BusinessObjects Board

Link 2 Data Provider

building reports desktopintelligence
#1

Dear All,

I have 2 Data Provider DP1 and DP2

DP1:

Acct Num
Name

Dp2

Acct Num
Name
Street Addr
Phone Number

I Try To show DP1

Acct Num(DP1) Name Street Addr Phone Number

by using Link Acct num. I only want to show the list of acct only in DP1 with all the info. Please advise how to do this!

DP1 has less Acct Num than DP2 btw. however, If I try to show DP1 and DP2 objects together, it wont let me.

kyanforum (BOB member since 2009-05-22)

Combining two tables in to one
#2

First you link ActNum of DP1 with ActNum of DP2
Next in your report insert: ActNum(DP1), Name(DP2), Street, Phone Number

gulymin (BOB member since 2009-05-18)

#3

Yeah but it doesnt let me add demension objects from 2 DProviders in a same table. Any suggestions?

kyanforum (BOB member since 2009-05-22)

#4

You have to create a detail object for ActNum(DP1) and then insert into the block. For more information on detail objects, please search BOB on ‘detail object’. I found many topics including this.

Jansi :india: (BOB member since 2008-05-12)

#5

Thanks for reply. btw si there an explainaton why we have to turn this into a detail object?

kyanforum (BOB member since 2009-05-22)

#6

Only then you can add the object from the data provider say ‘DP1’ into the block along with the objects of the other data provider say ‘DP2’.

Jansi :india: (BOB member since 2008-05-12)

#7

Well,
If you don’t want add objects from 2 DP, you can use only DP2 objects:

ActNum(DP2), Name(DP2), Street, Phone Number

and add where condition:

ActNum(DP1)=ActNum(DP2)

gulymin (BOB member since 2009-05-18)

#8

The detail objects work, but how can I show just a list of account from DP1 only. DP1 has less number of Accounts. Please advise!

kyanforum (BOB member since 2009-05-22)