Codejock Developer Community : Report with Formulas

Codejock Developer Community : Report with Formulas http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 06:42:10 +0000 Tue, 05 Oct 2010 16:32:08 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=13976 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Report with Formulas : You can just put the item count...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=60713&title=report-with-formulas#60713 Author: RJAMIN
Subject: 13976
Posted: 05 October 2010 at 4:32pm

You can just put the item count in the caption. Example:

Private Sub wndReportControl_GroupOrderChangedEx(ByVal sender As Object, ByVal e As AxXtremeReportControl._DReportControlEvents_GroupOrderChangedExEvent) Handles wndReportControl.GroupOrderChangedEx
    Dim row As Integer
    Dim sumSub As String
    Dim groupRow As XtremeReportControl.ReportGroupRow

    If ((e.reason And XTPReportColumnOrderChangedReason.xtpReportColumnAddedToGroupby) = XTPReportColumnOrderChangedReason.xtpReportColumnAddedToGroupby) Or _
       ((e.reason And XTPReportColumnOrderChangedReason.xtpReportColumnRemovedFromGroupby) = XTPReportColumnOrderChangedReason.xtpReportColumnRemovedFromGroupby) Then
        sumSub = "SUMSUB(C6:C7)"
        For row = 0 To (wndReportControl.Rows.Count - 1)
            If (wndReportControl.Rows(row).GroupRow) Then
                groupRow = wndReportControl.Rows(row)
                groupRow.GroupFormula = sumSub
                groupRow.GroupFormat = "%0.2f"
                groupRow.GroupCaption = (" (" + groupRow.Childs().Count.ToString() + " items)")
            End If
        Next
    End If
End Sub

]]> Tue, 05 Oct 2010 16:32:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=60713&title=report-with-formulas#60713 <![CDATA[Report with Formulas : Hi Can somebody help me to display...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=60193&title=report-with-formulas#60193 Author: Ajit
Subject: 13976
Posted: 14 September 2010 at 1:07pm

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.

]]> Tue, 14 Sep 2010 13:07:04 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=60193&title=report-with-formulas#60193 <![CDATA[Report with Formulas : ''Espero que les...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=60025&title=report-with-formulas#60025 Author: jequita2009
Subject: 13976
Posted: 02 September 2010 at 1:50pm

''Espero que les sirva
''Esto es en caso no se sabe que columna es num�rica o no.
''I hope you learn
''This is in case you do not know which column is numeric or not.

Private Sub RC_GroupOrderChangedEx(ByVal Column As XtremeReportControl.IReportColumn, ByVal Reason As XtremeReportControl.XTPReportColumnOrderChangedReason)
    Dim i As Integer
    Dim j As Integer

    Dim Row As ReportRow
    Dim groupRow As ReportGroupRow
    Dim xRecord As XtremeReportControl.ReportRecord
    Dim xRecordItem As XtremeReportControl.ReportRecordItem

    Dim CadenaSumSub As String
    CadenaSumSub = SumSub

    If Reason & xtpReportColumnAddedToGroupby Then

        For j = 0 To RC.Columns.Count - 1
            If RC.Columns(j).Tag = "N" Then   ''If numeric
                For i = 0 To RC.Rows.Count - 1
                    Set Row = RC.Rows(i)
                    If Row.groupRow Then
                        Set groupRow = Row
                            'sumSub = "SUMSUB(C" & j + 1 & ":C" & j + 1 + 1 & ")"
                            groupRow.GroupFormat = " Subtotal =%.02f"
                            groupRow.GroupFormula = CadenaSumSub
                            groupRow.GroupCaption = "x"

                    End If
                Next
            End If
        Next

    End If

End Sub
]]> Thu, 02 Sep 2010 13:50:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=60025&title=report-with-formulas#60025 <![CDATA[Report with Formulas : ''establishing the...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=60024&title=report-with-formulas#60024 Author: jequita2009
Subject: 13976
Posted: 02 September 2010 at 1:49pm

''establishing the following function to generate a string:

Private Function SumSub() As String
    Dim SumSubf As String
    Dim cadena As String
    cadena = " "

    For x = 0 To RC.Columns.Count - 1
        RC.Columns(x).Tag = G_Header(1, x)
        If RC.Columns(x).Tag = "N" Then
           SumSubf = "SUMSUB(C" & x & ":C" & x + 1 & ")"
           cadena = cadena + SumSubf
        End If
    Next

    SumSub = cadena

End Function

]]> Thu, 02 Sep 2010 13:49:05 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=60024&title=report-with-formulas#60024 <![CDATA[Report with Formulas : I finally discovered CXTPReportColumn::SetTreeColumn() ...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=58874&title=report-with-formulas#58874 Author: davidbeane
Subject: 13976
Posted: 09 June 2010 at 2:12pm

I finally discovered CXTPReportColumn::SetTreeColumn()
]]> Wed, 09 Jun 2010 14:12:28 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=58874&title=report-with-formulas#58874 <![CDATA[Report with Formulas : Could you possibly give a sample...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=58846&title=report-with-formulas#58846 Author: davidbeane
Subject: 13976
Posted: 08 June 2010 at 4:09pm

Could you possibly give a sample of the code used to insert the records into the control as in the screenshot displayed?
(The original screenshot in the first post)

Not the formulas, just how to insert the grouped rows.

I cannot figure out how to insert data in a hierarchical format like that.]]> Tue, 08 Jun 2010 16:09:21 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=58846&title=report-with-formulas#58846 <![CDATA[Report with Formulas : Hi Is it possible to print grouprow...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=56745&title=report-with-formulas#56745 Author: blackeagle
Subject: 13976
Posted: 11 February 2010 at 12:48pm

Hi

Is it possible to print grouprow item's count with formula at group caption?

]]> Thu, 11 Feb 2010 12:48:57 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=56745&title=report-with-formulas#56745 <![CDATA[Report with Formulas : Though this is a nice add-on,...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=56023&title=report-with-formulas#56023 Author: znakeeye
Subject: 13976
Posted: 06 January 2010 at 8:18pm

Though this is a nice add-on, I still think this kind of functionality belongs in a separate Grid-control. You will most likely end up having to refactor this code later on... :(]]> Wed, 06 Jan 2010 20:18:56 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=56023&title=report-with-formulas#56023 <![CDATA[Report with Formulas : Looks pretty interesting and useful....]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=56000&title=report-with-formulas#56000 Author: Algae
Subject: 13976
Posted: 05 January 2010 at 9:12pm

Looks pretty interesting and useful. If there was a group "footer" totals could display on the end of group line so you could do sub-reports.

something like:

Group Header
-------
Item 1,1 Item 1,2    Item 1.3
Item 2.1 Item 2.2    Item 2.3
.... etc
______
Group Footer Total         Total
]]> Tue, 05 Jan 2010 21:12:12 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=56000&title=report-with-formulas#56000 <![CDATA[Report with Formulas : see snapshot of new feature -...]]> http://forum.codejock.com/forum_posts.asp?TID=13976&PID=55974&title=report-with-formulas#55974 Author: mdoubson
Subject: 13976
Posted: 04 January 2010 at 3:56pm

see snapshot of new feature - https://support.codejock.com/Attachments/20091228-140707_GroupRowsWithMultipleSubtotals.jpg]]> Mon, 04 Jan 2010 15:56:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=13976&PID=55974&title=report-with-formulas#55974