Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Leonard Trevor
  Where is Leonard Trevor?
 Edinburgh
 United Kingdom
 Leonard Trevor
 Tags
Subject: report field switch based on a condition
Thread ID: 248850 Message ID: 248850 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 23, 2009 7:38:16 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

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