Sorting records based on data values

[moopenguin32]

I want to sort a series of release records in our IT Service Management database by the Deployment Start Date. Unfortunately, this field is not always populated.

Is there a way to sort the data by the Deployment Start Date and if the field is null, sort it by another field, such as the Release ID?

The report currently contains two groups. The first one is by the Release Milestone and the second one is by the Deployment Start Date. The rest of the report is contained in the details section. There are not any sub-reports.

Thanks for your help with this.

"Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

 

[fisheromacse]

create a formula and sort on it.
something like:

IF isnull({table.Field1}) or TRIM({table.Field1})=""
then {table.Field2}
else {table.Field1};

 

[moopenguin32]

That'll work for what I'm trying to accomplish. Thanks!

"Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie