[ic] How best to get SQL Reports

Jonathan Clark interchange-users@icdevgroup.org
Sun Aug 25 05:22:03 2002


> > My understanding quotient is a little low today, I'm not sure
> what you are
> > asking.  3 random facts that come to mind:
> >
> >   * I've used Seagate Crystal Reports to create reports from
> SQL databases.
> >   * The Admin has the order reports feature (totals, etc.)
> >   * The "Orders" section has a one-order "report" of user data,
> skus, etc.
> >
> > I don't know if that helps at all.

...

>
> Actually it does give me an idea... I can copy and modify the section of
> the IC code that generates the "report" for each order. Can anyone point
> me to where that section of code lives?

Within the Interchange core code, something like:

/usr/lib/interchange/lib/UI/pages/admin/reports/order

you can add your own reports into your <catroot>/pages/admin/reports/orders
directory for a per-catalog override of the UI pages.

Jonathan
Webmaint.