Re: [SL] How to add Account Description as column in GL and other reports

[Armaghan S. <sa...@le...>]

On 1/17/08, Yves Lavoie ing. <yve...@gm...> wrote:
> Armaghan Saqib wrote:
> > As far as I know this is not available in current sql-ledger version.
> > We can request Dieter to  add this in the coming versions of SL. For
> > the time being I have patched my installation for this. You need to
> > edit two files for this. SL/GL.pm and bin/mozilla/gl.pl.
> >
> Reporting has always been painful for designers because everybody wants
> to add this or that or build a special report, just once, ...
>
> IMHO, if we are to ask Dieter to change the current reporting structure,
> it would be more efficient to ask for a way to let the user easily
> customize or build special reports instead of asking for specific
> modifications.

To be fair, SL has reasonably good reporting functionality. You can
customize reports by selecting which columns you want in the report.
Sorting and auto-subtotals by sorted columns etc are there too. You
get such reports on almost all tables.

The rest of the reports which people want will be multi-table reports
requiring understanding of database schema as well as relationships
between tables. A thing hardly any typical end-user can do.

I have made availble on my website a simple perl script which allows
you to build and add reports to sql-ledger if you know some sql. Many
users have downloaded and used it. The problem they still face is how
to write the SQL to pull required information from different tables
and this require reasonable schema understanding.

So I don't think some sort of report writer is going to solve the
reporting issue of end-users unless they learn some SQL and sql-ledger
schema.

-- 
Purpose-built SQL-Ledger Hosting
http://www.ledger123.com/

Free trial available.
--