Codejock Developer Community : Transposed Grouping

Codejock Developer Community : Transposed Grouping http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 09:45:11 +0000 Wed, 19 Aug 2009 09:10:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=14876 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Transposed Grouping : Ok - get it ]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52197&title=transposed-grouping#52197 Author: mdoubson
Subject: 14876
Posted: 19 August 2009 at 9:10am

Ok - get it]]> Wed, 19 Aug 2009 09:10:37 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52197&title=transposed-grouping#52197 <![CDATA[Transposed Grouping : It works. Thank you. Is it possible,...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52194&title=transposed-grouping#52194 Author: mlatona
Subject: 14876
Posted: 19 August 2009 at 9:03am

It works. Thank you. Is it possible, that you add a unicode version in your rar file?]]> Wed, 19 Aug 2009 09:03:29 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52194&title=transposed-grouping#52194 <![CDATA[Transposed Grouping : Right - fixed - please try now...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52190&title=transposed-grouping#52190 Author: mdoubson
Subject: 14876
Posted: 19 August 2009 at 8:44am

Right - fixed - please try now - https://forum.codejock.com/uploads/DemoVersion/ReportControlUpdated.rar ]]> Wed, 19 Aug 2009 08:44:07 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52190&title=transposed-grouping#52190 <![CDATA[Transposed Grouping : Try this code and it works not...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52187&title=transposed-grouping#52187 Author: mlatona
Subject: 14876
Posted: 19 August 2009 at 8:17am

Try this code and it works not correct.

With Me.ReportControl1
      .ShowGroupBox = True
      With .Columns.Add(.Columns.Count, "Col1", 100, True)
         .PlusMinus = True
         .NextVisualBlock = 2
      End With
      With .Columns.Add(.Columns.Count, "Col2", 100, True)
      End With
      With .Columns.Add(.Columns.Count, "Col3", 100, True)
      End With
      With .Columns.Add(.Columns.Count, "Col4", 100, True)
         .PlusMinus = True
         .NextVisualBlock = -3
      End With

      With .Records.Add
         .AddItem "A"
         .AddItem "B"
         .AddItem "C"
      End With

      .Populate
      .PaintManager.ColumnPlusMinusSign = True
   End With

]]> Wed, 19 Aug 2009 08:17:37 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52187&title=transposed-grouping#52187 <![CDATA[Transposed Grouping : Yes, it works, but column 'Jan'...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52186&title=transposed-grouping#52186 Author: mlatona
Subject: 14876
Posted: 19 August 2009 at 8:14am

Yes, it works, but column 'Jan' is visible when you collapse the column 'Q1' and this is not correct.]]> Wed, 19 Aug 2009 08:14:23 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52186&title=transposed-grouping#52186 <![CDATA[Transposed Grouping : If I modify your sample like this...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52185&title=transposed-grouping#52185 Author: mdoubson
Subject: 14876
Posted: 19 August 2009 at 7:56am

If I modify your sample like this - easy to see

Private Sub Form_Load()

With ReportControl1
.Columns.Add 0, "Jan", 50, False
.Columns.Add 1, "Feb", 50, False
.Columns.Add 2, "Mar", 50, False

With .Columns.Add(3, "Q1", 50, False)
    .PlusMinus = True
    .NextVisualBlock = -2
End With

.Columns.Add 4, "Apr", 50, False
.Columns.Add 5, "May", 50, False
.Columns.Add 6, "Jun", 50, False
With .Columns.Add(7, "Q2", 50, False)
    .PlusMinus = True
    .NextVisualBlock = -2
End With
.PaintManager.ColumnPlusMinusSign = True
.Populate
End With

End Sub

it works. Will check deep

]]> Wed, 19 Aug 2009 07:56:34 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52185&title=transposed-grouping#52185 <![CDATA[Transposed Grouping : Thanks Try this simple code...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52183&title=transposed-grouping#52183 Author: mdoubson
Subject: 14876
Posted: 19 August 2009 at 7:39am

Thanks

Try this simple code please

Private Sub Form_Load()

   With Me.ReportControl1
      .ShowGroupBox = True
      With .Columns.Add(.Columns.Count, "Col1", 100, True)
         .PlusMinus = True
         .NextVisualBlock = 2
      End With
      With .Columns.Add(.Columns.Count, "Col2", 100, True)
      End With
      With .Columns.Add(.Columns.Count, "Col3", 100, True)
         .PlusMinus = True
         .NextVisualBlock = -2
      End With

      With .Records.Add
         .AddItem "A"
         .AddItem "B"
         .AddItem "C"
      End With

      .Populate
      .PaintManager.ColumnPlusMinusSign = True
   End With

]]> Wed, 19 Aug 2009 07:39:31 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52183&title=transposed-grouping#52183 <![CDATA[Transposed Grouping : Hi, here is a sample. Collapse...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52182&title=transposed-grouping#52182 Author: mlatona
Subject: 14876
Posted: 19 August 2009 at 7:38am

Hi, here is a sample. Collapse column 'Q1'. Column 'Jan', 'Feb' and 'May' are hidden. Exand column 'Q1'. Only column 'Jan' and 'Feb' are visible.uploads/20090819_073816_PlusMinusSample.zip]]> Wed, 19 Aug 2009 07:38:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52182&title=transposed-grouping#52182 <![CDATA[Transposed Grouping : Are you sure that in the moment...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52178&title=transposed-grouping#52178 Author: mdoubson
Subject: 14876
Posted: 19 August 2009 at 7:28am

Are you sure that in the moment you set column#5 - PlusMinus and NextVisualBlock = -2 you already have visible column#4 and column#3?]]> Wed, 19 Aug 2009 07:28:45 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52178&title=transposed-grouping#52178 <![CDATA[Transposed Grouping : Hi Mark, the report control...]]> http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52176&title=transposed-grouping#52176 Author: mlatona
Subject: 14876
Posted: 19 August 2009 at 7:20am

Hi Mark,

the report control don`t work correct when I use a negative settings. Not all columns are visible, when I expand the plus minus column.

Regards

Marco

]]> Wed, 19 Aug 2009 07:20:29 +0000 http://forum.codejock.com/forum_posts.asp?TID=14876&PID=52176&title=transposed-grouping#52176