Marketcircle Home Products Support Blog Forums Partners Store
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Apprentice
Posted
I have a report that pulls data from a custom form. I want to create a summary row that sums the columns in the table. I am using the following: enclosingReportTable.reportData.objects.@sum.Estimated Wholesale

in a dynamic text box in the summary row of my table (Estimated Wholesale is a number and also refers the token which puts that data into one of the table's columns). All it returns is the expression as text.

I have also tried entering: parent.parent.reportData.objects.@sum.Estimated Wholesale

How can I get this @sum working in the summary row?
 
Posts: 3 | Registered: December 17, 2008Reply With QuoteEdit or Delete MessageReport This Post
AJ
Marketcircle Team
Picture of AJ
Posted Hide Post
Two issues - what does "objects" contain? An array of CustomRecordSets (Forms)? or an array of CustomRecord(s)?

If you have CustomRecordSets, then try enclosingReportTable.reportData.objects.@sum.dictionaryRepresentation."Estimated Wholesale"

Calling dictionaryRepresentation on CustomRecordSet returns a dictionary where the key and values are made up from the array of CustomRecords that the Set contains. The dictionary representation is much better understood by KVC.
 
Posts: 940 | Location: Toronto | Registered: May 03, 2006Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
I got the following error: Error [<GWContact 0x19828120>
valueForUndefinedKey:]: this class
is not key value coding-compliant for
the key dictionaryRepresentation.
during data extraction for text area:
Text Area string content:

It says Text Area string but it is a number (don't know if that is a valid difference really).
Here is a link to the report.
 
Posts: 3 | Registered: December 17, 2008Reply With QuoteEdit or Delete MessageReport This Post
AJ
Marketcircle Team
Picture of AJ
Posted Hide Post
You need to get the forms. Right now you have contacts.

You may need one more nested table or change the filter on the table to return forms.
 
Posts: 940 | Location: Toronto | Registered: May 03, 2006Reply With QuoteEdit or Delete MessageReport This Post
Apprentice
Posted Hide Post
Is there another way to do the sum? I have a contacts table that has the form table nested in it. I want to put the sum of the form table columns (Estimated Wholesale, etc.) in the summary row of the contacts table (see link above for reference). When I put in the table I want to make a form table in the summary row of the contacts table I get an error saying, "Adding Forms Filter at this juncture is not allowed. Please ensure the correct parent element is in place".

I have posted some images of the layout and output here: www.joshuahousetyrone.org/Picture1.png and www.joshuahousetyrone.org/Picture2.png

As you can see from Picture2 I am getting no data b/c I cannot put a form filter on that table b/c of the error cited above.

It just seems like it should be easier to sum up a column of data.
 
Posts: 3 | Registered: December 17, 2008Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 


 

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