Sorry, I haven't played much with our Crystal reports, but I think we had a similar problem. However, we didn't have the large library of paragraphs that we felt compelled to re-use.
I didn't think it was all that slow. We did figure out how to do some neat things with Crystal though. What about calling a "pre-process" that creates a work file for reporting? Colin Alfke Calgary, AB >-----Original Message----- >From: Jim Bullock > >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 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/