sql-ledger-users

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

[Prem P. <pre...@gm...>]

I need to provide a lot of reporting and the readers of the reports want a
column added to all sql-ledger reports that show the account description.
How could I accomplish this in sql-ledger?

thanks
Prem

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

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

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.

In GL.pm, you add something like following in $query (sub
transactions). Put this in all three queries comprising UNION.
                 c.description AS accdescription,

In bin/mozilla/gl, follow 'accno' and add similar code for accdescription.

Let me know if you can't do it and I shall send you my patched gl.pl
and GL.pm files (for 2.8.11)

Regards


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

Free trial available.
--

On 1/17/08, Prem Pradeep <pre...@gm...> wrote:
> I need to provide a lot of reporting and the readers of the reports want a
> column added to all sql-ledger reports that show the account description.
> How could I accomplish this in sql-ledger?
>
> thanks
> Prem
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

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

[Yves L. ing. <yve...@gm...>]

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.

Regards,

Yves

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.
--

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

[Yves L. ing. <yve...@gm...>]

Armaghan Saqib wrote:
> 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.
>   =

Yes you can, but editing and knowledge of perl and sql is required,
which is not for the end user. For example, I need a monthly sales
journal, with all taxes, ordered by date. Not hard to do, but definetely
requiring programmation. Or I need a GL transactions report, grouped by
accounts and sorted by date. Same.

A reporting tool could take care of that and let the user picks his
preferences for Custom Reports, without requiring programming knowledge.

Yves

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

[Michael H. <mh...@it...>]

Not to be a twit, but the back end database is open and the layout is  
pretty easy to figure out.  Custom reporting is generally better done  
with something like Crystal Reports or MS-Access or other GUI front  
end...


Thanks,

Michael



On Jan 17, 2008, at 6:48 AM, Yves Lavoie ing. 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.
>
> Regards,
>
> Yves
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

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

[Wallace R. C. <wrc...@gm...>]

On 1/17/08, Michael Hasse <mh...@it...> wrote:
> Not to be a twit, but the back end database is open and the layout is
> pretty easy to figure out.  Custom reporting is generally better done
> with something like Crystal Reports or MS-Access or other GUI front
> end...

If anybody wants easy, GUI access to his/her data, this tool will come in handy:

http://phppgadmin.sourceforge.net/

-- 
Best Regards,
Wallace