Codejock Developer Community : Grouprow SUMSUB and alignment of sumsub

Codejock Developer Community : Grouprow SUMSUB and alignment of sumsub http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 22:30:30 +0000 Mon, 04 Oct 2010 14:19:26 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=17265 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Grouprow SUMSUB and alignment of sumsub : Hi, I'm sorry but I didn't...]]> http://forum.codejock.com/forum_posts.asp?TID=17265&PID=60681&title=grouprow-sumsub-and-alignment-of-sumsub#60681 Author: Aaron
Subject: 17265
Posted: 04 October 2010 at 2:19pm

Hi,

I'm sorry but I didn't see your reply

I tried with CodeJock sample and I'm able to set .Alignment & .HeaderAlignment afterwards (DataBinding sample) and I tried with my own code and (sub)totals use these settings...

Is it possible to upload small test project?

]]> Mon, 04 Oct 2010 14:19:26 +0000 http://forum.codejock.com/forum_posts.asp?TID=17265&PID=60681&title=grouprow-sumsub-and-alignment-of-sumsub#60681 <![CDATA[Grouprow SUMSUB and alignment of sumsub : Thanks for always replying Aaron....]]> http://forum.codejock.com/forum_posts.asp?TID=17265&PID=60344&title=grouprow-sumsub-and-alignment-of-sumsub#60344 Author: CapoPezzio
Subject: 17265
Posted: 21 September 2010 at 4:43am

Thanks for always replying Aaron Smile

. I do set the .Headeralignment and .Alignment same.
I am using databind.
wndReportControl.Datasouce = myDataSet
wndReportControl.Databind

Then I go through the columns and set the Alignment

For Each c In wndReportControl.Columns
            c.Alignment = theAlignment_I_want 'xtpAlignmentCenter, xtpAlignmentRight or xtpAlignmentLeft
            c.HeaderAlignment = c.Alignment
            c.FooterAlignment = c.Alignment

Next

Any other idea?
]]> Tue, 21 Sep 2010 04:43:21 +0000 http://forum.codejock.com/forum_posts.asp?TID=17265&PID=60344&title=grouprow-sumsub-and-alignment-of-sumsub#60344 <![CDATA[Grouprow SUMSUB and alignment of sumsub : Hi, Did you set .HeaderAlignment...]]> http://forum.codejock.com/forum_posts.asp?TID=17265&PID=60342&title=grouprow-sumsub-and-alignment-of-sumsub#60342 Author: Aaron
Subject: 17265
Posted: 21 September 2010 at 4:21am

Hi,

Did you set .HeaderAlignment and .Alignment same?

With Me.wndReportControl
        With .Columns
            With .Add(.Count, "Col 1", 100, True)
                .HeaderAlignment = xtpAlignmentRight
                .Alignment = xtpAlignmentRight
            End With

End With

Hope this helps

]]> Tue, 21 Sep 2010 04:21:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=17265&PID=60342&title=grouprow-sumsub-and-alignment-of-sumsub#60342 <![CDATA[Grouprow SUMSUB and alignment of sumsub : Hi.I have a reportcontrol wich...]]> http://forum.codejock.com/forum_posts.asp?TID=17265&PID=60263&title=grouprow-sumsub-and-alignment-of-sumsub#60263 Author: CapoPezzio
Subject: 17265
Posted: 17 September 2010 at 8:54am

Hi.

I have a reportcontrol wich I use SUMSUB to show groupsums when I am grouping on a column. This works fine, but the alignment of the groupsum does not follow the allignment of the columns i use Sumsub on

Here is my sumsub code:

Private Sub RC_GroupOrderChangedEx(ByVal Column As XtremeReportControl.IReportColumn, ByVal Reason As XtremeReportControl.XTPReportColumnOrderChangedReason)

    If Reason & xtpReportColumnAddedToGroupby Then
        For i = 0 To RC.Rows.Count - 1
            Set Row = RC.Rows(i)
            If Row.groupRow Then
                Set groupRow = Row
                    groupRow.GroupFormat = "%.02f"
                    tformel = ""
                    For j = 1 To m_sums.Rows
                        tformel = tformel & " SUMSUB(C" & m_sums.value(3, j) - 1 & ":C" & m_sums.value(3, j) & ")"
                    Next
                    groupRow.GroupFormula = Trim(tformel)
                    'groupRow.GroupFormula = "SUMSUB(C2:C3) SUMSUB(C3:C4)"
                    groupRow.GroupCaption = "x"
            End If
        Next
        RC.ReCalc True
        RC.ReDraw
    End If
End Sub

Anyone got an idea how I can right-align the sums in the grouping-row?

]]> Fri, 17 Sep 2010 08:54:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=17265&PID=60263&title=grouprow-sumsub-and-alignment-of-sumsub#60263