This is a multi-part message in MIME format.

------=_NextPart_000_0033_01C12CCE.EEBAF700
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Your best choice would be Brio.  Beyond that, BusinessObjects.

Tom Vincent
(experienced with both)
  ----- Original Message -----=20
  From: Trent Shipley=20
  To: PLUG ; AZTechList=20
  Sent: Friday, August 24, 2001 2:40 PM
  Subject: [aztechlist] Looking for report generator generator


  <PHM Reports>

  Then there is the problem of a report generator.  This exists and is =
called
  Microsoft Access.  Microsoft access is too hard to use however.  The =
desired
  magic tool:

  1) Connects to any database and runs on MS.NET / Windows
  2) Allows building queries (Access-like graphical query language)
  3) Forms
  3.1) Must allow any pointy-haired manager (PHM) to parameterize query
  3.2) Any parameterized query can be put into pretty GUI form by PHM.
  3.3) PHM can combine form with GWC
  4) Reports
  4.1) PHM can do roll-ups / grouping _post facto_ or interactively
  4.2) PHM can use Excel-Like tool to interactively roll-up, pivot, or =
cube
  results
  4.3) PHM can design report layout suitable for distribution or =
presentation
  SHE (silver-haired executives)

  5) C-geek friendly (C-geeks program in C, disdain databases as mere =
CIS
  scutt work.)
  5.1) C-geek can use PHMR to abstract subset of functionality to =
provide
  application specific simplified reporting tool.
  5.2) C-geek need not work with OS or RDB user, user-group, or roles to
  restrict (can) applications developed using PHMR as meta-tool.
  5.3) Like PHM, but much less so, C-geek can avoid playing DB developer =
or
  DBA.
  5.4) C-geek can control snapshotting, commit sizes, etc. to tune the
  performance -vs- consistency of any derived reporting tool.

  6) Child-proofing.
  6.1) Restrictions on DB access can be set in derived applications (per =
5.2)
  6.2) PHMR talks to RDBMS to get query plan.  PHMR derived applications =
warn
  of potentially lethal queries per C-geek specifications.  =
Specifications can
  be made accessible to administrators of the derived app.
  6.3) PHMR derived applications can monitor all queries it dispatches =
and
  kill them if they use excessive resources as defined by DBA or C-geek. =
 Kill
  parameters can be exposed for tuning by derived application =
administrator at
  C-geek option.
  6.4) PHMR keeps access plans for all killed queries for length of time =
set
  by C-geek (or app admin) and denies queries with identical or =
super-set
  access plans.

  <How would I search for this sort of tool?>

  =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

  Trent Shipley

  Work:
  (602) 522-7502
  mailto:tshipley@symbio-tech.com
  http://www.symbio-tech.com


        Yahoo! Groups Sponsor=20
              ADVERTISEMENT
            =20
      =20
      =20

  =
=3D=3DAzTechList=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
  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.
  =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DAzTechList=3D=3D=20

  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.=20


------=_NextPart_000_0033_01C12CCE.EEBAF700
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4616.200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3DArial size=3D2>Your best choice would be Brio.&nbsp; =
Beyond that,=20
BusinessObjects.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Tom Vincent</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>(experienced with =
both)</FONT></DIV></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
  <A title=3Dtshipley@symbio-tech.com =
href=3D"mailto:tshipley@symbio-tech.com">Trent=20
  Shipley</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
  title=3Dplug-discuss@lists.PLUG.phoenix.az.us=20
  href=3D"mailto:plug-discuss@lists.PLUG.phoenix.az.us">PLUG</A> ; <A=20
  title=3Daztechlist@yahoogroups.com=20
  href=3D"mailto:aztechlist@yahoogroups.com">AZTechList</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, August 24, 2001 =
2:40=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [aztechlist] Looking =
for report=20
  generator generator</DIV>
  <DIV><BR></DIV><TT>&lt;PHM Reports&gt;<BR><BR>Then there is the =
problem of a=20
  report generator.&nbsp; This exists and is called<BR>Microsoft =
Access.&nbsp;=20
  Microsoft access is too hard to use however.&nbsp; The =
desired<BR>magic=20
  tool:<BR><BR>1) Connects to any database and runs on MS.NET / =
Windows<BR>2)=20
  Allows building queries (Access-like graphical query language)<BR>3)=20
  Forms<BR>3.1) Must allow any pointy-haired manager (PHM) to =
parameterize=20
  query<BR>3.2) Any parameterized query can be put into pretty GUI form =
by=20
  PHM.<BR>3.3) PHM can combine form with GWC<BR>4) Reports<BR>4.1) PHM =
can do=20
  roll-ups / grouping _post facto_ or interactively<BR>4.2) PHM can use=20
  Excel-Like tool to interactively roll-up, pivot, or =
cube<BR>results<BR>4.3)=20
  PHM can design report layout suitable for distribution or =
presentation<BR>SHE=20
  (silver-haired executives)<BR><BR>5) C-geek friendly (C-geeks program =
in C,=20
  disdain databases as mere CIS<BR>scutt work.)<BR>5.1) C-geek can use =
PHMR to=20
  abstract subset of functionality to provide<BR>application specific =
simplified=20
  reporting tool.<BR>5.2) C-geek need not work with OS or RDB user, =
user-group,=20
  or roles to<BR>restrict (can) applications developed using PHMR as=20
  meta-tool.<BR>5.3) Like PHM, but much less so, C-geek can avoid =
playing DB=20
  developer or<BR>DBA.<BR>5.4) C-geek can control snapshotting, commit =
sizes,=20
  etc. to tune the<BR>performance -vs- consistency of any derived =
reporting=20
  tool.<BR><BR>6) Child-proofing.<BR>6.1) Restrictions on DB access can =
be set=20
  in derived applications (per 5.2)<BR>6.2) PHMR talks to RDBMS to get =
query=20
  plan.&nbsp; PHMR derived applications warn<BR>of potentially lethal =
queries=20
  per C-geek specifications.&nbsp; Specifications can<BR>be made =
accessible to=20
  administrators of the derived app.<BR>6.3) PHMR derived applications =
can=20
  monitor all queries it dispatches and<BR>kill them if they use =
excessive=20
  resources as defined by DBA or C-geek.&nbsp; Kill<BR>parameters can be =
exposed=20
  for tuning by derived application administrator at<BR>C-geek =
option.<BR>6.4)=20
  PHMR keeps access plans for all killed queries for length of time =
set<BR>by=20
  C-geek (or app admin) and denies queries with identical or =
super-set<BR>access=20
  plans.<BR><BR>&lt;How would I search for this sort of=20
  =
tool?&gt;<BR><BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR><BR>Trent=20
  Shipley<BR><BR>Work:<BR>(602)=20
  522-7502<BR>mailto:tshipley@symbio-tech.com<BR><A=20
  =
href=3D"http://www.symbio-tech.com">http://www.symbio-tech.com</A><BR><BR=
></TT><BR><!-- |**|begin egp html banner|**| -->
  <TABLE cellSpacing=3D0 cellPadding=3D2 border=3D0>
    <TBODY>
    <TR bgColor=3D#ffffcc>
      <TD align=3Dmiddle><FONT color=3D#003399 size=3D-1><B>Yahoo! =
Groups=20
        Sponsor</B></FONT></TD></TR>
    <TR bgColor=3D#ffffff>
      <TD align=3Dmiddle width=3D470>
        <TABLE cellPadding=3D0 border=3D0 cellspacaaing=3D"0">
          <TBODY>
          <TR>
            <TD align=3Dmiddle><FONT face=3Darial=20
              size=3D-2>ADVERTISEMENT</FONT><BR><A=20
              =
href=3D"http://rd.yahoo.com/M=3D178320.1566800.3122525.1261774/D=3Degroup=
web/S=3D1705043967:HM/A=3D766844/R=3D0/*http://www.fastweb.com/ib/yahoo-5=
7f"><IMG=20
              height=3D250 alt=3D""=20
              =
src=3D"http://us.a1.yimg.com/us.yimg.com/a/fa/fastweb/300x250.gif"=20
              width=3D300 =
border=3D0></A></TD></TR></TBODY></TABLE></TD></TR>
    <TR>
      <TD><IMG height=3D1 alt=3D""=20
        =
src=3D"http://us.adserver.yahoo.com/l?M=3D178320.1566800.3122525.1261774/=
D=3Degroupmail/S=3D1705043967:HM/A=3D766844/rand=3D147610619"=20
        width=3D1></TD></TR></TBODY></TABLE><!-- |**|end egp html =
banner|**| =
--><BR><TT>=3D=3DAzTechList=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>Unless=20
  otherwise noted, list emails are NOT invitations for sales =
calls!<BR>Report=20
  list related problems/concerns:=20
  mailto:listcomment@aztechlist.org<BR>AzTechList<BR>&nbsp; Subscribe:=20
  mailto:aztechlist-subscribe@yahoogroups.com<BR>&nbsp; Unsubscribe:=20
  mailto:aztechlist-unsubscribe@yahoogroups.com<BR>&nbsp; Put email =
delivery on=20
  hold: mailto:aztechlist-nomail@yahoogroups.com<BR>&nbsp; Change to =
daily=20
  digest mode: mailto:aztechlist-digest@yahoogroups.com<BR>&nbsp; Change =
to=20
  individual emails: mailto:aztechlist-normal@yahoogroups.com<BR>&nbsp;=20
  Searchable archives: <A=20
  =
href=3D"http://groups.yahoo.com/group/aztechlist/messages">http://groups.=
yahoo.com/group/aztechlist/messages</A><BR>Internet=20
  related? Please post it to the AZIPA Discussion List =
instead.<BR>Neither=20
  technology or Internet related? Post it to the Off-Topic =
list.<BR>Please see=20
  <A href=3D"http://www.aztechlist.org">http://www.aztechlist.org</A> =
for full=20
  List Info and=20
  =
Guidelines.<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DAzTechList=3D=3D=20
  </TT><BR><BR><TT>Your use of Yahoo! Groups is subject to the <A=20
  href=3D"http://docs.yahoo.com/info/terms/">Yahoo! Terms of =
Service</A>.</TT>=20
<BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0033_01C12CCE.EEBAF700--