Conditionally Format Null Shared Date Variable 1

[Jillp]

I have run into a problem that I've been unable to solve. I have passed several date variables from a sub report to the main report. Many of the Date Variables are blank. I have a fairly complex conditional format to highlight pastdue's based on these fields.

My problem is that the null values are not recognized in the main report. I have tried several work arounds, such as; an additional formula replacing null with date(9999,9,9), AND if date(0,0,0) then redefine. Non of these workarounds recognize the blank field.

Does anyone have thoughts about what else I can try?

I appreciate any help.

Best Regards,

Jill

 

[lbass]

Please show the content of the formula you are using in the subreport and the formula you are using in the main report to reference the variable. Also, have you verified that the nulls do show as date(9999,9,9) in the sub when you do the substitution?

-LB

 

[Jillp]

Hi LB,

Your questions sent me in the right direction. I was waiting until the main report to convert my nulls -- didn't make much sense now that I think about it.

Once I redefined my nulls in the subreport everything fell into place. Thanks for your help!

Best Regards,

Jill