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