Date Range Parameter

[trafficstudent]

I have a report that use a data range parameter. I noticed that when a date range paramter is prompted it has a No Lower Bounds or No Upper Bounds check box under the date. How can I setup my report, so that the No lower Bound is automatically checked? so that my user doesn't have to check the box each time they run the report.

 

[trafficstudent]

Does anyone have any ideas in CR 9, to not have the user click the lower bounds box each time they want to have the lower bound. Can this be done in code?

 

[lbass]

The defaults are set with no check mark, meaning the user has to enter both a start and end date. If you always want to check the box for no lower bound for the start date, this is the same as saying that you always only want all records less than the end date--so why not use only an end date parameter instead of a range parameter to begin with? I think the lower and upper bound options are just to allow flexibility of approaches within the same report.

-LB

 

[trafficstudent]

LB- The whole idea for using the parameter date range and the lower bound range (end date) is that my users want to have the flexiblity if they search a report in a given range using the date parameter then they can otherwise they can leave it open as in no date range or (lower bound) Can theis be done with any code????

Thanks in advance !

 

[trafficstudent]

LB- Here's the code I thought would work within the parameter selection:


//This code should return all dates if the date parameter hasn't been touched

{LaborDistribution.PartNumber} = {?Part Number Selection} and
{LaborDistribution.StartDate} <> {LaborDistribution.StopDate} and
not ({WorkCenters.WorkCenterID} startswith "9") or



//This should return dates within the date parameter
{LaborDistribution.PartNumber} = {?Part Number Selection} and
{LaborDistribution.StartDate} <> {LaborDistribution.StopDate} and
not ({WorkCenters.WorkCenterID} startswith "9") and
{WOHeader.StartDate}={?Date Range}


It seems as if condition 1 is met with returning all dates if nothing has been touched, however condition 2 doesn't return the date range it will return the all dates condition again.