|
|
||||||||
|
|
|
|
|
|
|
|
Go
![]() |
New
![]() |
Find
![]() |
Notify
![]() |
Tools
![]() |
Reply
![]() |
|
|
Apprentice |
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? |
||
|
|
Marketcircle Team |
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. |
|||
|
|
Apprentice |
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. |
|||
|
|
Marketcircle Team |
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. |
|||
|
|
Apprentice |
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. |
|||
|
| Previous Topic | Next Topic | powered by eve community |
| Please Wait. Your request is being processed... |
|

