Displaying record for given date

[kkowalski]

Thanks, synapsevampire for earlier response below. This did return a value, but not what I needed. I need to display the value in {CSL_STD_CALENDAR.STD_ACTIVE_ON_DAY} (which is Y or N) for the date (({CSL_STD_CALENDAR.CAL_DATE}=CDate (2004, 05, 01))

I cannot use select expert and just set the whole report for may 1 because that only give me info for students active on that day. I need the report, in this field, to tell me whether or not all students were active on May 1 or not.

Thanks again.

if (({CSL_STD_CALENDAR.CAL_DATE}=CDate (2004, 05, 01))
and
{CSL_STD_CALENDAR.STD_ACTIVE_ON_DAY}="Y") then
"Y"
else
if ({CSL_STD_CALENDAR.CAL_DATE}=CDate (2004, 05, 01) and {CSL_STD_CALENDAR.STD_ACTIVE_ON_DAY}="N") then
"N"
else
totext({CSL_STD_CALENDAR.CAL_DATE}) + " - "+{CSL_STD_CALENDAR.STD_ACTIVE_ON_DAY}

 

[synapsevampire]

You shouldn't be trying to use the select expert, I hadn't suggested that.

The formula (Insert->Field Object->Right click formulas and select new) I supplied was to test to see what is in the fields for those that you suspect should have been Y or N.

Since you want the value only for that date, try:

if (({CSL_STD_CALENDAR.CAL_DATE}=CDate (2004, 05, 01)) then
{CSL_STD_CALENDAR.STD_ACTIVE_ON_DAY}

Rather than continually trying to describe this using text, please post technical inforamtion:

Crystal version
Database/connectivity used
Example data
Expected output

-k