selection - Crystal Reports Record Section not returning same data as sql -


i found solution tech had posted:

new formula:

{product.size} <> “xsm” or isnull({product.size})

unfortunately, when preview report, find doesn’t work. not because of mistake in our logic rather, consider bug in crystal reports. if took exact same condition , applied database records using query analyzer or querying tool, see blank records. unfortunately, crystal not allowing null values come through though our formula says should.

the trick circumventing bug put isnull() check first in formula.

thus, if rearrange condition this:

isnull({product.size}) or {product.size} <> “xsm”

worked charm

________________________________________________-

problem is, if select criteria second or statement ({hiredrate.utransdoc}startswith{?transyn}) , no first ({hiredrate.utransweb}startswith{?webyn}) 1 record meets transyn criteria. if switch places in formula putting ({hiredrate.utransdoc}startswith{?transyn}) 1st of data.

when run sql query of data no matter order in. crystal preview gives me of data on first or section.

the thing stands out looking @ data sql 1 record crystal returning has yes in transdoc field , transweb field blank. other records show yes transdoc , null transweb field.

here crystal record selection formula

{hiredrate.contsupref} startswith {?languagecombo} ,    {hiredrate.ondate} = {?projectdate} ,    {hiredrate.actvcode}= "sig" ,    {hiredrate.resultcode} = "clm" ,    (       {hiredrate.utransweb}startswith{?webyn}  or    {hiredrate.utransdoc}startswith{?transyn} or    {hiredrate.utranlanl0}startswith{?lanloyn} or    {hiredrate.uintconsec}startswith{?interpyn} or    {hiredrate.uintconf}startswith{?intconfyn} or    {hiredrate.uintopi}startswith{?opiyn}       )

here sql query crystal using:

select hiredrate.dear, hiredrate.contsupref, hiredrate.lastdate, hiredrate.contact, hiredrate.usourclang, hiredrate.utarglang, hiredrate.utransdoc, hiredrate.utransweb, hiredrate.utranlanl0, hiredrate.uintconsec, hiredrate.uintconf, hiredrate.uintopi, hiredrate.ondate, hiredrate.actvcode, hiredrate.resultcode goldmine_main.dbo.hiredrate hiredrate hiredrate.contsupref 'eng>spa%' , (hiredrate.ondate>={ts '2012-04-01 00:00:00'} , hiredrate.ondate<{ts '2013-04-06 00:00:00'}) , hiredrate.actvcode='sig' , hiredrate.resultcode='clm' , (hiredrate.utransweb 'no%' or hiredrate.utransdoc 'yes%' or hiredrate.utranlanl0 'no%' or hiredrate.uintconsec 'no%' or hiredrate.uintconf 'no%' or hiredrate.uintopi 'no%') order hiredrate.dear, hiredrate.contact

this happening because {hiredrate.utransweb} null - rest of expression therefore evaluating null in crystal, though (logically) shouldn't.

when first 2 or conditions swapped around, {hiredrate.utransdoc} condition evaluates true , rest of expression short-circuited - why records are selected.


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more