Hello,
I have a customer using Universal connector licence.
This customer asked if we can using and manipulating View (stored in database) in SQL Server or Oracle Databases.
Is it possible with NL functions ? :?:
Thanks a lot,
Gilles (Fr)
Date
Votes
3 comments
-
Jet Reports Historic Posts I personally have no experience with the universal connector, but as a DBA (SQL) views are generally presented as a table, so I would think Jet would not know any different.
However I do not know what the performance would be like. An alternate option would be creating some tables with the same schema as the view and populating them nightly via batch. You could then create indexes, etc as needed to improve performance without impacting source tables. -
Jet Reports Historic Posts If you look in the Jet Reports documentation you will find information about using SQL views on page 69, 82 and 192.
The documentation of the latest version may be found here: http://support.jetreports.com/index.php?_m=downloads&_a=viewdownload&downloaditemid=12&nav=0,14 -
Jet Reports Historic Posts Thanks a lot for your responses… I pratique Jet with Navision since some years but i have no skills on SQL database and it is the first time i implemente a universal connector for a customer.
Best regards and continu to guide them on the JetReport Way ;-)
Gilles
Please sign in to leave a comment.