Can't link to required field in another datasource 2

[DrSmyth]

I've got a universe based on a db2 database which has a six digit number field which identifies a person in a table.. Due to an oversite no e-mail address was added to this db2 database.

I've made a spreadsheet with the above mentioned six digit field and the e-mail address of the individual.

Now, i've tried adding another table into a report based on the first universe, which is from a personal data source containing the spreadsheet. I've gone into the data editor and linked the to six digit number fields together (Although BO seems to insist on putting .00 at the end of the Personal Data Source number) but i can't seem to drop the e-mail address into the main report. And if i try and drop the six digit field into the main report then it simply sticks them all on the end - indicating that BO does not regard the two numbers as being the same...

Does anybody have any suggestions???

 

[skrandel]

I would bet that the 6 digit field from your database is not a numeric. If it's a character field, you won't be able to link it.


Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[Subhashab]

while linking columns in the BO report you have to be very careful with the datatype and the size of the column.
So make sure the the field in the database is character or not and make the same in the spread sheet also.
next thing since u are using db2 are the fields of fixed size in that case u may have to put trim in the object defintion. so that it matches with ur spread sheet.

 

[DrSmyth]

Cheers Sub, i simply formatted my spreadsheet to read as text (field in db2 was a character field) and it seems to be working fine now, thanks for the assistance

 

[Subhashab]

hi Drdmyth
how about then marking it as useful ;-)