Report Control - Working with hidden Column

Working with hidden Column

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=16989
Printed Date: 17 May 2024 at 12:19pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Working with hidden Column

Posted By: demiurge
Subject: Working with hidden Column
Date Posted: 22 July 2010 at 3:20am

Hello,

i have a little problem with the report control. I add several visible columns and one hidden column at the end. I don't use autsize function. The width of all columns is smaller then the width of the control. Here begins my Problem. Although the columns dont user the hole width, i get a horizontal scrollbar and when i size the last visible column to maximum width, i get a empty column.

How can i fix it in the matter, that there is no scroolbar and no empty column.

Thanks for your help.

-------------
Product: Xtreme Report Control ActiveX 2009 Vol 3 version 13.3.1

Platform: Windows XP (32bit) - SP 3

Language: MS Access 2003

Replies:

Posted By: Aaron
Date Posted: 23 July 2010 at 4:20pm

Hi,

Maybe I don't understand what you mean... But this will resize only last column to full width of RC

With wndReportControl

.AutoColumnSizing = True

For i = 0 To 5

        With .Columns
            With .Add(.Count, "Column " & i, 100, True)
                .AutoSize = False
            End With
        End With

        Next i

        Me.wndReportControl.Columns(5).AutoSize = True 'This will autosize only last column

End With

But if you resize RC smaller than total width of columns the scrollbar will appear. If you don't want scrollbars, you have to set AutoColumnSizing to True.

As I said before, maybe I don't understand what you mean, in that case just upload small demo and explain what you want.

-------------
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....

Posted By: demiurge
Date Posted: 24 July 2010 at 12:56pm

Hi,

thank you for your answer. Your example works fine. I will check it in my project at work on monday.

Have a nice weekend.

-------------
Product: Xtreme Report Control ActiveX 2009 Vol 3 version 13.3.1

Platform: Windows XP (32bit) - SP 3

Language: MS Access 2003

Posted By: demiurge
Date Posted: 30 July 2010 at 9:44am

Hi,

i have found my mistake. I have used the "FullColumnScrolling" property. After disabling this property everything was right.

Thanks for ypir help.

Regards

Demiurge

-------------
Product: Xtreme Report Control ActiveX 2009 Vol 3 version 13.3.1

Platform: Windows XP (32bit) - SP 3

Language: MS Access 2003