Alpha Video Training
Results 1 to 3 of 3

Thread: Blank Report Parameter

  1. #1
    Member
    Real Name
    Fernando Benavente
    Join Date
    Nov 2008
    Posts
    24

    Default Blank Report Parameter

    I have a report that when run, launches a form that has a date range that the user fills in two fields (from and to). The fields are stored as global variables.

    If the user wants to retrieve all records (regardless of date), they would like to leave the fields blank, however, the result is a report with no data returned.

    I am probably missing something really simple here, but admittedly I am a newbie. Thank you in advance for your help!

    FKB

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

    Default Re: Blank Report Parameter

    Change your report filter, assuming you have something like

    between(somedatefield,from, to)

    to be

    if(from = {},.t.,between(somedatefield,from, to))
    There can be only one.

  3. #3
    Member
    Real Name
    Fernando Benavente
    Join Date
    Nov 2008
    Posts
    24

    Default Re: Blank Report Parameter

    Yes! Thank you Stan.

    FKB

Similar Threads

  1. Blank Spaces In Report
    By MGrasso in forum QReportBuilder
    Replies: 1
    Last Post: 09-19-2008, 01:21 AM
  2. Bug in action scripting report parameter promting
    By goldberg2727 in forum Alpha Five Version 9 - Desktop Applications
    Replies: 2
    Last Post: 07-30-2008, 02:08 AM
  3. Blank Pages in Report
    By borumrm in forum Alpha Five Version 7
    Replies: 6
    Last Post: 06-23-2006, 11:34 AM
  4. blank group on report
    By Becky McNichols in forum Alpha Five Version 4
    Replies: 2
    Last Post: 09-28-2002, 03:30 PM
  5. Report has blank pages
    By attaboy in forum Alpha Five Version 4
    Replies: 3
    Last Post: 03-25-2001, 05:22 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
  •