hello Need help on sort formula pleas

[MrHelpMe]

Hello I need a sorting formula that will do this. I do not want a parameter driven sort. Any idea how to do this.

I would like the status report grouped by Project Status as follows:
If the status is Initiation or In Progress sort by
priority, if same priority, sort by project #

Then sort by On Hold (Strategic) and On Hold (Resources)
By priority, then by project #

Then Complete
By implementation date (latest date first). If the same date, by project #

Then Cancelled and Rejected

Thanks Everyone.

 

[synapsevampire]

Think of sortation as a hierarchy.

It appears that you want:

If the status is Initiation or In Progress sort by
priority, if same priority, sort by project #

When you say if same priority, I think you mean with the priority, right? And what if it isn't Initiation or In Progress, what do you sort by?

Anyway, you'd create a formula field to be used for sorting, akin to:

If {table.status} in ["Initiation", "In Progress"] then
{table.priority}
else
??? // You didn't explain this

All of the other fields you would just use in the Report->Sort Records as if in a hierarchy, with the exception of this, which doesn't make sense:

Then sort by On Hold (Strategic) and On Hold (Resources)
By priority, then by project #

Here you've sorted by Project

Then Complete
By implementation date (latest date first). If the same date, by project #

Here you say to sort by project again but after the date...

To simplify your task, and to allow others to understand it, post real specifics rather than pseudo text explanations. Crystal version, database version, example data and expected output.

Few enjoy technical writing, but everyone appreciates and is more efficient while using good documentation.

-k

 

[MrHelpMe]

Your totally right Synapsvampire,

My question was very vague. Sorry about that. After reading your reply I asked for clarification again. Turned out that all she wanted was a group and sort within that group. Rather simple. So I provided what was needed and everything looks great. Thanks again. I'll make sure my next question is clear.