Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ali Koumaiha
  Where is Ali Koumaiha?
 Farmington Hills
 Michigan - Lebanon
 Ali Koumaiha
 To: Murali Narayanan
  Where is Murali Narayanan?
 Mumbai
 India
 Murali Narayanan
 Tags
Subject: RE: multiple if commands in report
Thread ID: 416071 Message ID: 416210 # Views: 31 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Tuesday, December 23, 2014 7:25:07 PM         
   


> Thank you
> Icase works fine though I have no idea what an UDF is
> Problem solved
> regards
> Murali Narayan
>
> >
> > Either you use Icase() instead of if, or you make a UDF.
> >
> > m_box_numb=icase(between(recno(),1,300),'BOX 1',between(recno(),301,600),'BOX 2',between(recno(),601,1000),'BOX 3','ERROR')

> >
> >
> > There's a fine line between helping and adding to the confusion.
> >
> > How to create sample data

UDF = User define Function.

basically making a function that returns a value.

Example:

Select Account,SumAgingBalance(Account) as Balance,Name from SomeTable

And then, you have a function called, say SumAgingBalance()
function SumAgingBalance(tcAccount)
&& do your stuff here
Return SomeBalanceValue
endfunc
Ez Logic

ENTIRE THREAD

multiple if commands in report Posted by Murali Narayan @ 12/20/2014 5:01:53 PM
RE: multiple if commands in report Posted by Tore Bleken @ 12/20/2014 5:17:10 PM
RE: multiple if commands in report Posted by Murali Narayan @ 12/21/2014 5:20:44 AM
RE: multiple if commands in report Posted by Ali Koumaiha @ 12/23/2014 7:25:07 PM
RE: multiple if commands in report Posted by Jun Tangunan @ 12/21/2014 4:01:03 AM
RE: multiple if commands in report Posted by Murali Narayan @ 12/21/2014 5:23:19 AM
RE: multiple if commands in report Posted by Jun Tangunan @ 12/21/2014 7:49:29 AM