[Melissa Siobhan]

Is there any way to use one parameter date range on two fields.

For example: If I want my report to show any proposal with an expected date in X - Z date range OR with a deadline date in X - Z range is there any way to program it in such a way to not ask me for the same date range twice?

[Doug Creek]

(
   {field_date_1} in minimum( {?dateRange} ) to maximum( {?dateRange} ) or
  {field_date_2} in minimum( {?dateRange} ) to maximum( {?dateRange} )
) and

<insert rest of criteria here>

[Melissa Siobhan]

It is not recognizing the parameter field {?dateRange} Is that a canned parameter or do I need to set it up in parameters. Can you set up a parameter in Crystal and not link it to a specific field?

[Melissa Siobhan]

I figured it out.

Now how can I stop the thing from using the current date/time in the parameters?

[Doug Creek]

You'll need to set it up in the parameters... In the way I have it defined here, you would set up a date type parameter that allows ranges, no individual values.

I don't use the "Select Expert", if you go to Report --> Selection Formulas --> Record, you can actually edit the formula... Drop the formula below in it (after you create the parameter...)

[Doug Creek]

In the field explorer, you should see "Parameter Fields" Right click, create a new parameter, name it whatever, then change the {?dateRange} to the name of that parameter...

[Melissa Siobhan]

Thank you Doug. I have now sucessfully created my first report that uses parameter fields (Done it in Access but not Crystal)

[DrewAllen]

Quote:

Originally Posted by Doug Creek

(
   {field_date_1} in minimum( {?dateRange} ) to maximum( {?dateRange} ) or
  {field_date_2} in minimum( {?dateRange} ) to maximum( {?dateRange} )
) and

<insert rest of criteria here>

This can be simplified to

(
   {field_date_1} in {?dateRange} or
  {field_date_2} in {?dateRange}
) and

<insert rest of criteria here>

Drew