Alpha Video Training
Results 1 to 2 of 2

Thread: Help in filtering data

  1. #1
    Member
    Real Name
    Dave Londal
    Join Date
    Nov 2007
    Posts
    1

    Default Help in filtering data

    I am having difficulty in getting my report to filer out certain invoice line items. In particular those listed as "Payment", "Deposit", or Blank

    I have tried following the online video tutorial, but obviously miss something.

    I have attached screen shots showing my Set w/ Filter, my Report Design and then the result. You will notice that a line with "Payment" shows on the fourth line of the report.

    I am a novice at report writing so any help is appreciated.

    Thanks

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,625

    Default Re: Help in filtering data

    Dave

    Thanks for writing. From what I can see, you are using the filtering in the set definition to eliminate records. It's a little hard to see the actual filter that you are using since the image is too small.

    Another option that I may be more likely to use, is to skip the filtering on the set and put it in the report record selection area.

    Can you export the report and post it here or send it to me? I can take a look at it and perhaps change the filtering to work for you.

    If there is an issue with privacy, please email it to me directly. alb@bookwood.com
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Filtering
    By RobPolley in forum Application Server Version 8
    Replies: 3
    Last Post: 05-22-2007, 09:45 PM
  2. Filtering
    By wetham in forum Alpha Five Version 7
    Replies: 4
    Last Post: 01-31-2007, 09:36 AM
  3. Filtering data by date with a set.
    By Rodney Efird in forum Alpha Five Version 4
    Replies: 6
    Last Post: 08-01-2000, 04:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •