| Re: report not giving output [message #79247] |
Sat, 18 May 2002 02:44  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
