dillybar
asked on
Need advice printing db reports from Stored Procedure
We are porting our Oracle Forms code to run in Oracle Package / Stored Procedures.
We have many RDF reports to print on Oracle 9i db.
What are the best ways to print the existing reports or
should we convert the RDF to something else? to what?
The reports include barcode printing. We don't have Oracle Reports Server at the moment.
We thought about using Loftware but what product or methods would you suggest?
We have many RDF reports to print on Oracle 9i db.
What are the best ways to print the existing reports or
should we convert the RDF to something else? to what?
The reports include barcode printing. We don't have Oracle Reports Server at the moment.
We thought about using Loftware but what product or methods would you suggest?
The only thing that can execute a RDF is Oracle Reports Server. If you are migrating your forms to another platform, you must also migrate your reports before you can do without Oracle's Application Server.
ASKER
Looks like you both confirmed what we were finding on the web.
Do you know the ballpark price for Oracle Fusion? Is it around $5,000?
If we bought that package, do you think Reports Server will still take a lot of effort
to put in place and print out what we've got?
Loftware would cost us a lot less money and we know it works, so just wondering what you think about the Oracle Report product.
Do you know the ballpark price for Oracle Fusion? Is it around $5,000?
If we bought that package, do you think Reports Server will still take a lot of effort
to put in place and print out what we've got?
Loftware would cost us a lot less money and we know it works, so just wondering what you think about the Oracle Report product.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your time and advice. You both gave good tips on helping know where to go with this.
That's what the Reports software is for. You may be able to use 3rd party packages or external routines like Loftware. I've not use any of those to make a recommendation though.
As an intermediate step you may want to consider staying with Reports but moving more of the data processing and logic to server side stored procedures but letting the actual printing occur from Reports.
After that, if you want to swap out the printing functionality for loftware for some other tool it will hopefully be easier.