Find the maximum of 5 date parameters

[raja2008]

Hello!

I have 5 date range parameters.
How can i find out the maximum of all and minimum of all,
So i can use them in my select criteria.

Please nany suggetions to achieve this are welcome.

 

[lbass]

This is unclear. Please be more specific. What are the date range parameters? Why do you have five--are there five different date fields? Do you really want to evaluate one particular date against the minimum of all five? And Against the maximum of all five? Why do you need five then? Ordinarily, you would just use:

{table.date} = {?daterange}

-LB

 

[raja2008]

Thank You for your response LBass
I'm using Crystal Reports XI R2.
I have to get the information of 5 employees along with the diff date ranges for each employee.

Then i have to do some calculations based on those values.
So i'm trying to use the max and min dates from the date ranges to use in the Selection criteria.

can i do this.

{tabledate}={daterange1} or
{tabledate}={daterange2} or
{tabledate}={daterange3} or
{tabledate}={daterange4} or
{tabledate}={daterange5}

I'm trying to avoid using 5 subreports.

I hope it clears a little bit.

 

[lbass]

Set up the record selection formula like this:

(
{table.Employee ID} = {?Employee}[1] and
{table.Date} = {?DateRange1}
) or
(
{table.Employee ID} = {?Employee}[2] and
{table.Date} = {?DateRange2}
) or
(
{table.Employee ID} = {?Employee}[3] and
{table.Date} = {?DateRange3}
) //etc.

Then create a formula and format it to "can grow" to show the values of the parameters you chose:

"Employee "+totext({?Employee}[1],0,"")+": "+totext(minimum({?DateRange1}),"MM/dd/yyyy")+ " to " +
totext(maximum({?DateRange1}),"MM/dd/yyyy")+chr(13)+
"Employee "+totext({?Employee}[2],0,"")+": "+totext(minimum({?DateRange2}),"MM/dd/yyyy")+ " to " +
totext(maximum({?DateRange2}),"MM/dd/yyyy")+chr(13)+
"Employee "+totext({?Employee}[3],0,"")+": "+totext(minimum({?DateRange3}),"MM/dd/yyyy")+ " to " +
totext(maximum({?DateRange3}),"MM/dd/yyyy")+chr(13)
//etc.

Note that you would have to instruct the user to enter the dateranges in the order that the employee numbers were entered, so that the ranges correspond to the correct employee.

This is also set up (once you complete the above for five instances) to work ONLY if the user enters five employees and the corresponding date ranges.

-LB

 

[raja2008]

Thank You veru much .
That was really helpful.

 

[raja2008]

Now i have one more problem.

LBass-Earlier in your response you mentioned
table.Employee ID} = {?Employee}[1] is this a array.
i have five diiferrent employee parameters.If it's arrary how it works .

The user might not be entering the 5 employees information everytime.Sometimes they may even want to see one employee info.

Then i created a group based on the Employees parameter information.Since the calculations are the same except with differrent employee and dateranges.
here is the group:
If ({table.empid}={?Employee1} and {table.date}in{?dateRange1}) then {?Employee1} else
If ({table.empid}={?Employee2} and {table.date}in{?daterange2}) then {?Employee2} else
If ({table.empid}={?Employee3} and {table.date}in{?DateRange3}) then {?Employee3} else
If ({table.empid}={?Employee4} and {table.date}in{?DateRange4}) then {?Employee4} else
If ({table.empid}={?Employee5} and {table.date}in {?DateRange5}) then {?Employee5} else
""



Now how do i do in this case.

Any suggetions.
If there is any other way to do this Please advise me.

 

[lbass]

Can you explain why you are using a different date range for each employee? What is the personalized date range based on? There might be a better approach.

-LB

 

[raja2008]

These are like employee attendance and productivity calculations kind of stuff.
So the date ranges for each employee will be differrent.


Earlier i saw i thread where we can display prompts based on another prompt.I can't find it now.

What i'm planning is create a prompt with options like 1,2,3,4,5 and then display parameters based on that but i don't know how to do this.

I hope it explains a lttle.

 

[lbass]

No that doesn't really explain why you are using different ranges. On what basis would a user decide to use a specific range?

-LB

 

[raja2008]

THat's what my requirement is.
The user need to be able to enter differrent date ranges for differrent employees.
To answer your question this is about employee performance so,they need diff ranges based on employee which is variable all the time.

I actually let the parameters with default values,Which solved my problem.

Until and Unless the users are fine with that I have to think about Displayiing the prompts based on no.of employee information they want to see.

 

[lbass]

The following will work for 1 to 5 employees. This assumes that you have only two parameters--{?employee} and {?daterange}, each set to allow multiple values, with the {?daterange} parameter set up as a date and to allow range values:

whilereadingrecords;
numbervar i;
numbervar j := ubound({?Employee});
booleanvar array k;

for i := 1 to j do(
redim preserve k;
k :=
(
{table.employee ID} = {?Employee} and
{table.date} = {?DateRange}
));

k[1] or
(
if j > 1 then
k[2]
) or
(
if j > 2 then
k[3]
) or
(
if j > 3 then
k[4]
) or
(
if j > 4 then
k[5]
)

You just need to add prompt text that tells the user to enter the date range for the employee that is in the corresponding order in the employee parameter selection area.

-LB