Parameter Entry is Null then Show ALL Data

[rwn]

I have a field called {SOHeader.JobNumber}(this field is a string) and wish to have a parameter control this field. So the parameter would be {?JobNumber}. However, when the report runs and the user does not enter in a Job Number in the {?JobNumber} parameter, then the report should show all Job Numbers.

Thank for any advise?

 

[Turkbear]

Hi,
Create a default value like 'ALL' and test for it:

If {?JobNumber} = 'ALL' then
True
Else
{SOHeader.JobNumber}= {?JobNumber}

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

 

[rwn]

Oh, so simple. Thank you!!