Jim, We understand exactly your challenge. While Reporting packages like Crystal and Safari provide excellent function in displaying the data, they are very constrained regarding the ability to use native routines, saved-lists, etc. The ODBC interface is not MV friendly. Our Informer Web Reporting package, uses UniObjects so it can understand all native U2 commands. Informer also provides a Pre and Post Select user exits so that advanced users can insert native U2 processes (GET.LIST and SELECT statements, UniQuery paragraphs). The best thing about using UniObjects is that it fully takes advantage of the beauty of Multi-values. We display them, insert them logically into Excel and PDF output options, and provide associated Multi-value selection options. P.S. I love your Howard Dean quote.. Good luck, Doug
Doug Leupen entrinsik, Inc. Phone: (919) 848-4828 x113 Cell: (919) 302-0459 Fax: (919) 848-4829 Email: [EMAIL PROTECTED] www.entrinsik.com <http://www.entrinsik.com> > > > >-----Original Message----- > >From: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [mailto:owner-u2- > >[EMAIL PROTECTED] On Behalf Of Jim Bullock > >Sent: Tuesday, 15 March 2005 9:55 AM > >To: [email protected] <mailto:[email protected]> > >Subject: [U2] UD: ODBC/OleDB access to selected records in a file > > > >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 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
