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: Murali Narayanan
  Where is Murali Narayanan?
 Mumbai
 India
 Murali Narayanan
 Tags
Subject: RE: multiple if commands in report
Thread ID: 416071 Message ID: 416078 # Views: 60 # Ratings: 3
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Sunday, December 21, 2014 4:01:03 AM         
   


> Dear All,
> I need to evaluate 3 expressions in a report & possibly display one value (m_box_numb).
> Scenario:-
> 1. I have a report with page size 300 x 480 mm / 3 columns / 8 records vertically / 3 records horizontally / total of 24 records per page / max 1000 records per file
> 2. I need to print the corresponding BOX No. at the page footer for the corresponding page
>
> How to evaluate multiple if conditions in a report??
>
> if between(recno(),1,300) then m_box_numb = "BOX 1"
> if between(recno(),301,600) then m_box_numb = "BOX 2"
> if between(recno(),601,1000) then m_box_numb = "BOX 3"
>
> How do I get the m_box_numb assigned to the proper value during runtime in the report
>
> instead of recno() the expression could be created using _pageno also
>
> Thanks & regards
> Murali Narayan

Aside from the ICASE() inside the report as shown by Tore, why not create a cursor where that Icase() result is a field of the cursor? Then use cursor on your report

https://vfpx.codeplex.com/releases/view/99045
http://sandstorm36.blogspot.com

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