If {?Job} = {Job.Job} then
{?Job} = {Job.Job} and
{Job_Operation_Time.Work_Date} >= {?Start Date} and
{Job_Operation_Time.Work_Date} <= {?End Date}
Else
    If {?WorkCenter} = {Job_Operation_Time.WC} then
    {?WorkCenter} = {Job_Operation_Time.WC} and
    {Job_Operation_Time.Work_Date} >= {?Start Date} and
    {Job_Operation_Time.Work_Date} <= {?End Date}
    Else
        If {?Employee} = {Job_Operation_Time.Employee} then
        {?Employee} = {Job_Operation_Time.Employee} and
        {Job_Operation_Time.Work_Date} >= {?Start Date} and
        {Job_Operation_Time.Work_Date} <= {?End Date}
        Else
            {Job_Operation_Time.Work_Date} >= {?Start Date} and
            {Job_Operation_Time.Work_Date} <= {?End Date}



The above is a statement I am currently using to sort my report, it partially works..

The end goal is to be able to sort by any of the following

     Start and End Date, or
     Job and Start and End Date, or
     Employee and Start and End Date, or
     Work Center and Start and End Date.

Currently what happens is the report requires the Start and End Dates, which is good. But if I attempt to put an employee number (Ex 000030) in as a part of the sort, I still receive all of the same information as before, with only the date range.

Meaning all of the records for the date range that was entered in the prompt.

This occurs for all of the other "optional" sorts of Employee, Job, and or Work Center.

Eventually a co-worker may want to sort by Job which would then pull all of the entered information against the job. 

Any help would be greatly appreciated.


Edited by TBT1 - 18 Oct 2012 at 4:45am

It is ideally for selection purposes. The report sorts by Employee number which is like "000030"

The report currently shows all of the information, that is also a part of the selection field.

IE

If I have a report run with 10/18 to 10/18 it will show the Jobs, Employee name, and qty's run etc.

But want I need it to do is to specifically give me only the information I input into the Prompts. If the Prompt for Job Number is blank, ignore it, but if the Employee number is not blank, give my that Employees information for the date range, and only that employee.




Edited by TBT1 - 18 Oct 2012 at 4:55am

Crystal reports XI 

The parameters are user entered. Dates, Job, Employee and Work Centers

Because we have a very large database that is being pulled from, a list  record wouldn't work.

By an all option what do you mean? 

OK thank you for the tip,

Just a question, I've tried to create a date range param as you have it shown "{Job_Operation_Time.Work_Date} in {?Start Date} to {?End Date}"

and the formula editor tells me I have an error.

Is that convention used in newer versions of Crystal only?

Additionally,

Did you give me the entire promp code that I need, it looks complete to my "New to Crystal Eyes"

programming isn't my best skill set. 

Edited by TBT1 - 18 Oct 2012 at 5:20am