Alpha Video Training
Results 1 to 3 of 3

Thread: Using Wildcard w/Variables

  1. #1
    Robert Fishell
    Guest

    Default Using Wildcard w/Variables

    Is there a way to use the wildcard "*" when using the “Variable Ask User” function in a report. I have a number of reports that run based on the contents of either one or multiple fields. Since users sometime don't enter data uniquely (can you imagine) it would be nice to be able to use the Wildcard to find all of the data that I’m looking for. Any suggestions would be appreciated.

    Thanks

    Bob

  2. #2
    "Certified" Alphaholic
    Real Name
    Ohlen Cartmell
    Join Date
    Apr 2000
    Posts
    1,599

    Default RE: Using Wildcard w/Variables

    I believe your objective could be met, but not using the Ask User Variable. Instead, define your variables on the form that calls the report and then in the report definition use the one of the CONTAINS functions or the *ANY function or the $ operator to create the filter expression.

  3. #3
    Robert Fishell
    Guest

    Default RE: Using Wildcard w/Variables

    The *ANY function works fine. I created a calculate field that asks for a character input. That looks like:

    "What_Item" = VAR->ASKC_What_Item_

    Then in the Report Details - Filter I set the following condition:

    *ANY(Field_Name,Calc->What_Item).AND.--- (any other conditions you need)

    It works fine. It will find all records that have any string of data that you enter in the variable field. It does appear to be case sensitive however for characters.

    Thanks for your help. This is a great find.

    Best:

    Bob Fishell

Similar Threads

  1. Wildcard searches
    By David Montalbano in forum Alpha Five Version 6
    Replies: 4
    Last Post: 11-03-2004, 10:40 AM
  2. Variable Wildcard ?
    By John Gamble in forum Alpha Five Version 4
    Replies: 2
    Last Post: 01-28-2002, 04:21 PM
  3. Wildcard search
    By Barry Potter in forum Alpha Five Version 4
    Replies: 8
    Last Post: 07-23-2001, 10:34 AM
  4. Using Wildcard w/Variables
    By Robert Fishell in forum Alpha Five Version 4
    Replies: 7
    Last Post: 11-07-2000, 08:40 AM
  5. Wildcard filters in variables
    By Dan Blank in forum Alpha Five Version 4
    Replies: 9
    Last Post: 05-11-2000, 02:30 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
  •