Created two custom reports which help in listing all the requirements in a project and estimating the effort required.
Milestone-wise breakup report
query:?status=accepted
&
status=assigned
&
status=closed
&
status=new
&
status=reopened
&
group=milestone
&
order=priority
&
report=9
&
col=id
&
col=summary
&
col=status
&
col=type
&
col=priority
&
col=component
&
col=keywords
&
owner=admin
Component-wise effort estimation report
query:?status=accepted
&
status=assigned
&
status=new
&
status=closed
&
status=reopened
&
group=component
&
order=id
&
col=id
&
col=summary
&
col=type
&
col=milestone
&
col=estimatedeffort
&
col=billable
&
row=description

Let us suit our trac environment to accomodate custom fields which are useful in reports. I added two fields billable activity which is a checkbox and estimated effort in man days which is textbox.
To do this we edit the trac.ini in the project/conf folder
#vim /trac/project/conf/trac.ini
We add the following lines.

[ticket-custom]

billable = checkbox
billable.label = Billable Activity
billable.value = [...]

You can edit any remote page with the following javascript code in browser
javascript:document.body.contentEditable=’true’; document.designMode=’on’; void 0
To bring it back to non-editable state
javascript:document.body.contentEditable=’false’; document.designMode=’off’; void 0

• Search

• Categories

  • Hacks
  • Linux
  • Miscellaneous
  • Trac

• Recent Blogposts

  • Apache virtual hosts
  • Moodle mod rewrite
  • Moodle migration in 3 steps
  • htaccess cheatsheet
  • sshfs and remote php debugging
  • Pulling data from cross-domain URL using jQuery and YQL
  • MySQL statements & clauses

• Interesting Links

  • Moodle theme engine
  • Xor eax, eax
  • Key to School
  • Moodle Community
  • Joomla CMS
  • Drupal
  • GIT Versioning
  • Trac