Parameter Field or Formula?

[ralphcow]

I'm using a report that allows me to view the job cost data by selecting the job as a parameter field.

Is there a way to use the same report to view all the jobs or any job selected without individually selecting each job? Basically, I'm looking to have the default print data for all jobs unless a specific job is selected.

Thanks!

 

[bmitchel]

One way of doing it is to determine an input that will never be used. For example: if the field is a numeric and you know that 0 can never be a job number then set the default value for your parameter to 0. In your record selection formula check to see if the parameter is 0. If it is then set your record selection to show all. If not then the record selection will be equal to the paramter.

Something like this:

if {?Parameter} = 0 then jobid = jobid else jobid = {?Parameter}

I hope this helps.