I am looking to replace crystal reports in a large application. The back end is an Oracle 11g Database. I have been playing around with LifeCycle ES and got a oledb based form/report to work, but it required that a dataconnection with account/password be set up on the client machine, and a fair amount of javascript to fetch
and display the rows of data (opening connection, fetching through each row, moving data items from record
into local variables, moving from local variables into subform fields, etc., etc.).
I figure there has to be a better approach given all the tools and products adobe has. I have spent several days examining lots of manuals from various adobe products, but I haven't found a clear answer. What technology is best at Having a repository of pre-formed reports that can be called-up via a web browser, connecting to an
Oracle database back-end. The data for the reports will vary based upon the users application login_id, and
report requested, but the only direct connection to the database needs to remain behind the data center's firewall. (ie. link between database server and webserver and/or report server).