Let the user decide which parameter to use. 1

[ramc2000]

Hi... How can I let my users decide which parameter field to use when they run a report?

On my report, I have a list of orders that have been shipped out of our warehouse. I want my users to decide how to filter out data, either by a specific order number or by a certain date time range. (I'm using Crystal XI.)

Initially I thought that if I just leave blank one of the two parameter fields, then the report would filter only by the other parameter but that is not the case. For example, if I leave blank the order parameter, no records are returned.

 

[Turkbear]

Hi,
What is your record selection formula?
How that handles the parameter values will determine what data is returned, especially how it handles a missing parameter value.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ramc2000]

That would be:

{ORD_NUM} = {?Order} and
{SHIP.DATE} = {?DateRange}

 

[Turkbear]

Hi,
Then handle the possibllity of no values.
Set a default 'flag' value for each, like
'NOORDER' and 1/1/1900 to 1/2/1900 then test for those:

If {?Order} = 'NOORDER' then
True
Else
 {ORD_NUM} = {?Order}
AND
If {?DateRange} = Date('1/1/1900') to Date('1/2/1900') then
True
Else
{SHIP.DATE} = {?DateRange}

Not sure about the default date range, but this should give you an idea how to proceed.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ramc2000]

Great, this worked just fine. Thanks.