Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Leonard Trevor
  Where is Leonard Trevor?
 Edinburgh
 United Kingdom
 Leonard Trevor
 Tags
Subject: RE: report field switch based on a condition
Thread ID: 248850 Message ID: 248871 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, December 24, 2009 5:21:43 AM         
   


> Dear Expert,
>
> I'm doing a report with 3 fields as follows:
>
>
> idno submit-report submission-date
> -----------------------------------------------------
> 0001 YES 12/12/2008
> 0002 NO
> 0003 YES 24/02/2009
> 0005 NO
> 0006 NO
> 0005
> 0009
> 0010 YES 25/08/2007
>
> They are
>
>
> 1. idno
> 2. submit-report
> 3. submission-date
>
>
>
> When the field submit-report in either 'NO' or EMPTY, the corresponding field 'sumission-date' should return a blank else the submission-date should display the date in a date format.
>
>
> Pls assist with generating the empty or blank ?
>
> Thanks
>
>
> Pl assist ti

Double-click that date field and on Print When, Print Only When Expression is True, type:
submit-report = "YES"

You can optionally tick, remove line if blank.

Jun Tangunan
http://weblogs.foxite.com/sandstorm36/default.aspx
http://www.coderisland.com/forum/viewforum.php?f=10

ENTIRE THREAD

report field switch based on a condition Posted by Leonard Trevor @ 12/23/2009 7:38:16 PM
RE: report field switch based on a condition Posted by ho me @ 12/23/2009 7:54:41 PM
RE: report field switch based on a condition Posted by Jun Tangunan @ 12/24/2009 5:21:43 AM