Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: ho me
  Where is ho me?
 
 Philippines
 ho me
 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: 248851 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 23, 2009 7:54:41 PM         
   


> 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


Hi,


You can use IIF() in field expression for the report field.


hth

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