Date Range Parameters

[trafficstudent]

I'm prompting my user with (2) parameters in the crystal (v9) report I just built. The (2) parameters that prompt the user are products then a search date. One of my Users requested that if they entered a product they don;t want to use the other parameter (date) what they would like to see is the lowest date possible. in this case it would be from back in 2002. How can i configure my parameters so that if my user only wants to select the product and for all dates (no range) can i put it in.

example of code:
{LaborDistribution.PartNumber} = {?Part Number Selection} and
not ({WorkCenters.WorkCenterID} startswith "9") and
{LaborDistribution.StartDate} <> {LaborDistribution.StopDate} and
{WOHeader.StartDate} = {?Date Range}

 

[Madawc]

You can give a parameter a default value, such as s minimum date. If it is the second parameter it can also be ignored by someone who just wants the first.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[trafficstudent]

How can i give my date parameter a default value: {WOHeader.StartDate} = {?Date Range}
I would still like for the user if need be select a range of dates or just select all dates. If the date parameter is select then it would return the select dates. If the users doesn't touch the date parameter then it should return all dates.