Empty Report Line
Posted: Sat Jul 14, 2012 12:09 am
Hi.
I have produced a report that I expect will return no results from time to time.
What I am currently doing is this :
However, this will appear at the bottom of every report. What I would like is the following output line only when the sort returns no results
I saw a post on the forum where I could do it by adding a second job step to conditionally execute using NULLOUT in the first step.
Is there a way to accomplish this all in one sort step?
Thanks
I have produced a report that I expect will return no results from time to time.
What I am currently doing is this :
TRAILER1=(25:'NUMBER OF RECORDS SELECTED: ',COUNT=(M11,LENGTH=3),2/,
However, this will appear at the bottom of every report. What I would like is the following output line only when the sort returns no results
No results for this report
I saw a post on the forum where I could do it by adding a second job step to conditionally execute using NULLOUT in the first step.
Is there a way to accomplish this all in one sort step?
Thanks