Budget report

[Don Zickus]

On Mon, Aug 3, 2009 at 12:44 PM, Colin Law <clanlaw at googlemail.com> wrote:

> 2009/8/3 Phil Longstaff <plongstaff at rogers.com>:
> > The budget report is my current itch, so I've been upgrading it.
> >
> > My latest change is to provide more control over the columns.  To do
> this, the
> > top level creates a scheme list where each element controls a set of
> > budget/actual/diff columns:
> >  - if an element is a number, that is the period (origin 0) for the set
> of
> > columns
> >  - if an element is a list, the list contains period numbers to be
> grouped
> > and accumulated for the set of columns
> >  - if an element is 'total, the set of columns contains the total.
> >
> > For a monthly budget, the current budget report is created by the list
> '(0 1 2
> > 3 4 5 6 7 8 9 10 11).  I'm looking at using '((0 1 2 3 4 5) 6 7 (8 9 10
> 11)
> > total) which will give me Jan-Jun, July, Aug, Sep-Dec, Total for the
> year.
> > This allows it to fit on my screen.
> >
> > To make this more readily available, I think the proper thing to do is
> add a
> > new tab to the options to allow the user to set up the columns.
>  Eventually,
> > besides a "diff" column, a "percentage" column would be useful.
>

I have been hacking on the budget report too.  It isn't really finished but
I haven't had much time to clean it up.
I thought I would throw the patch out here in case you were interested in
some of the pieces.

Two things I mainly tried to accomplish was to increase the width of the
first column to allow the account names to sit on one line.  The second
thing was to have  gnc:html-table-add-budget-line! create the account labels
instead of doing it in two steps.  As a result I can pass back a 0 or 1 if
the account was zero or not.  This is useful later on when people like me
don't feel like looking at a table full of zero'd out accounts, but instead
only want to look at accounts that were used.  This sort of mimics other
report options of 'do not show zero-balanced accounts'.

Anyway feel free to use any of it below if interested.  I have no free time
the next couple of weeks to work on this.  But I figured while you were in
there scratching your itch.. ;-)

Cheers,
Don
-------------- next part --------------
A non-text attachment was scrubbed...
Name: don2.patch
Type: text/x-patch
Size: 7284 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20090803/5788e66f/attachment.bin>