Marketcircle    Forums  Hop To Forum Categories  Billings  Hop To Forums  Creating Estimates and Invoices    Where can I get my token ?
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Apprentice
Posted
Hello

I am trying to put my hands in reports design and although I am not a newbie into table rows, table data concept, I have to admit it is fairly harsh.

I am trying ro customize a report called "detailed time and flat activity" so that is more simple.
I just need slip detail column, slip date entry colum and slip duration colum in a table row PLUS a new row with the total of all the slips duration !!!

I managed to make that row but impossible to call/find the slip total duration token when putting a dynamic textarea.
Where can I find it please ?

Thanks for any help
 
Posts: 3 | Location: Paris, France | Registered: August 30, 2007Reply With QuoteEdit or Delete MessageReport This Post
Marketcircle Team
Picture of Oscar
Posted Hide Post
You should be using the summary rows on the table for totals. You can do this selecting a cell in the summary row and then checking off the box in the attributes that reads Allow Dynamic Text.

Once you do that double click the cell and then trace the path to the token. Double click the token to add it and then edit the path.

For example say this is the path:

parent.parent.reportData.objects.total

You would change it by adding an @sum:

parent.parent.reportData.objects.@sum.total


Let me know the results!

This message has been edited. Last edited by: Oscar,
 
Posts: 500 | Location: Toronto | Registered: February 20, 2007Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
quote:
Originally posted by Oscar:
You should be using the summary rows on the table for totals. You can do this selecting a cell in the summary row and then checking off the box in the attributes that reads Allow Dynamic Text.

Once you do that double click the cell and then trace the path to the token. Double click the token to add it and then edit the path.

For example say this is the path:

parent.parent.reportData.objects.total

You would change it by adding an @sum:

parent.parent.reportData.objects.@sum.total


Let me know the results!



Hello Oscar and thanks for your reply.
I dit what you say:
Add a summary row and found the generic token under the right colum in Report/Object context/ which produced the folling path : parent.parent.parent.parent.parent.parent.reportData.objectContext

Then I replaced the last .objectContext by objects.@sum.total
But it says no data when producing the report.
I put the template at the following url so that you can check it out : link to my report template
 
Posts: 3 | Location: Paris, France | Registered: August 30, 2007Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

Marketcircle    Forums  Hop To Forum Categories  Billings  Hop To Forums  Creating Estimates and Invoices    Where can I get my token ?

© Copyright 2006 Marketcircle Inc. All rights reserved.