Oldest Record

[sjc1956]

This is a question that I'm sure has been asked a lot, but I'm having trouble with this.
From a medical record I need the oldest entry date out of multiple entry dates. I select from

{c_str_m_parm.entered_at}

I appreciate the help.

 

[mjjks]

Maximum({c_str_m_parm.entered_at});

 

[sjc1956]

I did try that and get "A Boolean is required here" error.
Here's the statement with your suggestion added. I don't know if this helps or not.

{c_str_m_parm.emtek_id} = {?Pm-r_adt_core.emtek_id} and
IsNull ({c_str_m_parm.changed_date}) and
{c_str_m_parm.object_name} like 'C_CP_INDIVNIC_PHYSRES' and
Maximum({c_str_m_parm.entered_at})

 

[mjjks]

Is this a suppression condition as you don't have "if" statement? If it's a suppression, remove if-then.

I can't test without data but try this:

if {c_str_m_parm.emtek_id} = {?Pm-r_adt_core.emtek_id}
and IsNull ({c_str_m_parm.changed_date})
and {c_str_m_parm.object_name} like 'C_CP_INDIVNIC_PHYSRES'
and [highlight]{c_str_m_parm.entered_at} = Maximum({c_str_m_parm.entered_at});[/highlight] then

 

[lbass]

Do you want the earliest date of a certain group, e.g., a group on {table.patient}? Then leave your original record selectionf formula as is, and go to report->selection formula->GROUP and enter:

{table.date} = minimum({table.date},{table.patient})

-LB