Reports gives correct output in previewer but not when deployed [message #387409] |
Thu, 19 February 2009 02:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Rohan_de_silva
Messages: 5 Registered: September 2008 Location: Sri Lanka
|
Junior Member |
|
|
Hi,
We have a very unusual problem (For Reports 10g Release1).
A report we developed gives correct output when run in the report designer's previewer (paper layout).
But when we deploy the report in the web server, give the same inputs and run it it gives the wrong output. I.e. it shows extra rows that should not be there.
Why do you think this is?
We are unable to locate the problem source.
Any help will be greatly appreciated.
Regards,
Rohan
|
|
|
|
|
|
|
Re: Reports gives correct output in previewer but not when deployed [message #387459 is a reply to message #387445] |
Thu, 19 February 2009 05:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I have no idea. That's really awkward; why would the same report (it IS the same report, right? You didn't misplaced it?) produce different results when run in paper layout and web layout?
SELECT statement can't be the reason - it just doesn't make sense and, as far as I can tell, layout type doesn't affect query results.
Unfortunately, I wouldn't know what to do. Hopefully, someone else will be able to help. Anyway, if you ever come to solution, please, post it here.
|
|
|
Solved the problem [message #388226 is a reply to message #387459] |
Mon, 23 February 2009 23:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Rohan_de_silva
Messages: 5 Registered: September 2008 Location: Sri Lanka
|
Junior Member |
|
|
We finally solved it.
Problem was we were using a ''User Parameter'' (which did not actually get any input from when the report was being called) as a placeholder column.
Once we removed it and put a placeholder in place of that it worked fine both in developer and server.
This goes to show that we should not use user parameters to do calculations in the report.
Thanks for your inputs.
Really appreicate it.
|
|
|
Re: Solved the problem [message #388236 is a reply to message #388226] |
Tue, 24 February 2009 00:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Oh, so it was a parameter who produced such a mess?!? Can't believe it!
Thank you for the feedback; I'm glad you managed to solve the problem!
|
|
|