Showing posts with label particular. Show all posts
Showing posts with label particular. Show all posts

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"

Friday, March 9, 2012

reports

Hi all, how can we get running totals for particular column in sqlserver crystal reportsYou might want to ask this in the Crystal Reports Forum (http://www.dbforums.com/forumdisplay.php?f=244)