Find the checkbox described "Suppress (No Drill-Down)" and click the "X+2" button to the right of it.

 

Enter the following and press "Save and Close";

isnull({command.effectiveDate})

 

This will get rid of all entries where there isn't a date.

 

To sort by the date, goto Report > Record Sort Expert...

 

Add the {command.effectiveDate} field to the sort fields and choose the direction.

 

Regards,

Ryan.

 

Then create a formula field, for example's sake we'll call it "Sort by".

 

In that formula enter the following;

 

 

if {?Sorting Method} = "Effective Date"

then {command.effectiveDate}

else {table.otherfieldoption}

 

 

Then in your record sort expert remove the {command.effectiveDate} field and add the {@Sort by} field we just made.

 

Regards,

Ryan.

 

Enter the following;

Name: Sorting Method

Value1 (Click here to add item): Effective Date

Value2 (Click here to add item): Expiration Date

Value Options: Allow Custom Values = FALSE and Allow Multiple Values = FALSE.

 

Ok that and make the formula as above replacing "else {table.otherfieldoption}" with "else {command.expirationdate}"

 

Regards,

Ryan.

 

EDIT: Doing this will still only include data where there is an Effective Date as per your first post. If the user selects "Expiration Date" as the sort method that won't affect that suppression - If you want it to we can modify that suppression formula to take the parameter value into consideration.

if {?Sorting Method} = "Effective Date" 


then {command.effectiveDate} 


else {table.otherfieldoption}

 

The {?Sorting Method} is the parameter field.