Codejock Developer Community : Removing Row

Codejock Developer Community : Removing Row http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 16 Apr 2026 23:24:22 +0000 Sat, 03 May 2008 14:22:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=10440 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Removing Row : Hi, Glad I could help you,...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34611&title=removing-row#34611 Author: Aaron
Subject: 10440
Posted: 03 May 2008 at 2:22pm

Hi,

Glad I could help you, thats why we are here, right

Did you check the sample project I posted? I guess you want the same as I showed in the sample. Just showing those records which the user selects.

]]> Sat, 03 May 2008 14:22:16 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34611&title=removing-row#34611 <![CDATA[Removing Row : thank you Aaron for all your help,...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34610&title=removing-row#34610 Author: cmm2006
Subject: 10440
Posted: 03 May 2008 at 2:09pm

thank you Aaron for all your help, make row visible/invisible did the job.

]]> Sat, 03 May 2008 14:09:23 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34610&title=removing-row#34610 <![CDATA[Removing Row : joeliner wrote: i think...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34605&title=removing-row#34605 Author: Aaron
Subject: 10440
Posted: 03 May 2008 at 1:07pm

joeliner wrote:

i think cmm2006 is referring to filtering the records where in essence the records are hidden. filtertext would be the way to go then.

regards,

Joeliner, FilterText will filter entire ReportControl's records and not just one column. With my snippet you can filter a column you want.

]]> Sat, 03 May 2008 13:07:18 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34605&title=removing-row#34605 <![CDATA[Removing Row : cmm2006 wrote:No, I am not...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34581&title=removing-row#34581 Author: Aaron
Subject: 10440
Posted: 02 May 2008 at 4:02pm

cmm2006 wrote:

No, I am not looking to sort the report.

okay how can remove row from reportcontrol?

thank you

It's not sorting records in a way you think (look at the quotes, "sort"), It's more filtering the ReportControl's records and show the result to the user.

Do you want to "remove" a row (make invisible) or remove the record? You have to be more clear when asking a question and sometimes it helps when you would upload a screenshot. Now...

Make row invisible without removing the actual record:

wndReportControl.Rows(wndReportControl.FocusedRow.Index).record.Visible = False

wndReportControl.Populate

wndReportControl.Records(wndReportControl.FocusedRow.Index).Visible = False

wndReportControl.Populate

Remove the record from the ReportControl:

wndReportControl.Records.RemoveAt wndReportControl.FocusedRow.Index

wndReportControl.Populate

I have used the current selected record in the lines of code (above)

If you are going to make the record/row invisible you have to keep track of the rows which are invisible or just loop through the records and make them all visible. I don't have a clue what you are trying to accomplish, it looked like you wanted just those records to show, the user selected but you don't want that.

But maybe you can take a closer look at the sample project:

http://forum.codejock.com/forum_posts.asp?TID=10180

]]> Fri, 02 May 2008 16:02:24 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34581&title=removing-row#34581 <![CDATA[Removing Row : cmm2006 wrote:No, I am not...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34572&title=removing-row#34572 Author: joeliner
Subject: 10440
Posted: 02 May 2008 at 1:07pm

cmm2006 wrote:

No, I am not looking to sort the report.

okay how can remove row from reportcontrol?

i think cmm2006 is referring to filtering the records where in essence the records are hidden. filtertext would be the way to go then.

http://forum.codejock.com/forum_posts.asp?TID=10180

BTW, thanks Aaron for posting ths snippet. was really helpful. :) Am trying to work on the RC subtotal. http://forum.codejock.com/forum_posts.asp?TID=9801. i dont mind sharing it if am successful.

regards,
]]> Fri, 02 May 2008 13:07:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34572&title=removing-row#34572 <![CDATA[Removing Row : No, I am not looking to sort the...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34564&title=removing-row#34564 Author: cmm2006
Subject: 10440
Posted: 02 May 2008 at 11:44am

No, I am not looking to sort the report.

okay how can remove row from reportcontrol?

thank you

]]> Fri, 02 May 2008 11:44:29 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34564&title=removing-row#34564 <![CDATA[Removing Row : Hi, So you really want to...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34560&title=removing-row#34560 Author: Aaron
Subject: 10440
Posted: 02 May 2008 at 8:49am

Hi,

So you really want to "sort" the items which match the selected combo text? If you want to sort the records on selected combo text you can traverse the records and set the found recorditem (row) to visible

Private Function SortSelectedComboText()
    Dim record As ReportRecord

    For Each record In wndReportControl.Records
        record.Visible = True 'make previous sort undone when row was set to invisible
        If Not UCase(record(the index of the column to search comes here).Value) Like "*" & UCase(Combo.Text) & "*" Then 'compare value the RecordItem of record with combo selected text
            record.Visible = False
        End If
    Next record

    wndReportControl.Populate 'show the found records

End Function

Note: The * in the line "*" & UCase(Combo.Text) & "*" will be used for any character before / after the selected combo text. If you want to search exact, just use Combo.Text

Hope this will help.

]]> Fri, 02 May 2008 08:49:53 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34560&title=removing-row#34560 <![CDATA[Removing Row : ok, I have a report control with...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34554&title=removing-row#34554 Author: cmm2006
Subject: 10440
Posted: 02 May 2008 at 7:28am

ok, I have a report control with 6 columns, and records are loaded to the reportcontrol. now I have a combobox where the user can select what they to show only in reportcontrol.

for example the 5 column of the report control containt the state of residence, and the combobox contain all the 50 states, now if the user select 'FL' from the combobox, all I want to be displayed in the reportcontrol is the customer who reside 'FL' state.

CJ12

]]> Fri, 02 May 2008 07:28:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34554&title=removing-row#34554 <![CDATA[Removing Row : Hi, Your question isn't...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34551&title=removing-row#34551 Author: Aaron
Subject: 10440
Posted: 02 May 2008 at 5:19am

Hi,

Your question isn't very clear to me. You want to remove a record from the Reportcontrol, that part I did understand.

* Is it the focused/selected record or a reference/index of the record selected with the combobox?

* You want all the records that their value are not = to item(5) of the report control??? This part I really don't understand.

* And what version do you use?

Explain what you really want, with text, screenshot or whatever

]]> Fri, 02 May 2008 05:19:51 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34551&title=removing-row#34551 <![CDATA[Removing Row : Ok I know it's easy to do,...]]> http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34539&title=removing-row#34539 Author: cmm2006
Subject: 10440
Posted: 01 May 2008 at 6:02pm

Ok I know it's easy to do, but for some reason, I was unable to get it done. the report control contain all the records of a table, and I need to know how to remove some rows from the report base on the selection of the user (selection is made from a combobox).

I want all the records that their value are not = to item(5) of the report control.

please help

]]> Thu, 01 May 2008 18:02:41 +0000 http://forum.codejock.com/forum_posts.asp?TID=10440&PID=34539&title=removing-row#34539