sql server - Formula field not showing in crystal report 8.5 -

i'm using old version of crystal reports 8.5 , i'm having problems in showing field in details.

this report uses 6 tables in sql server database:   2 in database1: tblrecibo, tblcanaisdistribuicao  3 in database2:  tblpessoas, tblmoradas, tblcodpostal, tblramos 

tblramos.codramo int datatype , want display in details section.

@n_apolice

left(cstr({tblramos.codramo}, "000"),3) 

it seems not able field table, yet can access fields other tables of same database in group-header section (this report uses tables 2 different databases, , none of table names used repeated on both databases).

already pressed verify database button few times... problem persists... there way force check table in particular? or database in particular?(since there 2 , might checking other one)

i have tested in sql, if query data should return fields, , does...

edit
started redo whole report, , apparently formula field not display value correctly if add code formula fields (fields use same database other data tables)

@nome

ucase({tblpessoas.nome} & " " & {tblpessoas.nomeintermedio} & " " & {tblpessoas.apelido}) 

@morada

ucase({tblmoradas.morada}) 

@cpostal

if isnull({tblmoradas.locpostal}) {tblmoradas.cpostal} & "-" & {tblmoradas.cpostalaux} else {tblmoradas.cpostal} & "-" & {tblmoradas.cpostalaux} & " " & {tblmoradas.locpostal} 

in mind makes no sense @ all...

edit2
these 3 fields in group header section while other 1 in details section... can problem?

the fields in conflict reason @n_apolice (in details) , @nome, @morada, @cpostal on header.

all other fields in details section come data source , work well

i can write comment becoming huge , wrote answer 

brother can see clear linking issue tables...

check linking between tables tblpessoas, tblmoradas, tblcodpostal , tblramos... because formula morada , cpostal coming table tblmoradas , nome coming table tblpessoas , problamatic field n_apolice coming tblramos belongs same datasource....

now main problem when 3 formulas added 1 in detail not displaying... think because of linking becuase when include fields other tables other tblramos linking tables included in query preventing data tblramos not displaing in reports.....

now when 3 formulas deleted , field tblramos included 3 tables not included in query reason can see data...

you can try self checking query including 3 tables first , removing tables again. if still not sure fire same queries on datbase , check rows extracted..

solution:

the solution suggest check linking first , if there inner join tblramos other tables remove , include outer join table tblramos , check result , according me should work. working check indetail database linking , data want display. knowlege should work.

let me know if approach worked you.