Marketcircle Home Products Support Blog Forums Partners Store
Marketcircle    Forums  Hop To Forum Categories  Extending Daylite  Hop To Forums  Building Reports and Print Layouts    Tasks - Sum of Duration?
Page 1 2 
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Journeyman
Picture of Thorri
Posted Hide Post
I've sent the Template to our fellows above, but couldn't find out how to post the Template on the 'Share Zone'. Is there a knack?


- - - - - - - - - - - - - - - - - - - - -
A good design is better than you think.
- Rex Heftmann
 
Posts: 95 | Location: Iceland | Registered: June 23, 2006Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
Can you email me this template?

quote:
Originally posted by Rich Krug:
I was looking for the same thing. In the event you are still looking for this, here are the steps I took using 3.1.2:

1) Created a report showing individual activities and durations for the current week. When selecting the duration, select the "Duration (Seconds)" field - parent.reportData.object.durationSeconds
2) I don't know if this is a database problem on my end, but my results were actually minutes instead of seconds. I double clicked the duration field, Appended *60 to "Duration (seconds)" and checked "Evaluate entire text as mathem..." and selected a format.
3) Select the "Table" part from the outline view on the screen left, and "Table" under Info (screen right)
4) Checked "Has Summary Row", and selected the newly created summary row.
5) Selected the cell I wanted to contain the summary, and checked "Dynamic Text", and double clicked the cell.
6) Under fields, navigated to "Table -> Tasks -> Duration (seconds)" and double clicked.
7) Under Path:, I had "parent.parent.reportData.objects.durationSeconds". Insert "@sum" after objects so the path looks like

"parent.parent.reportData.objects.@sum.durationSeconds". Again, I had to multiply by 60 and select a display format to convert the minutes to seconds.
8) Previewing the report shows me individual tasks and total duration for the week.

I think the duration (seconds) field is a recent addition. Hope this helps.
 
Posts: 36 | Location: St. Cloud, MN | Registered: July 13, 2006Reply With QuoteEdit or Delete MessageReport This Post
Journeyman
Picture of Thorri
Posted Hide Post
As how to post the template on the forum totally escapes me, I'll need your email address. You can also send me a note to thorri <at> mi dot is.


- - - - - - - - - - - - - - - - - - - - -
A good design is better than you think.
- Rex Heftmann
 
Posts: 95 | Location: Iceland | Registered: June 23, 2006Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
quote:
Originally posted by Patrick Leonard:
For sure, send me your email address


Hi Patrick

I read all the threads with interest, I have struggled this for several hours - could you please email me the layout to produce a list of tasked but grouped by Category - or anythink similiar that I may be able to follow

Many thanks


gary@mooney.eclipse.co.uk
 
Posts: 2 | Registered: January 27, 2007Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
Hi Thorri

Did you manage to get your templates uploaded to the "Share Zone"?

If not, would it be possible to still get a copy?

Much appreciated smile

Michelle
michelle@visualunity.com.au
 
Posts: 8 | Registered: August 22, 2006Reply With QuoteEdit or Delete MessageReport This Post
Journeyman
Picture of Thorri
Posted Hide Post
Sent smile

(I need to spend a bit of time figuring out this Share Zone issue I alone seem to have)


- - - - - - - - - - - - - - - - - - - - -
A good design is better than you think.
- Rex Heftmann
 
Posts: 95 | Location: Iceland | Registered: June 23, 2006Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community Page 1 2  
 

Marketcircle    Forums  Hop To Forum Categories  Extending Daylite  Hop To Forums  Building Reports and Print Layouts    Tasks - Sum of Duration?

 

Refund Policy | Privacy Policy | Site Map | About Marketcircle
©2008 Marketcircle Inc. All rights reserved.
webmaster@marketcircle.com