Home » Developer & Programmer » Forms » Re: report not giving output
Re: report not giving output [message #79247] Sat, 18 May 2002 02:44 Go to next message
rama krishna
Messages: 97
Registered: December 2001
Member
hii,
u don't need to give all the conditions in the select query only and burden the query. u can siply filter the records at the application level.....

for example in ur query u've "b.BranchCd = 'A1'"(like this u've many in ur query which r trying to relate with characters)) so u don't need to give it in query, remove it from ur query and filter all the records other than branchcd = A1 in report... like this u've lot of things in ur query, try to filter them in report and not in ur query...
now ur report'll definitely execute faster...

hope u've understood the solution and this'll work for u....

cheers
ram
Re: report not giving output [message #79253 is a reply to message #79247] Mon, 20 May 2002 02:34 Go to previous message
hnetscape
Messages: 30
Registered: December 2001
Location: India
Member

Hello sir,

I tried it by giving in the report also it is not working. If I want the result in sql*plus that their I have to give that filters then how can I get the result.

Regards,
Raju.
Previous Topic: Re: closing all forms...
Next Topic: problems while inserting a new record
Goto Forum:
  


Current Time: Mon Aug 03 05:09:47 CDT 2020