Re: Skipping detail lines in a report

Tech-Archive recommends: Speed Up your PC by fixing your registry

I'll try & clarify.

I have a table with entries in it like: "hotfix", "visio", "update" and the
like. There are more, but you get the idea. The user may add new text, delete
existing entries, or change the wording in an entry.

I load these values into an array at startup. At report-time, I examine the
text in a single field (column to the young guys ;^) ). If the filter text is
anywhere in the column, that detail record must be skipped. For example:

filter-text: "hotfix"

Detail text: "Microsoft windows hotfix A476586"

Since the detail line (column) contains the filter word, that line is not
shown on the report. I spin through the entire array of filter-words (it's in
a memory array) for each line. I'm not sure how to do it more efficiently,
but the report is quite small, with only about 60 entries max per key.

"Duane Hookom" wrote:

> I think you can do this with SQL. Can you explain "ANY PART of the
> detail-line's text" and "detail field"? Are you search for your filter words
> in more than one field in the report's record source?
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "Dennis" <Dennis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:ECA96106-3048-4314-AC1E-9C5387404079@xxxxxxxxxxxxxxxx
> > Okay, it's like this:
> >
> > I have a table in which resides a series of "filter words". It the filter
> > word is in ANY PART of the detail-line's text, that detail line must be
> > skipped. The user can add/remove/edit these filter words at any time, so
> > coding a query isn't feasible (I think). I could have 10 of these, or 100.
> > So
> > I pass each detail line through a code fragment that checks the array of
> > filter words (which I load at the start of the application). If any of
> > that
> > text is within the detail field, I skip the line.
> >
> > Hope that helps.
> >
> >
> >
> > "Duane Hookom" wrote:
> >
> >> Why does your record source contain the records that you don't want to
> >> show?
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >>
> >> "Dennis" <Dennis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:C1A2C733-E1ED-432A-BA67-45E0DCDB17B2@xxxxxxxxxxxxxxxx
> >> > Hi! Running Access 2002.
> >> >
> >> > I've designed a report (actually, it's a parent with two side-by-side
> >> > sub-reports). The sub-report on the right has detail code behind it, in
> >> > order
> >> > to NOT display detail lines which match certain criteria. That line is
> >> > set
> >> > to
> >> > "Detail.Visible = False"
> >> >
> >> > The problem is that vertical space is reserved for the missing
> >> > (invisible)
> >> > lines, thus creating a BLANK page 2. What I need to do is ignore the
> >> > specified lines completely, and not reserve space at all. That will
> >> > give
> >> > me
> >> > the one-page report I need.
> >> >
> >> > How can I do this please?
> >> >
> >> > TIA!
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Setting up a variable array based on form input
    ... What I need to build is an Internal Rate of Return (IRR) into this ... Static ValuesAs Double 'Array of values ... automatically based on the loan term selected on the form. ... Static Entries As Integer ...
    (comp.databases.ms-access)
  • Re: Client-side search engine capable of indexing .pdf files is needed.
    ... simple array) I suppose that most of the job is made. ... The index lookup needs to be fast, ... only 1500 entries, which isn't even close to what we're dealing here. ... encoding doesn't match the search encoding. ...
    (comp.lang.javascript)
  • Re: Non-Scrolling Background inside CScrollView
    ... Now i will create an array containing the complete output (all buttons, ... entries and entry separators). ... When scrolling i just display the "visible" entries from the array in ... the distance from top to the corrosponding entry. ...
    (microsoft.public.vc.mfc)
  • Re: Array and resize
    ... For obvious reasons, we want the created table to have a header, ... option instead of placing the array directly into a 4x8 range. ... I wanted to use/test the resize option, since the entries from the FE ...
    (microsoft.public.excel.programming)
  • Re: Constant time insertion into a sorted list?
    ... I tried a straight-forward priority queue implemented with an array. ... As soon as you allocate an array, the maximum number of entries is ... fixed by the size of the array, hence regardless of what algorithm ... To make insertion constant with the method you ...
    (comp.programming)