How to Initialize sessions to a Oracle View from Jet Reports MS Excel
Hello Experts!!!
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?
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?
I forgot to mention, notice how the username and password (optional) is passed via the connection string. This serves as the 'LOGIN'.
ASKER
Hello Jon,
Jet Reports is a reporting tool: http://www.jetreports.com/
They connect to different databases and pull data to create reports in Excel.
I hope that clarifies better.
Thank You
Jet Reports is a reporting tool: http://www.jetreports.com/
They connect to different databases and pull data to create reports in Excel.
I hope that clarifies better.
Thank You
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Jon,
But I dont see where in that TAB I can enter some Pl/SQL.
We are connected to the DB succesfully but the problem is that we need to also initialize session to the actual application.
What do you think?
Thanks in advance
But I dont see where in that TAB I can enter some Pl/SQL.
We are connected to the DB succesfully but the problem is that we need to also initialize session to the actual application.
What do you think?
Thanks in advance
I'm out of my depth here because I don't know Jet Reports. I had a bit of a browse on the web and I see that there are two different types of licenses. One is viewer another is designer. Designers appear to be given a control called 'Design'. I wonder if one sets up the query in there. I couldn't find any references for setting up queries with SQL. I did however read that reports can be linked to stored procedures but I couldn't find examples how.
Sorry I can't be more helpful.
Sorry I can't be more helpful.
ASKER
Thanks a lot Jon anyway, I can see this one is a tricky one!!!
ASKER
Hello,
Just to let you know that our customer was discussing with Jet Reports in paralel and they will include such functionallity in the mid term.
Thanks for you help
Just to let you know that our customer was discussing with Jet Reports in paralel and they will include such functionallity in the mid term.
Thanks for you help
ASKER
Jet report will include thia fubctionallity in the future
I'm afraid I don't know what is meant by 'Jet Reports'. I presume it means that your customer means to use the Microsoft Jet OLEDB provider, and therefore probably intends on querying the database using ADO in excel VBA.
Rather than using the Jet provider he should be using a different one. This will affect the connection string, but likely he won't need to change his SQL or the other ADO code. See here for a list of providers for Oracle, and connection strings for each: http://www.connectionstrings.com/oracle
I think that your client should know what to do with it.
Best of luck! :)