Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
 To: Bebot Chan
  Where is Bebot Chan?
 Saudi Arabia
 Bebot Chan
Subject: RE: Thank you to Foxite and Pete Sass
Thread ID: 22741 Message ID: 22746 # Views: 3 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Thursday, April 24, 2003 4:58:34 PM         

> I was recently asked to come up with a report that prints on pre-printed multi-form, an invoice sort of thing. The snag emerged when I had to put the TOTAL on a specific box. Now I have done this in Foxpro 2.x under DOS for Invoicing and Statement of Account but that was what, over 10 years ago? Add a 7-year hiatus of being away from programming and you're in for a Total Recall syndrome. I don't remember what trick I resorted to in having it appear in the same place. I was persistent in putting it in the Summary band and it didn't work out, the total appeared immediately after the last record. Tried Page Footer and encountered another problem, it printed on every page. Then I remembered Pete Sass' article on Report Writer. Took a glance at it and voila, there it was, the answer to all my heartaches. Then the statement PRINT WHEN RECNO() = RECCOUNT() ran smack like a hotcake pan into my face. Just goes to show how helpful Foxite can be if members are resourceful enough to look into different places like Articles, FAQs, as well as Downloads.
> Pete, you might want to add something to your article. Though the above statement did solve the major problem, I still had to figure out how to make it settle in the box. Then I remembered expanding the Page Footer band which had an inverse effect like the bigger the band (as you drag the band lower with the mouse), the higher in the page the Total is set. (Hope I made myself understood, don't know how to express it any clearer.) Just the same, thanks for the article. It came in handy like a portable reference. BTW, I still create my reports under DOS where I get all the flexibility of inserting texts and fields and boxes without having to go through the burden of opening up the Controls toolbox and dragging the right control into the report, which is literally a "drag". Once I'm happy with it, I transport it to VFP. Is this kosher or is it considered uncool by the now VFP generation? Hope somebody is in with me on this.

Yes I understand about resizing the footer.
On the topic of creating reports in DOS, versus the VFP Report Writer IDE.....
Take a hard look at the abilities to store and create report memory variables
within the report. You can utlize them in a number of ways to create totals,
sums, etc....
As well, this allow for conditional calculations via using the IIF( ) function to
test for conditions and act upon the conditions. This can as well be done
in DOS via hard coding, but the centralized report generator really allows for
a lot of power if you know how to use it.

Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


Thank you to Foxite and Pete Sass Posted by Bebot Chan @ 4/24/2003 3:57:43 PM
RE: Thank you to Foxite and Pete Sass Posted by Pete Sass @ 4/24/2003 4:58:34 PM
RE: Thank you to Foxite and Pete Sass Posted by Bebot Chan @ 4/25/2003 5:36:41 PM