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?

sections

report

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

enter image description here

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.


Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more