Report Header with NO DATA FOUND [message #111174] |
Mon, 14 March 2005 08:15 |
yram
Messages: 75 Registered: February 2001
|
Member |
|
|
hi
I am developing a report with group by .. i want to display "NO DATA FOUND" when the condition of the query fails... in this scenario i want the report header also
example
DEPTNO
EMPNO ENAME SAL COMM
No data found
i am not getting the expected result as the above...
i m using FORMAT TRIGGER to display the NO DATA FOUND...
my problem is i m not getting the HEADING like
DEPTNO
EMPNO ENAME SAL COMM
Take care
yram
|
|
|
Re: Report Header with NO DATA FOUND [message #111186 is a reply to message #111174] |
Mon, 14 March 2005 11:13 |
Steve Corey
Messages: 336 Registered: February 2005 Location: RI
|
Senior Member |
|
|
I think you need to add a format trigger to the header frame as well. You could use the same condition as you did to display the 'No Data Found' boiler plate text. Try that and see if it works.
HTH,
Steve
|
|
|
|