We are having quite a bit of success writing reports with Crystal Reports,
using ODBC to access
our UD6 database. We have gone through the exercise of flattening files,
creating new dicts, etc.
It's slow, but we are usually able to get what we need. We serve up the
reports to the users
with Crystal Enterprise and Apache.
We are not, however, able to take advantage of one (IMHO) of the most powerful
features of a U2
database, the ability to manipulate sets of id's through the use of SELECT,
SAVE.LIST, GET.LIST,
MERGE.LIST, etc. We have a very large library of UniQuery paragraphs which do
multiple selects on
multiple files, saving foreign keys, eliminating duplicates, etc., to arrive at
a final savedlist
of id's of records to be put on a report. Currently we use this list of id's
to write a report in
UniQuery. We would love to be able to write this report instead in Crystal.
There would be no
SQL SELECT at all in the Crystal report, the selection of the proper records
having already been
accomplished by the server-based procedure.
The natural, or so I thought, place to do this sort of thing is in a stored
procedure. I got as
far as "seeing" the stored procedure name via the OleDB driver, but was
unsuccessful in actually
"seeing" any data. Many e-mails and phone calls with our VAR and IBM later, we
were pointed to a
place in the UD documentation where it says stored procedures are not supported
by UniData.
We have racked our brains and have been unable to come up with a workaround for
this gaping hole
in the ODBC/OleDB interface to UniData. Before we give up entirely and resign
ourselves to
putting out paper reports with UniQuery, I thought I would ask this group if
anyone has solved
this problem. Anyone?
Thanks in advance,
Jim
"...a livable wage is a moral value. Affordable health care is a moral value. A
decent education is a moral value. A common sense foreign policy is a moral
value. A healthy environment is a moral value. The feeling of community that
comes from full participation in our democracy is a moral value. It is a moral
value to make sure that we do not saddle our children and grandchildren with
our debt."
-Howard Dean
__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
