Thank you both for the workfile suggestion. We have toyed a bit with this idea. One of the challenges we face is that we have 200 users who can run reports via the Web and the Crystal Enterprise reporting engine. Two simultaneous users couldn't use a single workfile simultaneously. We haven't found an easy way to build, odbc-enable, and then destroy workfiles, but this is a method that bears further investigation.
Thanks again to everyone who responded. Jim --- Jeff Schasny <[EMAIL PROTECTED]> wrote: > To expand on Colins idea of a work file: > > What about creating a process which can be passed a list of column definitions > (title,width,datatype, etc) and a set of report data thenand creates an ODBC > enabled work file > which could be accessed by crystal reports with a simple "SELECT * FROM" SQL > statement. > > > > -----Original Message----- > 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 > > > > > Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > "...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 - You care about security. So do we. http://promotions.yahoo.com/new_mail ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/