We have a customer trying to access our Oracle based applications using a Reports Engine so called Jet Reports. The data is then exported to MS Excel and treated there.
We have succesfully connected all application but we face an issue when accesing views.
To access data in views in our application usually we need to "LOGIN" using some simple SQL script.
Within the tools we normally use (Sql Developer, Toad, Oracle Reports Writer) basically the script can be louched and then you can create reports with no issues.
Our client is not seeing a way to sent this sql script from within Jet Reports or from Excel so he can´t access data in the views.
Is there any way to do this in Jet Reports or perhaps has to be done from Excel?