Home » Developer & Programmer » Reports & Discoverer » Report Header with NO DATA FOUND
Report Header with NO DATA FOUND [message #111174] Mon, 14 March 2005 08:15 Go to next message
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 Go to previous messageGo to next message
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
Re: Report Header with NO DATA FOUND [message #111225 is a reply to message #111174] Mon, 14 March 2005 17:51 Go to previous message
Kalpana Srinivas
Messages: 10
Registered: January 2004
Junior Member
read this link

http://www.comp.hkbu.edu.hk/docs/o/dl/bi/B10602_01/orbr_suppress.htm#1010070
Previous Topic: Printing Pages in Reports
Next Topic: Rotate
Goto Forum:
  


Current Time: Mon Nov 25 18:19:04 CST 2024