Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bebot Chan
  Where is Bebot Chan?
 Saudi Arabia
 Bebot Chan
Subject: Thank you to Foxite and Pete Sass
Thread ID: 22741 Message ID: 22741 # Views: 5 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Thursday, April 24, 2003 3:57:43 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.


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