I'm using CR2008.
I have a list of medical observations that I want to display in a group footer. I have one formula, @LDLDate, that says
If {Command.OBSNAME} = "LDL" Then
{Command.OBSDATE}
Then, I have another one, @LDLDateShow, that reads
Maximum({@LDLDate}, {Command.PID});
If there's an LDL observation for a patient, the date displays properly. If not, nothing displays in the group footer. All well and good, but there's nothing I can operate on, either. I tried setting a Display String to be
If IsNull({@LDLDateShow}) Then
"(none)"
Else
ToText(@LDLDateShow, "MM/dd/yyyy");
But still, nothing displays. How can I change this to work properly? Thanks.
Edited by: Garrett Fitzgerald on Mar 13, 2009 3:28 PM
Edited by: Garrett Fitzgerald on Mar 13, 2009 3:30 PM fixed formatting