Alpha DevCon 2018
Results 1 to 2 of 2

Thread: Report filter syntax

  1. #1
    Real Name
    John Cunradi
    Join Date
    Aug 2000

    Default Report filter syntax

    I have a report that works fine when all records are set to print.
    But, I would like to select the records to print by an ask variable.
    I want the report to print only records in the Area I specify in the ask variable and
    I only want records printed that are unique to the Area that I specified.

    I have this so far: .NOT.(Section->Section_Area > var->askC_Show_Unique_SKUs_For_What_Area)
    It asks for for the Area I want in the report but shows all areas regardless of the Area specified.
    Note: the .NOT. was required to get any records to show in the report...I have no idea why that's so.

    For example:

    If I enter Stockroom for the ask variable, the only record that should show would be for SKU 5678.
    That is because SKU 1234 is also included in a Salesfloor record.

    Any help with the syntax would be greatly appreciated.

    Thanks in advance.

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Bowling Green, KY

    Default Re: Report filter syntax

    If you had an index, sku_test, on the sku field you could do something like

    area = var->askC_Show_Unique_SKUs_For_What_Area .and. dbcount("section","sku_test",sku) = 1
    There can be only one.

Similar Threads

  1. Filter syntax
    By John Cunradi in forum Windows Desktop Applications
    Replies: 11
    Last Post: 01-26-2016, 04:26 AM
  2. Help with DBF.Filter syntax
    By vinyltap in forum Application Server Version 8
    Replies: 4
    Last Post: 08-15-2007, 08:42 AM
  3. Report Filter Syntax
    By MoGrace in forum Alpha Five Version 7
    Replies: 1
    Last Post: 05-25-2007, 09:22 PM
  4. Filter syntax
    By Becky McNichols in forum Alpha Five Version 4
    Replies: 2
    Last Post: 02-08-2002, 01:10 PM
  5. filter syntax
    By john carrio in forum Alpha Five Version 4
    Replies: 7
    Last Post: 05-11-2000, 02:34 PM


Posting Permissions

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