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

Reply via email to