Codejock Developer Community : Formating Sum Result in group formula http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 05:35:41 +0000 Thu, 27 May 2010 21:21:56 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=16747 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Formating Sum Result in group formula : I find temporaly solution, i make...]]> http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58706&title=formating-sum-result-in-group-formula#58706 Author: Zeus
Subject: 16747
Posted: 27 May 2010 at 9:21pm

I find temporaly solution,  i make a matrix totalized and i add the total by grup with vb format, then i add to de gruopcaption the total with the format that i want :) tks i have a picture to show but i dont know how to upload the image. meaby some one need same function

Private Sub GrdInstancias_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 GrdInstancias.Rows.Count - 1
            Set Row = GrdInstancias.Rows(i)
            If Row.groupRow Then
               
                Set groupRow = Row
                    ProveedorBus = Trim(Mid(groupRow.GroupCaption, 8, 100))
                    For M = 1 To 20
                        If ProveedorBus = Trim(TotalesxProveedor(M, 1)) Then
                            TotalProveedor = Format(TotalesxProveedor(M, 2), "#,###")
                            
                        End If
                    Next M
 
                   
                    groupRow.GroupCaption = groupRow.GroupCaption & "  Gs  " & Trim(TotalProveedor)
            End If
        Next
    End If

End Sub
]]> Thu, 27 May 2010 21:21:56 +0000 http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58706&title=formating-sum-result-in-group-formula#58706 <![CDATA[Formating Sum Result in group formula : thanks Aaron i will write to support ...]]> http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58686&title=formating-sum-result-in-group-formula#58686 Author: Zeus
Subject: 16747
Posted: 26 May 2010 at 3:09pm

thanks Aaron i will write to support]]> Wed, 26 May 2010 15:09:16 +0000 http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58686&title=formating-sum-result-in-group-formula#58686 <![CDATA[Formating Sum Result in group formula : Hi, I don&#039;t see a way...]]> http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58680&title=formating-sum-result-in-group-formula#58680 Author: Aaron
Subject: 16747
Posted: 26 May 2010 at 10:22am

Hi,
 
I don't see a way to get the thousands separator into a GroupFormat with last version so the only option is to submit a request and hope CodeJock will add this in next release. Just write to support http://www.codejock.com/support/ and ask if they are going to implement this in next version. Or use IssueTracker https://support.codejock.com/ 
 
You have my vote on this
 
]]> Wed, 26 May 2010 10:22:35 +0000 http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58680&title=formating-sum-result-in-group-formula#58680 <![CDATA[Formating Sum Result in group formula : hi Aaron tks for the reply how...]]> http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58670&title=formating-sum-result-in-group-formula#58670 Author: Zeus
Subject: 16747
Posted: 25 May 2010 at 6:42pm

hi Aaron tks for the reply how i do that? i confussed]]> Tue, 25 May 2010 18:42:29 +0000 http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58670&title=formating-sum-result-in-group-formula#58670 <![CDATA[Formating Sum Result in group formula : Hi, Would be better if Regional...]]> http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58668&title=formating-sum-result-in-group-formula#58668 Author: Aaron
Subject: 16747
Posted: 25 May 2010 at 3:59pm

Hi,
 
Would be better if Regional settings would control the GroupFormat, looks like you get stuck without thousands separator but maybe CJ will fix this in next release
 
]]> Tue, 25 May 2010 15:59:24 +0000 http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58668&title=formating-sum-result-in-group-formula#58668 <![CDATA[Formating Sum Result in group formula : I used the nex code in a groupformula...]]> http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58652&title=formating-sum-result-in-group-formula#58652 Author: Zeus
Subject: 16747
Posted: 24 May 2010 at 4:28pm

I used the nex code in a groupformula :

Private Sub GrdInstancias_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 GrdInstancias.Rows.Count - 1
            Set Row = GrdInstancias.Rows(i)
            If Row.groupRow Then
                Set groupRow = Row
                   
                    groupRow.GroupFormat = " Subtotal Gs. " & "%0f"
                    groupRow.GroupFormula = "SUMSUB(R*C8:R*C9)"
                    groupRow.GroupCaption = "x"
            End If
        Next
    End If

End Sub

These code work perfect but mi problem is that i need the result in this format 1.000.598 with thousen separator
how can i do that? i read all the documentation for the report control but i dont find a solve
any help will be apreciated
Tks


]]> Mon, 24 May 2010 16:28:07 +0000 http://forum.codejock.com/forum_posts.asp?TID=16747&PID=58652&title=formating-sum-result-in-group-formula#58652