Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
aggregate nested table
Ingoos
can anyone help me to aggregate nested table ?
there is example what i wanna do
tnx
Find more posts tagged with
Comments
mwilliams
Drag an aggregation from the palette to your nested table footer and choose what you want to do. If this doesn't help, can you explain a little more?
Ingoos
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75635" data-time="1302210765" data-date="07 April 2011 - 02:12 PM"><p>
Drag an aggregation from the palette to your nested table footer and choose what you want to do. If this doesn't help, can you explain a little more?<br /></p></blockquote>
<br />
<br />
aggregation is in nested table. <br />
<br />
i wanna sum all aggregation in table binded to dataset orderlist ... and i can't bind OrderDetailsTable. <br />
<br />
if you open attached report you will realize what i want
Ingoos
anyone ???
mwilliams
Sorry, didn't see the footer when I looked the first time. Here ya go. Initialized a variable in the initialize, added the current table value to the total in the onCreate of the table, then recalled the variable with formatting in the text box in the outer table footer. Hope this helps.
Ingoos
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75690" data-time="1302295113" data-date="08 April 2011 - 01:38 PM"><p>
Sorry, didn't see the footer when I looked the first time. Here ya go. Initialized a variable in the initialize, added the current table value to the total in the onCreate of the table, then recalled the variable with formatting in the text box in the outer table footer. Hope this helps.<br /></p></blockquote>
<br />
thanks
<br />
<br />
i figure it out with variable, but i inserted 'data' (coloum binding) in footer instead 'text' as you did ... and result was wrong all the time.
mwilliams
It looks like when you use a data element that is misses the last value if you set the expression in the data element editor. If you set the display value in script, it works correctly. See the attached report.
Ingoos
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75716" data-time="1302528945" data-date="11 April 2011 - 06:35 AM"><p>
It looks like when you use a data element that is misses the last value if you set the expression in the data element editor. If you set the display value in script, it works correctly. See the attached report.<br /></p></blockquote>
<br />
<br />
got it
... thanks you very much
mwilliams
No problem! Let us know whenever you have questions!