Prompt & Report Null Value

[jstroh]

I have created a cross tab report set up to display students primary program and secondary programs.  The rows include the primary program and the columns include the secondary program. The measure is the headcount (count of distinct PIDM). The problem I am running into is if the student does not have a secondary program the header shows as a blank (null). I wrote an if then else statement to display "No Secondary Program" if null. That works fine if I stop there but  I have multiple prompts in the report which include primary and secondary programs. I would also like to display "No Secondary Program" in the prompt but when I use the if then else statement from the report query it simply removes it from the report all together. I know there has to be a way to change the null value in both the prompt and report but I am stumped. Any tips would be greatly appreciated.