http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 27 May 2026 11:27:33 +0000 Sat, 13 Nov 2004 17:45:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=1380 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=1380&PID=3979&title=report-control-add-records-field-order#3979 Author: nighthawk
Subject: 1380
Posted: 13 November 2004 at 5:45pm

Unfortunately, it doesn't look like it is as simple as you say. It looks like the ReportRecordItem objects are added in the order ofthe columns ItemIndex value, not just in the order that the columns areadded.  I thought the ItemIndex value was just an arbitraryidentifier so I was using an enum with high values just to ensure allcolumns on all tables had a unique ID number.  That doesn't workbecause the ItemIndex must start at 0.  It took me a while tofigure this out.

For example, the following code will add the ReportRecordItems correctly as expected:

wndReportControl.Columns.Add(0, "Subject", 50, True)
wndReportControl.Columns.Add(1, "From", 50, True)
wndReportControl.Columns.Add(2, "Date", 50, True)
wndReportControl.Columns.Add(3, "Size", 50, True)
Record.Add Item "RE: Your Invoice"
Record.Add Item "John Smith"
Record.Add Item "19/06/2004"
Record.Add Item "18k"


But the following also looks like it will add the ReportRecordItemscorrectly even the the columns are added in reverse order since theirItemIndex value didn't change:

wndReportControl.Columns.Add(3, "Size", 50, True)
wndReportControl.Columns.Add(2, "Date", 50, True)
wndReportControl.Columns.Add(1, "From", 50, True)
wndReportControl.Columns.Add(0, "Subject", 50, True)
Record.Add Item "RE: Your Invoice"
Record.Add Item "John Smith"
Record.Add Item "19/06/2004"
Record.Add Item "18k"
]]> Sat, 13 Nov 2004 17:45:49 +0000 http://forum.codejock.com/forum_posts.asp?TID=1380&PID=3979&title=report-control-add-records-field-order#3979 http://forum.codejock.com/forum_posts.asp?TID=1380&PID=3895&title=report-control-add-records-field-order#3895 Author: SuperMario
Subject: 1380
Posted: 08 November 2004 at 9:06am

It doesn't matter how much the user move the columns or hides\removescolumns.  You just need to make sure that you add the items in theexact same order that the columns were added (regardless of the currentcolumn arrangement).  You need to also account for the columnsthat are not currently visible.  So as long as you add items inthe same order that they you added the columns and add information forall of the item, you should never have any problems.]]> Mon, 08 Nov 2004 09:06:59 +0000 http://forum.codejock.com/forum_posts.asp?TID=1380&PID=3895&title=report-control-add-records-field-order#3895 http://forum.codejock.com/forum_posts.asp?TID=1380&PID=3885&title=report-control-add-records-field-order#3885 Author: nighthawk
Subject: 1380
Posted: 07 November 2004 at 1:01pm

I am looking over the sample code for adding records to the reportcontrol.  Adding the individual  ReportRecordItem objects tothe row doesn't appear to be able to take into account a usercustomized column order.  For example:

        Record.Add Item "RE: Your Invoice"
        Record.Add Item "John Smith"
        Record.Add Item "19/06/2004"
        Record.Add Item "18k"

This code adds the fields in the order it is executed in code but ifthe user switches the order of two of the colums, future records willnot be added correctly.  Is there any way to add theReportRecordItem objects idependantly of the column order? Something like: "Record.AddItem (Value, ColumnID)" would be nice.]]> Sun, 07 Nov 2004 13:01:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=1380&PID=3885&title=report-control-add-records-field-order#3885