Maybe then you need to look at the various implementation of CRW in ACT!
And Winfax, which provide a limited number of design capability against
a known data schema.

-----Original Message-----
From: Trent Shipley [mailto:tshipley@symbio-tech.com] 
Sent: Friday, August 24, 2001 3:18 PM
To: 'PLUG'; 'AZTechList'
Subject: RE: [aztechlist] Looking for GUI designer generator

> I would NEVER let users design their own reports.

1) Every RFP and customer request asks about our (non-existent) report
generation capability.

2) Many customers are too small to have anyone qualified to write
reports.

3) No customers want to pay us to write reports.

4) If we don't make customers pay for reports then the customer
reporting
demand is infinite.

5) We fear that if we don't provide custom reports customers will take
their
business to a more PHM-friendly company.

6) SHEs and PHMs want instant gratification.  This is not possible if
they
have to rely on internal or external MIS support.  Besides PHMs resent
having to rely on lower life-forms like DBAs and C-geeks

7) The company is run by C-geeks.  They hate to write reports.  None of
the
employees are CIS folks.  The C-geeks designed the schema.  They resent
paying DB developers.  They *hate* being mocked or lectured by these
lower
life forms.

> First of all most users are not that sophisticated and savvy with
> database schemas to be able to design reports.

Well, they aren't savvy about SQL or databases.  Remember, *paying*
someone
to write a report is a cost sink.  The whole idea is to put a lot of
parasitic MIS cubicle drones out of work.

> In order to generate
> good fast reports, the users need to be familiar with your database
> schema.

1) Yes.  So it won't be so good or so fast.  As near as I can tell
capitalism is about good-enough.
2) PHMR will provide a graphical representation of the schema.  When
C-geek
derives a targeted report generator advanced documentation can be
hyperlinked to the graphical presentation.


> If you're going to do parameterized reports are you going to allow the
> users to write their own stored procedures?

Essentially, yes.  Tools like Access and Paradox come close to doing
this
now.  The graphical query language (or wizards) would let users
associate
any term that references dati in a query with an entry box on a form.
The
PHMR interpreter should have an optimizer that would determine whether
or
not the query could be parameterized.  An option to "save query in
database"
could result in a stored procedure.

> Why not include report building as a service? Give them x number of
> canned reports and build the rest as a service.

Because this does not result in happy customers.  PHMs have a very
cavalier
attitude toward reports and an infinite appetite for them.  Besides, I
really don't enjoy developing canned reports at all.  Furthermore, the
canned reports are nearly useless.  No matter how big the set, the next
customer needs them customized all over again.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
FREE COLLEGE MONEY
CLICK HERE to search
600,000 scholarships!
http://us.click.yahoo.com/zoU8wD/4m7CAA/ySSFAA/_fOolB/TM
---------------------------------------------------------------------~->

==AzTechList============================================================
Unless otherwise noted, list emails are NOT invitations for sales calls!
Report list related problems/concerns: mailto:listcomment@aztechlist.org
AzTechList
  Subscribe: mailto:aztechlist-subscribe@yahoogroups.com
  Unsubscribe: mailto:aztechlist-unsubscribe@yahoogroups.com
  Put email delivery on hold: mailto:aztechlist-nomail@yahoogroups.com
  Change to daily digest mode: mailto:aztechlist-digest@yahoogroups.com
  Change to individual emails: mailto:aztechlist-normal@yahoogroups.com
  Searchable archives: http://groups.yahoo.com/group/aztechlist/messages
Internet related? Please post it to the AZIPA Discussion List instead.
Neither technology or Internet related? Post it to the Off-Topic list.
Please see http://www.aztechlist.org for full List Info and Guidelines.
============================================================AzTechList==


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/