We've had problems with BO (hmmm...) against our 8.1.7.2.0 DBs. Sometimes,
when the user cancels a particularly bad BO report, the server process on
the DB loops infinitely.
Also, from a design aspect, it seems that it's difficult to join tables in
multiple ways for multiple reports. Not
There is always Excel. ;o)
-Original Message-
Sent: Thursday, June 20, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L
Steve,
If you can't convince Oracle Reports to perform in
the way we would like don't expect Crystal to be anything but worse. It might
be more useful to
My exprience with Crystal is responding to problems like I can't get
Crystal to do this or that. My usual answer is create a packaged function
that returns a REF CURSOR that returns the results in a format that Crystal
deal with. The more recent the Oracle version, the easier this is to
Title: RE: Alternative to Crystal Reports
I have yet to see something that I cannot do in Crystal Reports. However, I don't write the reports off of tables, I use stored procedures to query and process the records and return cursors to the crystal report. That way all the data is massaged
I've never used it, but this may be worth a look at:
http://sourceforge.net/projects/datavision/
It looks to be a little rudimentary, judging by screenshots, but you never
know. And it appears to be in beta, but there's a lot of activity on the
project right now.
HTH! GL!
Rich Jesse
When I have had to rarely deal with report writers, or heck really any ODBC
tool I use the approach you describe. Write a stored procedure that returns
EXACTLY what you need, then just let the tool format it.
In this case however, The problem is we want drill down capability. Now
while Oracle