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
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
Subject: RE: Thank you to Foxite and Pete Sass
Thread ID: 22741 Message ID: 22794 # Views: 3 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Friday, April 25, 2003 5:36:41 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.
> Hi,
> 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 ...


I'm quite sure there have been a lot of improvements on the report writer since the DOS days but I don't really see them as quantum leaps. The SUM and TOTAL of memory variables have been there since dBase IV and Fox 2.5 and yes, you're right, there would be hard codings into snippets. One thing might change my mind though and that that's when VFP decides to embed a report environment (just like data environment) into the forms so we can easily call the form's objects from the report instead of having to create memvars or as others have been clamoring for, an object-oriented report designer.



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