Wednesday, March 21, 2012

ReportSelectionFormula To bring Null Values

Hello

Can anyone help me how to View the CR with ReportSelectionFormula with Particular field having Null Values

I have written like this

rpt1.RecordSelectionFormula = "{Dpled.Match} IS NULL"

or

rpt1.RecordSelectionFormula = "{Dpled.Match}='' "

but it gives blank reportUse isnull() function

rpt1.RecordSelectionFormula = isnull({Dpled.Match})

it will report only those records which has match field as null|||I tried out this

rpt1.RecordSelectionFormula = " IsNull({Dpled.Match})"

Still did not work out to bring Report with Null Values|||try this

rpt1.RecordSelectionFormula = " if IsNull({Dpled.Match}) then true"

No comments:

Post a Comment