Codejock Developer Community : Dynamic Formula in Group Rows

Codejock Developer Community : Dynamic Formula in Group Rows http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 30 Apr 2026 12:11:25 +0000 Sun, 05 Sep 2010 02:17:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=14968 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Dynamic Formula in Group Rows : Hi Can somebody help me to display...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=60053&title=dynamic-formula-in-group-rows#60053 Author: Genius
Subject: 14968
Posted: 05 September 2010 at 2:17am

Hi

Can somebody help me to display total in group rows. as shown in following screenshot.

available example in this forum is in VB. what will be the equivalent code in VC++.

Thanx in advance. ]]> Sun, 05 Sep 2010 02:17:02 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=60053&title=dynamic-formula-in-group-rows#60053 <![CDATA[Dynamic Formula in Group Rows : This the picture of new feature...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=55975&title=dynamic-formula-in-group-rows#55975 Author: mdoubson
Subject: 14968
Posted: 04 January 2010 at 3:57pm

This the picture of new feature - https://support.codejock.com/Attachments/20091228-140707_GroupRowsWithMultipleSubtotals.jpg]]> Mon, 04 Jan 2010 15:57:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=55975&title=dynamic-formula-in-group-rows#55975 <![CDATA[Dynamic Formula in Group Rows : Hope you understand mixed url...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=55954&title=dynamic-formula-in-group-rows#55954 Author: mdoubson
Subject: 14968
Posted: 03 January 2010 at 12:22am

Hope you understand mixed url - should be https://forum.codejock.com/uploads/BetaOCX/ReportControlBeta13-2-2.rar]]> Sun, 03 Jan 2010 00:22:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=55954&title=dynamic-formula-in-group-rows#55954 <![CDATA[Dynamic Formula in Group Rows : Coming version will support multiple...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=55945&title=dynamic-formula-in-group-rows#55945 Author: mdoubson
Subject: 14968
Posted: 02 January 2010 at 2:50am

Coming version will support multiple subtotal in group rows (dynamic formula) -

archive with beta has VB6 samples with this new feature:

https://forum.codejock.com/uploads/BetaOCX/CalendarBeta13-2-2.rar

]]> Sat, 02 Jan 2010 02:50:11 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=55945&title=dynamic-formula-in-group-rows#55945 <![CDATA[Dynamic Formula in Group Rows : Hi Mark, Thanks for the updates. Going...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=52284&title=dynamic-formula-in-group-rows#52284 Author: joeliner
Subject: 14968
Posted: 21 August 2009 at 9:00am

Hi Mark,

Thanks for the updates.

Going live on a project so may not be able to fully play-around with all the new features till early september. But for the few av been able to test I must say 'CJ, you are on the right track.'

Kudos.

regards,

]]> Fri, 21 Aug 2009 09:00:16 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=52284&title=dynamic-formula-in-group-rows#52284 <![CDATA[Dynamic Formula in Group Rows : Fresh (Aug 20) ocx version - h...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=52250&title=dynamic-formula-in-group-rows#52250 Author: mdoubson
Subject: 14968
Posted: 20 August 2009 at 1:01pm

Fresh (Aug 20) ocx version - https://forum.codejock.com/uploads/DemoVersion/ReportControlUpdated.rar

used resursive function for group row formula (means that your groups can be any level of deep).

Please try to make sample based on https://forum.codejock.com/uploads/20090813_220005_GroupFormula.rar

but wil more columns and data and try new ocx

]]> Thu, 20 Aug 2009 13:01:58 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=52250&title=dynamic-formula-in-group-rows#52250 <![CDATA[Dynamic Formula in Group Rows : Great Minds...I had implemented...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=52051&title=dynamic-formula-in-group-rows#52051 Author: joeliner
Subject: 14968
Posted: 17 August 2009 at 12:51am

Great Minds...

I had implemented a function that makes use of wndReportControl_GroupOrderChangedEx and based on the grouped columns the user can add or remove groups and auto-calculate the totals on the sub totals.

Am currently calculating the totals manually using GroupRow.Childs.Row(i).Record(r)Value and hoping to switch to the formula property.
]]> Mon, 17 Aug 2009 00:51:26 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=52051&title=dynamic-formula-in-group-rows#52051 <![CDATA[Dynamic Formula in Group Rows : Added Cascade Group Box Formula...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=52010&title=dynamic-formula-in-group-rows#52010 Author: mdoubson
Subject: 14968
Posted: 14 August 2009 at 8:43pm

Added Cascade Group Box Formula support - http://forum.codejock.com/forum_posts.asp?TID=14837&PN=1

e.g. SubTotal by internal SubTotals]]> Fri, 14 Aug 2009 20:43:02 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=52010&title=dynamic-formula-in-group-rows#52010 <![CDATA[Dynamic Formula in Group Rows : Build-In code you can see in VB...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=51967&title=dynamic-formula-in-group-rows#51967 Author: mdoubson
Subject: 14968
Posted: 14 August 2009 at 12:35am

Build-In code you can see in VB source - only for inital GroupOrder. If you drop Product column back to header - group row (and same time code) will destroyed.

But we can assign it on-fly - as our respond on GroupOrderChanged notification (for xtpReportColumnAddedToGroupby case)

Private Sub wndReport_GroupOrderChangedEx(ByVal Column As XtremeReportControl.IReportColumn, ByVal Reason As XtremeReportControl.XTPReportColumnOrderChangedReason)
    Dim i As Integer
    Dim row As ReportRow
    Dim groupRow As ReportGroupRow
    Dim xRecord As XtremeReportControl.ReportRecord
    Dim xRecordItem As XtremeReportControl.ReportRecordItem

    If Reason & xtpReportColumnAddedToGroupby Then
        For i = 0 To wndReport.Rows.Count - 1
            Set row = wndReport.Rows(i)
            If row.groupRow Then
                Set groupRow = row
                    groupRow.GroupFormat = " Subtotal $=%.02f"
                    groupRow.GroupFormula = "SUMSUB(R*C1:R*C8)"
                    groupRow.GroupCaption = "x"
            End If
        Next
    End If
End Sub

]]> Fri, 14 Aug 2009 00:35:44 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=51967&title=dynamic-formula-in-group-rows#51967 <![CDATA[Dynamic Formula in Group Rows : Nice! Funny thing - I was just...]]> http://forum.codejock.com/forum_posts.asp?TID=14968&PID=51965&title=dynamic-formula-in-group-rows#51965 Author: jpbro
Subject: 14968
Posted: 14 August 2009 at 12:05am

Nice! Funny thing - I was just wondering today if built-in group subtotals were possible!]]> Fri, 14 Aug 2009 00:05:17 +0000 http://forum.codejock.com/forum_posts.asp?TID=14968&PID=51965&title=dynamic-formula-in-group-rows#51965