We spent a fair bit of time building our schema so that the data appears to be in 1nf for Crystal to understand it. We've made some reports out of it that are pretty impressive and would have required a number of basic routines and some "work" files to create.
They will be able to get the reports out of Crystal. Perhaps you need different experts. Depending on how much work it is to import the data back into UD that may be a very good (but likely interim) fix. It would allow them to get the reports they are used to relatively quickly and allow them time to build the reports in Crystal using the "live" data. remind them over how long you've been building and tweaking those reports and they may start to understand that it will take a while to get them done in Crystal. The one thing that you can do with the ODBC "view" is build a lot of "virtual" dicts. For example you can have a "CLIENT_NAME" field in your INVOICE table that actually pulls the name using the CLIENT_ID from the CLIENT file so you don't need to setup the joins for the report. Good luck -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-----Original Message----- >From: Mark Johnson [mailto:[EMAIL PROTECTED] >Sent: Friday, April 16, 2004 12:51 PM >To: U2 Users Discussion List >Subject: Crystal Reports > > >One of my clients wants to connect Crystal Reports to their UD >database to apparently give greater access to the data that >they sometimes deem as hidden and only accessable through me. > >This client converted to Great Plains 6 weeks ago (SQL based) >and their CR experts were struggling with duplicating some of >the more mundane reports that already exist in UD. A monthly >sales tax summary (by jurisdiction) took the GP guy 3 days >futzing with CR using GP's data. > >How much trouble are they going to get in trying to use MV'd >data from the UD system (ODBC) if they have so much trouble >with more 'normalized' data. Everyone seems to think that CR >is a magic pill and once attached to a SQL database, the >sophisticated reports simply roll off. > >I'm trying to strongly propose a data warehouse concept >whereby the day's sales data gets exported and updated into >their prior application for the sake of the multitude of >existing, proven reports in MV. If these guys took 3 days for >a simple tax report, how can CR fabricate temporary tables for >the sake of these consolidated sophisticated MV reports? > >I'm just interested in hearing of some experiences. This >client is too stubborn to go back from GP and may even >disregard their entire MV system completely. I really have >nothing to lose if I insult them. > >Thanks in advance. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
