"In Array" forrmula issue

[loschiavoj]

I am trying to have a simple array formula return a value to a report when no records are found. It currently leaves the field blank when no records are found. If it finds a record it returns the correct value.

if {PM_VW.PM} in {?PM}
then
{PM_VW.PM_NAME}
else
"No Records Found

 

[MCuthill]

loschiavoj,

Are you simply trying to place a message when the entire report is empty?

{@Notice_NoResults}

IF IsNull({PM_VW.PM}) Then "No Records Found" ELSE ""

If you are looking to modify your above formula (as it is not for the entire report, but for some other structure), please try:
{@Mod_YourFormula}

IF IsNull({PM_VW.PM}) THEN "No Records Found" ELSE
IF {PM_VW.PM} in {?PM} THEN {PM_VW.PM_NAME} ELSE 
"No Records Found"

Please note: I have found that the "IsNull()" check has to be first in your formula's to be properly evaluated.

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."