total column in accountreport

[Andrés Silva]

Hi everybody... how can I get a total column in the accountreport for every account?

Thanks!

Andrés

[Chris Schlaeger]

On Wed, Dec 28, 2011 at 12:38 AM, Andrés Silva <andres....@gmail.com> wrote:
> Hi everybody... how can I get a total column in the accountreport for every
> account?

I don't understand. The account report columns (hourly to yearly) do
show the total for each account.

Chris

[Andrés Silva]

Ok, sorry... here are a example... the problem is the account report do not provide a total column for the whole project... only the in the profit and loss report can I know the cost for each account but in the last column. How can I make a report with only the total amounts for each account for the whole project? or it is possible to create a total column?... I think tj2 had this feature. So, it will be nice defined a account report like this:


accountreport "TeamBudget" {
  formats html
  accountroot resourceCost
  balance -
  columns no, name, total, yearly { celltext 1 "<-query attribute='turnover'->" }
}

thanks for your help!

Saludos,

Andrés Silva Marambio
Investigador Instituto de Geografía
Ingeniero Agrónomo, Mención en Gestión Ambiental
Pontificia Universidad Católica de Valparaíso

Chris

--
You received this message because you are subscribed to the "TaskJuggler Users" group.
To post to this group, send email to taskjugg...@googlegroups.com
To unsubscribe from this group, send email to
taskjuggler-us...@googlegroups.com
For more information about TaskJuggler visit http://www.taskjuggler.org

[Chris Schlaeger]

On Wed, Dec 28, 2011 at 9:36 PM, Andrés Silva <andres....@gmail.com> wrote:
> Ok, sorry... here are a example... the problem is the account report do not
> provide a total column for the whole project... only the in the profit and
> loss report can I know the cost for each account but in the last column. How
> can I make a report with only the total amounts for each account for the
> whole project? or it is possible to create a total column?... I think tj2
> had this feature. So, it will be nice defined a account report like this:
>
>
> accountreport "TeamBudget" {
>   formats html
>   accountroot resourceCost
>   balance -
>   columns no, name, total, yearly { celltext 1 "<-query
> attribute='turnover'->" }
> }

I've just added a 'balance' column that you can use for this:

columns no, name, balance { title "Total" period ${projectend} +1h},

yearly { celltext 1 "<-query attribute='turnover'->" }

Please try the latest version from the git repo.

Chris

[Andrés Silva]

It works perfectly thanks!

Andrés

Chris

[inp...@gmail.com]

Added to the following source code:

project test 'test project' 2013-01-01 +5y {
    currency 'EUR'
    currencyformat '-' ' ' ' ' '.' 2
    dailyworkinghours 8
    numberformat '-' ' ' ' ' '.' 3
    shorttimeformat '%d-%m-%Y'
    timeformat '%e %b %T'
    timezone 'Europe/London'
    weekstartsmonday
    workinghours mon-fri 08:00-12:00, 13:00-17:00
    workinghours sat, sun off
    yearlyworkingdays 225
    }
    leaves holiday 'New Years day' 2013-01-01,
        holiday 'Good Friday' 2013-03-29,
        holiday 'Christmas day' 2013-12-25
    account projectcosts 'project total cost' {
        account usercosts 'my costs'
        }
    account userrevenue 'my revenue'
    resource usertj 'taskjuggler user' {
        email '...@...'
        workinghours mon-fri 08:00-12:00, 13:00-17:00
        rate 10
        limits {dailymax 6h}
        }
    task task1 'a meeting' {
        allocate usertj
        chargeset usercosts
        #teleconference costs
        charge 10 perhour
        #duration 4h
        effort 1h
        start 2013-06-02
        note 'lorem ipsum'
        }
    task task2 'a very long task' {
        allocate usertj
        chargeset usercosts
        effort 3y
        note 'wow!'
        }
    taskreport summary 'test report' {
        balance projectcosts userrevenue
        #balance -
        caption 'test report summary'
        center 'centre section'
        columns bsi, name, start, end, resources {listitem "<-query attribute='name'->"}, cost, note, chart {period 2013-01-01 +0.5y}
        formats html
        }
    accountreport projectcost 'test project cost' {
        accountroot projectcosts
        balance -
        formats html
        columns name, yearly, balance { title 'Total' period ${projectend} +1h}
        }

The result is:

Name 2013 2014 2015 2016 2017 0.00 1 935.00 3 892.50 5 850.00 6 761.25 0.00 1 935.00 3 892.50 5 850.00 6 761.25 Total project total cost 6 761.25 my costs 6 761.25

Project: test project Version: 1.0 - Created on 2013-04-19 10:11:11 with TaskJuggler v3.4.0

The table above shows the years, but in the browser view (firefox) the last year is not shown (columns show '201')

[inp...@gmail.com]

On Friday, 19 April 2013 11:23:18 UTC+2, inp...@gmail.com wrote:

Name 2013 2014 2015 2016 2017 0.00 1 935.00 3 892.50 5 850.00 6 761.25 0.00 1 935.00 3 892.50 5 850.00 6 761.25 Total project total cost 6 761.25 my costs 6 761.25

Project: test project Version: 1.0 - Created on 2013-04-19 10:11:11 with TaskJuggler v3.4.0

The table above shows the years, but in the browser view (firefox) the last year is not shown (columns show '201')

It would also be nice to compute total project length (duration from start to end)

[inp...@gmail.com]

On Friday, 19 April 2013 11:23:18 UTC+2, inp...@gmail.com wrote:

Name 2013 2014 2015 2016 2017 0.00 1 935.00 3 892.50 5 850.00 6 761.25 0.00 1 935.00 3 892.50 5 850.00 6 761.25 Total project total cost 6 761.25 my costs 6 761.25

For year 1 (2013), why is the account cost '0', when a task occurred during the year?