Blank report [message #140269] |
Mon, 03 October 2005 05:48 |
reivajnr
Messages: 1 Registered: October 2005
|
Junior Member |
|
|
Hi everybody.
I have a report that does not show anything. I use Report Builder 6i on Oracle DB 8.0.6
It accesses a table that needs a synonym to be accessed. I needed to change the structure of the table so I dropped the table, recreated it and run a pl/sql procedure to recreate the synonym for it. After doing this the report is not shown, although there is data in the table and the report's sql query works and retrieves the data correctly (I cheked this on Toad).
Please, can you give me any ideas of what could be the problem?
Thanks in advance
|
|
|
Re: Blank report [message #141418 is a reply to message #140269] |
Mon, 10 October 2005 02:58 |
m_ashtiani
Messages: 27 Registered: August 2005 Location: Reno
|
Junior Member |
|
|
if your reports sql query works, then permissions are correct. i suggest to check the design or paper view to see if fileds are related to your sql query. also check format triggers and conditions that may return false. does the user that runs the report have select permission?
|
|
|